v.19.14New Feature

New System.metric_log Table Which Stores Values of System.events and System.metrics with Specified Time Interval

New system.metric_log table which stores values of system.events and system.metrics with specified time interval. #6363 #6467 (Nikita Mikhaylov) #6530 (alexey-milovidov)
Introduced a new system.metric_log table that records values of system.events and system.metrics at specified time intervals.

Why it matters

To provide users with historical tracking and analysis of system events and metric values over time, enabling performance monitoring, auditing, and diagnostics without manual logging setup.

How to use it

The system.metric_log table can be queried like any other system table. Users can configure the frequency of metric snapshots via configuration settings to control the logging interval. This allows continuous and automated recording of system metrics for later inspection.