v.23.8Improvement

Add Asynchronous Metrics for MergeTree Tables in System Database

Add asynchronous metrics about tables in the system database. For example, TotalBytesOfMergeTreeTablesSystem. This closes #53603. #53604 (Alexey Milovidov).
Introduces asynchronous metrics about tables in the system database, such as TotalBytesOfMergeTreeTablesSystem.

Why it matters

This feature provides users with new asynchronous system-level metrics that help monitor and analyze table-related statistics more efficiently, improving observability and performance tracking of MergeTree tables.

How to use it

Users can query the newly added asynchronous metrics directly from the system database using standard SELECT statements. For example, to get the total bytes of MergeTree tables, query the TotalBytesOfMergeTreeTablesSystem metric.