Documentation

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:

tablenamekey_column_idskey_column_namesvalue_column_idsvalue_column_namescountttl
weatherweather_last[0][location][2, 3, 4, 5, 1][precip, temp_avg, temp_max, temp_min, wind_avg]186400
bitcoinbitcoin_last[0, 1][code, crypto][4][price]114400
numbersnumbers_last[][][0, 1][a, b]514400
homehome_last[0][room][1, 2, 3][temp, hum, co]560

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 from
  • AUTH_TOKEN: your InfluxDB 3 Core authentication token

Use the HTTP API

To use the HTTP API to query and output cache information from the system table, send a GET or POST request to the /api/v3/query_sql endpoint.

GET /api/v3/query_sql
POST /api/v3/query_sql

Query all last value caches

curl -X POST "https://localhost:8181/api/v3/query_sql" \
  --header "Authorization: Bearer 
AUTH_TOKEN
"
\
--json '{ "db": "
DATABASE_NAME
",
"q": "SELECT * FROM system.last_caches", "format": "json" }'

Query specific cache details

curl -X POST "https://localhost:8181/api/v3/query_sql" \
  --header "Authorization: Bearer 
AUTH_TOKEN
"
\
--json '{ "db": "
DATABASE_NAME
",
"q": "SELECT * FROM system.last_caches WHERE name = '\''
CACHE_NAME
'
\''",
"format": "json" }'

Was this page helpful?

Thank you for your feedback!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

New in InfluxDB 3.5

Key enhancements in InfluxDB 3.5 and the InfluxDB 3 Explorer 1.3.

See the Blog Post

InfluxDB 3.5 is now available for both Core and Enterprise, introducing custom plugin repository support, enhanced operational visibility with queryable CLI parameters and manual node management, stronger security controls, and general performance improvements.

InfluxDB 3 Explorer 1.3 brings powerful new capabilities including Dashboards (beta) for saving and organizing your favorite queries, and cache querying for instant access to Last Value and Distinct Value caches—making Explorer a more comprehensive workspace for time series monitoring and analysis.

For more information, check out: