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
This returns a table similar to the following:
| table | name | column_ids | column_names | max_cardinality | max_age_seconds |
|---|---|---|---|---|---|
| wind_data | wind_distinct | [0, 1, 2] | [country, county, city] | 100000 | 86400 |
| weather | weather_distinct | [0] | [location] | 100 | 604800 |
| bitcoin | bitcoin_dis | [0, 1] | [code, crypto] | 5000 | 86400 |
| home | home_distinct | [0, 1] | [room, wall] | 12000 | 15770000 |
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
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
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 Core 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 Core and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.