v.20.5New Feature

Add system.asynchronous_metric_log table for historical metrics logging

Add the system.asynchronous_metric_log table that logs historical metrics from system.asynchronous_metrics. #11588 (Alexander Kuzmenkov).
Added the system.asynchronous_metric_log system table that provides historical logs of metrics collected from system.asynchronous_metrics.

Why it matters

This feature enables users to analyze historical asynchronous metrics over time, solving the problem of only having current snapshot metrics available in system.asynchronous_metrics. It adds value by allowing trend analysis, troubleshooting, and performance monitoring using past metric data.

How to use it

Users can query the system.asynchronous_metric_log table directly with SELECT statements to retrieve historical asynchronous metrics logged by ClickHouse. No special configuration is required to enable it as it is a built-in system table.