tidb 5.4.0 dashboard问题

这个应该是已知bug后续修复了。可以参考这个帖子 Dashboard慢查询界面缺少列

或者通过sql查询,效果一样

SELECT
INSTANCE 实例,Time 时间,REPLACE(Query,’ ‘,’') 查询语句,Query 查询语句,Process_keys,Total_keys,Total_keys-Process_keys,
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 查询耗时,
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 内存使用
FROM INFORMATION_SCHEMA.CLUSTER_SLOW_QUERY t
WHERE time BETWEEN ‘2022-01-01 07:00:00’ AND ‘2022-01-01 18:00:00’
ORDER BY t.Mem_max DESC
LIMIT 1000;