jcspencer/-

Created October 19, 2014 22:15

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jcspencer/6349942c8926f84bbcf8.js"></script>
Save jcspencer/6349942c8926f84bbcf8 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

-

SELECT sum(heap_blks_hit) / (1 + sum(heap_blks_hit) + sum(heap_blks_read)) AS ratio FROM pg_statio_user_tables

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment