Skip to content

Instantly share code, notes, and snippets.

@mmattozzi
Created April 19, 2013 00:14
Show Gist options
  • Save mmattozzi/5417191 to your computer and use it in GitHub Desktop.
Save mmattozzi/5417191 to your computer and use it in GitHub Desktop.
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;
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