v.25.6Improvement

Add profile event PageCacheReadBytes

Add profile event PageCacheReadBytes. #81742 (Kseniia Sumarokova).
Added a new profile event named PageCacheReadBytes to ClickHouse to track the number of bytes read from the page cache.

Why it matters

This feature provides detailed monitoring of how much data is being read from the page cache during query execution, enabling users to better understand query performance and resource utilization related to cache usage.

How to use it

Users can monitor the PageCacheReadBytes profile event in query system tables or profiling tools to analyze the volume of data read from the page cache for individual queries.