Something
public text v1 · immutableselect ts,CASE WHEN COUNT(exec='cmd')>0 THEN 1 ELSE 0 END AS is_running FROM processlist_summary where gkm_id=11 GROUP BY ts;select ts,CASE WHEN COUNT(exec='cmd')>0 THEN 1 ELSE 0 END AS is_running FROM processlist_summary where gkm_id=11 GROUP BY ts;