docs-v2/content/shared/influxdb3-admin/last-value-cache/show.md

Use the influxdb3 show system table command to query and output Last Value Cache information from the last_caches system table.

{{% code-placeholders "DATABASE_NAME|AUTH_TOKEN" %}}

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" %}}

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" %}}

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