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:

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

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