---
title: Show information about Distinct Value Caches
description: Use the influxdb3 show system table command to query and output Distinct Value Cache information from the distinct_caches system table.
url: https://docs.influxdata.com/influxdb3/enterprise/admin/distinct-value-cache/show/
estimated_tokens: 2707
product: InfluxDB 3 Enterprise
version: enterprise
---

# Show information about Distinct Value Caches

Use the [`influxdb3 show system table` command](/influxdb3/enterprise/reference/cli/influxdb3/show/syste/table/) to query and output Distinct Value Cache information from the `distinct_caches` system table.

```bash
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:

```bash
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:

```bash
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](/influxdb3/enterprise/api/query-data/#operation/GetExecuteQuerySQL)

[POST /api/v3/query\_sql](/influxdb3/enterprise/api/query-data/#operation/PostExecuteQuerySQL)

### Query all caches

```bash
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

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

#### Related

-   [Manage Distinct Value Caches with InfluxDB 3 Explorer](/influxdb3/explorer/manage-caches/distinct-value-caches/)

[cache](/influxdb3/enterprise/tags/cache/)