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

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

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 from
  • AUTH_TOKEN: your InfluxDB 3 Enterprise admin 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 caches

curl -X POST "https://localhost:8181/api/v3/query_sql" \
  --header "Authorization: Bearer 
AUTH_TOKEN
"
\
--json '{ "db": "
DATABASE_NAME
",
"q": "SELECT * FROM system.distinct_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.distinct_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.4

Key enhancements in InfluxDB 3.4 and the InfluxDB 3 Explorer 1.2.

See the Blog Post

InfluxDB 3.4 is now available for both Core and Enterprise, which introduces offline token generation for use in automated deployments and configurable license type selection that lets you bypass the interactive license prompt. InfluxDB 3 Explorer 1.2 is also available, which includes InfluxDB cache management and other new features.

For more information, check out: