select userid::regrole, dbid, query from pg_stat_statements order by (blk_read_time+blk_write_time)/calls desc limit 5; 1. 总最耗IO SQL TOP 5 select userid::regrole, dbid, query from pg_stat_statements order by (blk_read_time+blk_write_time) desc limit 5; 1. 最耗时 SQL 平均...
执行如下命令,查询总最耗时 SQL TOP 5。 select userid::regrole, dbid, query from pg_stat_statements order by total_time desc limit 5; 响应时间抖动最严重 SQL 执行如下命令,查询响应时间抖动最严重 SQL。 select userid::regrole, dbid, query from pg_stat_statements order by stddev_time desc lim...
select userid::regrole, dbid, query from pg_stat_statements order by (blk_read_time+blk_write_time) desc limit 5; 最耗时 SQL 执行如下命令,查询单次调用最耗时 SQL TOP 5。 select userid::regrole, dbid, query from pg_stat_statements order by mean_time desc limit 5; 执行如下命令,查询总...
select userid::regrole, dbid, query from pg_stat_statements order by (blk_read_time+blk_write_time) desc limit 5; 最耗时 SQL,单次调用最耗时 SQL TOP 5 select userid::regrole, dbid, query from pg_stat_statements order by mean_time desc limit 5; 总最耗时 SQL TOP 5 select userid::...
检查长事务top5 代码语言:javascript 复制 select to_char(now(),'yyyy-mm-dd hh24:mi:ss') "巡检时间" ,a.datname "datname(数据库名)" ,a.pid "pid(进程id)" ,b.rolname "username(用户名)" --,a.application_name "app_name(应用名称)" ,a.client_addr "client_ip(客户端ip)" --,a.xa...
单次调用最耗IO SQL TOP 5 select userid::regrole, dbid, query from pg_stat_statements order by (blk_read_time+blk_write_time)/calls desc limit 5; 总最耗IO SQL TOP 5 select userid::regrole, dbid, query from pg_stat_statements order by (blk_read_time+blk_write_time) desc limit ...
5. 数据块的读写时间。 常用的统计sql参考 最耗IO SQL,单次调用最耗IO SQL TOP 5 select userid::regrole, dbid, query from pg_stat_statements order by (blk_read_time+blk_write_time)/calls desc limit 5; 总最耗IO SQL TOP 5 select userid::regrole, dbid, query from pg_stat_statements ...
MySQL 不支持OVER 子句, 而 Pg 支持. OVER 子句能简单的解决 "每组取 top 5" 的这类问题.几乎任何...
select relowner::regrole,relname,relkind,relpages,reltuples from pg_class where relname='t1'; 查看膨胀高的表TOP 10,如果膨胀太高需要执行,例如 vacuum t1,vacuum不会锁表,vacuum full会锁表 代码语言:javascript 复制 SELECTrelnameASTABLE_NAME,pg_size_pretty(pg_relation_size(schemaname||'.'||relnam...
查看表膨胀 TOP5 SELECT current_database() AS db, schemaname, tablename, reltuples::bigint AS tups, relpages::bigint AS pages, otta, ROUND(CASE WHEN otta=0 OR sml.relpages=0 OR sml.relpages=otta THEN 0.0 ELSE sml.relpages/otta::numeric END,1) AS tbloat, ...