v.23.12Improvement

Add max/peak RSS to system.asynchronous_metrics

Add max/peak RSS (MemoryResidentMax) into system.asynchronous_metrics. #58095 (Azat Khuzhin).
Added the MemoryResidentMax metric to system.asynchronous_metrics, which reports the maximum (peak) resident set size (RSS) memory usage.

Why it matters

This feature provides users with visibility into the peak memory usage of ClickHouse processes by tracking the maximum resident set size. It helps in monitoring and diagnosing memory consumption patterns and potential memory leaks.

How to use it

Query the system.asynchronous_metrics table to access the new MemoryResidentMax column. For example, use SELECT MemoryResidentMax FROM system.asynchronous_metrics to retrieve the peak RSS value.