.show database cache query_results
Returns a table showing statistics related to the query results cache made against the context database.
Syntax
.show database cache query_results
Output
| Output parameter | Type | Description |
|---|---|---|
| NodeId | string |
Identifier of the cluster node. |
| Hits | long |
The number of cache hits. |
| Misses | long |
The number of cache misses. |
| CacheCapacityInBytes | long |
The cache capacity in bytes. |
| UsedBytes | long |
The cache used space. |
| Count | long |
The number of unique query results stored in the cache. |