获取buffer读最多的语句
最近更新时间: 2024-06-12 15:06:00
postgres=# select
pg_authid.rolname as rolname,
pg_database.datname as datname,
pg_stat_statements.query,
pg_stat_statements.shared_blks_hit,
pg_stat_statements.shared_blks_read,
(pg_stat_statements.shared_blks_hit+pg_stat_statements.shared_blks_read) as all_blks,
pg_stat_statements.calls,
pg_stat_statements.total_time,
pg_stat_statements.total_time/pg_stat_statements.calls
from
pg_stat_statements
inner join pg_authid on pg_authid.oid=pg_stat_statements.userid
inner join pg_database on pg_database.oid= pg_stat_statements.dbid
order by
pg_stat_statements.shared_blks_hit+pg_stat_statements.shared_blks_read desc
limit 10;