Tabelas com maior quantidade de registros em cache - PostgreSQL

tables_at_buffercache.sql

SELECT d.datname, c.relname
, pg_size_pretty(count(*) * 8192) as buffered
, round(100.0 * count(*) / ( SELECT setting FROM pg_settings WHERE name='shared_buffers')::integer,1) AS buffers_percent
, round(100.0 * count(*) * 8192 / pg_relation_size(c.oid),1) AS percent_of_relation
FROM pg_class c
INNER JOIN pg_buffercache b ON b.relfilenode = c.relfilenode
INNER JOIN pg_database d ON (b.reldatabase = d.oid)
WHERE pg_relation_size(c.oid) > 0
GROUP BY c.oid, d.datname, c.relname
ORDER BY 4 DESC
LIMIT 10;