We can add shared_blks_hit, shared_blks_read, shared_blks_dirtied and shared_blks_written to pg_query metrics collector, which provide detailed info about queries.
SELECT datname, queryid AS query, sum(calls) AS calls, sum(rows) AS rows, sum(total_exec_time) AS exec_time, sum(blk_read_time) + sum(blk_write_time) AS io_time, sum(wal_bytes) AS wal_bytes
,sum(shared_blks_hit) AS sblk_hit, sum(shared_blks_read) AS sblk_read, sum(shared_blks_dirtied) AS sblk_dirtied, sum(shared_blks_written) AS sblk_written
FROM pg_stat_statements(false) s JOIN pg_database d ON s.dbid = d.oid WHERE userid != 10 AND calls > 4 GROUP BY 1, 2 ORDER BY 3 DESC LIMIT 128;
Vonng
commented
9 months ago
We can add shared_blks_hit, shared_blks_read, shared_blks_dirtied and shared_blks_written to pg_query metrics collector, which provide detailed info about queries.