.show database cache query_results command

Applies to: ✅ Microsoft FabricAzure Data Explorer

Returns a table showing statistics related to the query results cache made against the context database.

Permissions

You must have at least Database User, Database Viewer, or Database Monitor permissions to run this command. For more information, see role-based access control.

Syntax

.show database cache query_results

Learn more about syntax conventions.

Returns

Output parameter Type Description
NodeId string The node identifier.
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.