selectdb 高CPU占用sql抓取

use information_schema;

select 
t1.query_id as be_query_id,
t1.query_type,
t2.query_id,
t2.workload_group_id,
t2.`database`,
t1.cpu_time,
t2.`sql`
from
(select query_id, query_type,sum(task_cpu_time_ms) as cpu_time from backend_active_tasks group by query_id, query_type) 
t1 left join active_queries t2
on t1.query_id = t2.query_id
order by cpu_time desc limit 10;