.show database cache query_results command
Applies to: ✅ Microsoft Fabric ✅ Azure 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. |