Documentation

Show information about Distinct Value Caches

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

influxdb3 show system \
  --database 
DATABASE_NAME
\
--token
AUTH_TOKEN
\
table distinct_caches
  • Copy
  • Fill window

This returns a table similar to the following:

tablenamecolumn_idscolumn_namesmax_cardinalitymax_age_seconds
wind_datawind_distinct[0, 1, 2][country, county, city]10000086400
weatherweather_distinct[0][location]100604800
bitcoinbitcoin_dis[0, 1][code, crypto]500086400
homehome_distinct[0, 1][room, wall]1200015770000

Query specific columns from the distinct_caches system table

Use the --select option to query specific columns from the distinct_caches system table. Provide a comma-delimited list of columns to return:

influxdb3 show system \
  --database 
DATABASE_NAME
\
--token
AUTH_TOKEN
\
table distinct_caches \ --select name,column_names,max_age_seconds
  • Copy
  • Fill window

Sort distinct_caches system table output

Use the --order-by option to sort data from the distinct_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 distinct_caches \ --order-by max_cardinality,max_age_seconds
  • Copy
  • Fill window

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 Enterprise admin authentication token

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.2

Key enhancements in InfluxDB 3.2 and the InfluxDB 3 Explorer UI is now generally available.

See the Blog Post

InfluxDB 3.2 is now available for both Core and Enterprise, bringing the general availability of InfluxDB 3 Explorer, a new UI that simplifies how you query, explore, and visualize data. On top of that, InfluxDB 3.2 includes a wide range of performance improvements, feature updates, and bug fixes including automated data retention and more.

For more information, check out: