---
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/core/admin/distinct-value-cache/show/
estimated_tokens: 854
product: InfluxDB 3 Core
version: core
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb3/core/admin/distinct-value-cache/show/
date: '2025-08-29T08:44:59-06:00'
lastmod: '2025-08-29T08:44:59-06:00'
---

Use the [`influxdb3 show system table` command](/influxdb3/core/reference/cli/influxdb3/show/system/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
```

> [!Note]
> 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 Core

  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

```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/core/tags/cache/)
| table | name | column_ids | column_names | max_cardinality | max_age_seconds |
| --- | --- | --- | --- | --- | --- |
| 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 |