Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure Data Explorer
Returns a table showing statistics related to the query results cache made against the context database.
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.
.show database cache query_results
Learn more about syntax conventions.
| 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. |