v.22.9Improvement

Add More Metrics for On-Disk Temporary Data

Add more metrics for on-disk temporary data, close #40206. #40239 (Vladimir C).
Added additional metrics for monitoring on-disk temporary data in ClickHouse.

Why it matters

This feature improves observability of the on-disk temporary data by providing more detailed metrics. It helps users to better understand and track the usage and performance impact of temporary data stored on disk during query processing.

How to use it

Users can access the new metrics through the existing system metrics interfaces in ClickHouse. No special configuration is required beyond upgrading to the ClickHouse version that includes this feature.