Skip to content

Instantly share code, notes, and snippets.

@jarrekk

jarrekk/Postgres cache hit ratio

Forked from mmattozzi/Postgres cache hit ratio
Created July 4, 2019 08:10
Show Gist options
  • Save jarrekk/896ab1d575639801432ddac35d483fea to your computer and use it in GitHub Desktop.
Save jarrekk/896ab1d575639801432ddac35d483fea 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