KingbaseES慢SQL查询

1、最耗IO SQL、单次调用最耗IO SQLTOP 5:

select userid::regrole, dbid, query from sys_stat_statements

where calls<>0 order by (blk_read_time+blk_write_time)/calls desc limit 5;

2、总最耗IO SQL TOP 5:

select userid::regrole, dbid, query from sys_stat_statements

order by (blk_read_time+blk_write_time) desc limit 5;

3、最耗时 SQL，单次调用最耗时 SQLTOP 5:

select userid::regrole, dbid, query from sys_stat_statements

order by mean_exec_time desc limit 5;

4、总最耗时 SQLTOP 5:

select userid::regrole, dbid, query from sys_stat_statements

order by total_exec_time desc limit 5;

5、响应时间抖动最严重 SQL:

select userid::regrole, dbid, query from sys_stat_statements

order by stddev_exec_time desc limit 5;

6、最耗共享内存 SQL:

select userid::regrole, dbid, query from sys_stat_statements

order by (shared_blks_hit+shared_blks_dirtied) desc limit 5;

7、最耗临时空间 SQL:

select userid::regrole, dbid, query from sys_stat_statements

order by temp_blks_written desc limit 5;