CLUSTER_SLOW_QUERY表结构咨询

这个是我自己整理的
SELECT
Time,REPLACE(Query,’ ‘,’’),Query,
case when Query_time < 1 then CONCAT(ROUND(Query_time*1000,1),‘ms’)
when Query_time < 60 then CONCAT(ROUND(Query_time,1),‘s’)
when Query_time < 3600 then CONCAT(ROUND(Query_time/60,1),‘min’) end Query_time,
case when Mem_max < 1024 then CONCAT(Mem_max,‘B’)
when Mem_max < 1048576 then CONCAT(ROUND(Mem_max/1024,1),‘KiB’)
when Mem_max < 1073741824 then CONCAT(ROUND(Mem_max/1048576,1),‘MiB’)
when Mem_max < 1099511627776 then
CONCAT(ROUND(Mem_max/1073741824,1),‘GiB’) end Mem_max
FROM INFORMATION_SCHEMA.CLUSTER_SLOW_QUERY
WHERE time BETWEEN ‘2021-05-22 16:26:00’ AND ‘2021-05-22 17:00:00’
ORDER BY Query_time DESC
LIMIT 1000;