---
title: Show information about Last Value Caches
description: Use the influxdb3 show system table command to query and output Last Value Cache information from the last_caches system table.
url: https://docs.influxdata.com/influxdb3/enterprise/admin/last-value-cache/show/
estimated_tokens: 941
product: InfluxDB 3 Enterprise
version: enterprise
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb3/enterprise/admin/last-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/enterprise/reference/cli/influxdb3/show/system/table/)to query and output Last Value Cache information from the `last_caches` system table.

```bash
influxdb3 show system \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  table last_caches
```

This returns a table similar to the following:

| table |    name     |key\_column\_ids|key\_column\_names|value\_column\_ids|                value\_column\_names                |count| ttl |
|-------|-------------|----------------|------------------|------------------|----------------------------------------------------|-----|-----|
|weather|weather\_last|      [0]       |    [location]    | [2, 3, 4, 5, 1]  |[precip, temp\_avg, temp\_max, temp\_min, wind\_avg]|  1  |86400|
|bitcoin|bitcoin\_last|     [0, 1]     |  [code, crypto]  |       [4]        |                      [price]                       |  1  |14400|
|numbers|numbers\_last|       []       |        []        |      [0, 1]      |                       [a, b]                       |  5  |14400|
| home  | home\_last  |      [0]       |      [room]      |    [1, 2, 3]     |                  [temp, hum, co]                   |  5  | 60  |

## Query specific columns from the last\_caches system table

Use the `--select` option to query specific columns from the `last_caches`system table. Provide a comma-delimited list of columns to return:

```bash
influxdb3 show system \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  table last_caches \
  --select name,key_column_names,value_column_names
```

## Sort last\_caches system table output

Use the `--order-by` option to sort data from the `last_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 last_caches \
  --order-by table,ttl
```

> [!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 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 last value 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.last_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.last_caches WHERE name = '\''CACHE_NAME'\''",
    "format": "json"
  }'
```

#### Related

* [Manage Last Value Caches with InfluxDB 3 Explorer](/influxdb3/explorer/manage-caches/last-value-caches/)

[cache](/influxdb3/enterprise/tags/cache/)
| table | name | key_column_ids | key_column_names | value_column_ids | value_column_names | count | ttl |
| --- | --- | --- | --- | --- | --- | --- | --- |
| table | name | key_column_ids | key_column_names | value_column_ids | value_column_names | count | ttl |
| weather | weather_last | [0] | [location] | [2, 3, 4, 5, 1] | [precip, temp_avg, temp_max, temp_min, wind_avg] | 1 | 86400 |
| bitcoin | bitcoin_last | [0, 1] | [code, crypto] | [4] | [price] | 1 | 14400 |
| numbers | numbers_last | [] | [] | [0, 1] | [a, b] | 5 | 14400 |
| home | home_last | [0] | [room] | [1, 2, 3] | [temp, hum, co] | 5 | 60 |