# SHOW CROSS\_QUERY\_STATS\_CACHE STATUS

Shows aggregate statistics about the cross query stats cache on the connected aggregator.

## Syntax

```sql
SHOW cross_query_stats_cache STATUS;
```

## Example

```sql
SHOW cross_query_stats_cache STATUS;

```

```output

| Stat                       | Value   |
|----------------------------|---------|
| Total Lookup Count         | 4       |
| Total Cache Hits           | 3       |
| Total Cache Misses         | 1       |
| Number of Cache Entries    | 3       |
| Total Memory in Use (bytes)| 131520  |
```

| Field                       | Description                                       |
| --------------------------- | ------------------------------------------------- |
| Total Lookup Count          | The total number of cache lookups.                |
| Total Cache Hits            | The number of lookups that found an entry.        |
| Total Cache Misses          | The number of lookups that did not find an entry. |
| Number of Cache Entries     | The current number of entries in the cache.       |
| Total Memory in Use (bytes) | Approximate amount of memory used by the cache.   |

## Related Topic

* [DROP ... FROM CROSS\_QUERY\_STATS\_CACHE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-from-cross-query-stats-cache.md)

***

Modified at: April 30, 2026

Source: [/db/v9.1/reference/sql-reference/show-commands/show-cross-query-stats-cache-status/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-cross-query-stats-cache-status/)

(An index of the documentation is available at /llms.txt)