v.23.8New Feature

New query_cache_usage field in system.query_log shows query cache usage

Official CH changelog text
A new field query_cache_usage in system.query_log now shows if and how the query cache was used. #52384 (Robert Schulze).
Introduces a new field query_cache_usage in the system.query_log table that indicates whether and how the query cache was utilized for each query.

Why it matters

This feature helps users monitor and analyze the effectiveness of the query cache by providing detailed information on its usage per query, enabling better performance tuning and troubleshooting.

How to use it

Users can query the system.query_log table and examine the query_cache_usage field to see cache usage details for completed queries. No additional configuration is required to enable this field; it is available by default.

Related resources

PreviousNext