Skip to content

Instantly share code, notes, and snippets.

@carameleon

carameleon/Postgres cache hit ratio

Forked from mmattozzi/Postgres cache hit ratio
Created September 8, 2020 10:21
Show Gist options
  • Save carameleon/b26a00e347cb8190642d40ce3b66f995 to your computer and use it in GitHub Desktop.
Save carameleon/b26a00e347cb8190642d40ce3b66f995 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Postgres cache hit ratio
SELECT
sum(heap_blks_read) as heap_read,
sum(heap_blks_hit) as heap_hit,
sum(heap_blks_hit) / (sum(heap_blks_hit) + sum(heap_blks_read)) as ratio
FROM
pg_statio_user_tables;
Raw
Postgres index cache hit ratio
SELECT
sum(idx_blks_read) as idx_read,
sum(idx_blks_hit) as idx_hit,
(sum(idx_blks_hit) - sum(idx_blks_read)) / sum(idx_blks_hit) as ratio
FROM
pg_statio_user_indexes;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment