Show information about Last Value Caches
Use the influxdb3 show system table command
to query and output Last Value Cache information from the last_caches system table.
influxdb3 show system \
--database DATABASE_NAME \
--token AUTH_TOKEN \
table last_caches
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:
influxdb3 show system \
--database DATABASE_NAME \
--token AUTH_TOKEN \
table last_caches \
--select name,key_column_names,value_column_names
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:
influxdb3 show system \
--database DATABASE_NAME \
--token AUTH_TOKEN \
table last_caches \
--order-by table,ttl
Results are sorted in ascending order based on the provided columns.
In the examples above, replace the following:
DATABASE_NAME: the name of the database to query system data fromAUTH_TOKEN: your InfluxDB 3 Enterprise admin authentication token
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.