# MV\_CROSS\_QUERY\_STATS\_CACHE

This view is a managed view that aggregates cross-query stats cache entries across all aggregators in the cluster. Use this view to get a cluster‑wide picture of cache utilization and distribution.

| Column Name            | Description                                                                                                                                                                                        |
| ---------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `HASH`                 | 64‑bit hash of the query or subquery shape used as the cache key; matches the`fr_track_hash`seen in query profiles. Queries are hashed to integer values in order to look up associated rowcounts. |
| `ROWCOUNT_INITIALIZED` | Boolean flag indicating whether the entry has a rowcount associated with it. This may be false if the entry is tied to a sampling query that has not yet finished.                                 |
| `ROWCOUNT`             | Rowcount associated with the entry.                                                                                                                                                                |
| `HIT_COUNT`            | Total number of times the entry has been written to and read from once rowcounts have been initialized.                                                                                            |
| `QUERY_TEXT`           | This column is empty by default to save memory. Once`enable_cross_query_stats_store_query_text`is enabled, the query text associated with the entry. Currently works for sampling queries only.    |
| `LAST_HIT_TIME`        | The last time the entry was used, either by reading from it or writing to it. The time is based on the number of ticks since the server started up. There is no conversion to a Unix timestamp.    |
| `LAST_UPDATE_TIME`     | The last time the entry was written to. The time is based on the number of ticks since the server started up. There is no conversion to a Unix timestamp.                                          |
| `ADDED_TIME`           | The time the entry was created. The time is based on the number of ticks since the server started up. There is no conversion to a Unix timestamp.                                                  |

In addition to these columns, which are the same columns for `CROSS_QUERY_STATS_CACHE`, this managed view includes node‑level columns that mirror the definitions used in the `MV_NODES` managed view:

| Column Name | Description                                                                             |
| ----------- | --------------------------------------------------------------------------------------- |
| `NODE_ID`   | The`ID`of the node. This`ID`matches the`node_id`reported for tasks running on the node. |
| `IP_ADDR`   | The IP address of the node.                                                             |
| `PORT`      | The port on which the node is listening.                                                |
| `TYPE`      | The type of a given node: MA, leaf, or CA.                                              |

***

Modified at: April 22, 2026

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-cross-query-stats-cache/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-cross-query-stats-cache/)

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