69 lines
2.6 KiB
Markdown
69 lines
2.6 KiB
Markdown
|
|
Use the [`influxdb3 show system table` command](/influxdb3/version/reference/cli/influxdb3/show/syste/table/)
|
|
to query and output Last Value Cache information from the `last_caches` system table.
|
|
|
|
{{% code-placeholders "DATABASE_NAME|AUTH_TOKEN" %}}
|
|
<!-- pytest.mark.skip -->
|
|
|
|
```bash
|
|
influxdb3 show system \
|
|
--database DATABASE_NAME \
|
|
--token AUTH_TOKEN \
|
|
table last_caches
|
|
```
|
|
{{% /code-placeholders %}}
|
|
|
|
This returns a table similar to the following:
|
|
|
|
| table | name | key_column_ids | key_column_names | value_column_ids | value_column_names | count | ttl |
|
|
| ------- | ------------ | -------------- | ---------------- | ---------------- | ------------------------------------------------ | ----- | ----- |
|
|
| weather | weather_last | [0] | [location] | [2, 3, 4, 5, 1] | [precip, temp_avg, temp_max, temp_min, wind_avg] | 1 | 86400 |
|
|
| bitcoin | bitcoin_last | [0, 1] | [code, crypto] | [4] | [price] | 1 | 14400 |
|
|
| numbers | numbers_last | [] | [] | [0, 1] | [a, b] | 5 | 14400 |
|
|
| home | home_last | [0] | [room] | [1, 2, 3] | [temp, hum, co] | 5 | 60 |
|
|
|
|
## Query specific columns from the last_caches system table
|
|
|
|
Use the `--select` option to query specific columns from the `last_caches`
|
|
system table. Provide a comma-delimited list of columns to return:
|
|
|
|
{{% code-placeholders "DATABASE_NAME|AUTH_TOKEN" %}}
|
|
<!-- pytest.mark.skip -->
|
|
|
|
```bash
|
|
influxdb3 show system \
|
|
--database DATABASE_NAME \
|
|
--token AUTH_TOKEN \
|
|
table last_caches \
|
|
--select name,key_column_names,value_column_names
|
|
```
|
|
{{% /code-placeholders %}}
|
|
|
|
## Sort last_caches system table output
|
|
|
|
Use the `--order-by` option to sort data from the `last_caches` system table by
|
|
specific columns. Provide a comma-delimited list of columns to sort by:
|
|
|
|
{{% code-placeholders "DATABASE_NAME|AUTH_TOKEN" %}}
|
|
<!-- pytest.mark.skip -->
|
|
|
|
```bash
|
|
influxdb3 show system \
|
|
--database DATABASE_NAME \
|
|
--token AUTH_TOKEN \
|
|
table last_caches \
|
|
--order-by table,ttl
|
|
```
|
|
{{% /code-placeholders %}}
|
|
|
|
> [!Note]
|
|
> Results are sorted in ascending order based on the provided columns.
|
|
|
|
In the examples above, replace the following:
|
|
|
|
- {{% code-placeholder-key %}}`DATABASE_NAME`{{% /code-placeholder-key %}}:
|
|
the name of the database to query system data from
|
|
- {{% code-placeholder-key %}}`AUTH_TOKEN`{{% /code-placeholder-key %}}:
|
|
your {{< product-name >}} {{% show-in "enterprise" %}}admin {{% /show-in %}}
|
|
authentication token
|