.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.