Click House CPU使用峰值变化趋势

CPU使用峰值变化趋势

with interval 5 minute as time_frame_size -- 时间间隔，当前是5分钟
, 20 as bar_width -- 条状图的宽度，当前是30
, now() - interval 24 hour as time_start
, now() as time_end
select
toStartOfInterval(event_time, time_frame_size) as timeframe,
maxIf(value, metric = 'OSUserTimeNormalized') as cpu_usr,
maxIf(value, metric = 'OSSystemTimeNormalized') as cpu_sys,
bar(cpu_usr, 0, 1, bar_width) as barCPU_usr,
bar(cpu_sys, 0, 1, bar_width) as barCPU_sys
from system.asynchronous_metric_log
where metric in ['OSUserTimeNormalized', 'OSSystemTimeNormalized'] and event_time >= time_start and event_time <= time_end
group by timeframe
order by timeframe desc;