Skip to content

Instantly share code, notes, and snippets.

@StevenJL

StevenJL/psql_cache_hit_ratio.psql

Created January 31, 2021 04:30
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save StevenJL/488b46f813e7066193641f412e506427 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save StevenJL/488b46f813e7066193641f412e506427 to your computer and use it in GitHub Desktop.
Download ZIP
Psql Overall Cache Hit Ratio
Raw
psql_cache_hit_ratio.psql
SELECT
SUM(heap_blks_hit) / (SUM(heap_blks_hit) + SUM(heap_blks_read)) as cache_hit_ratio;
FROM
pg_statio_user_tables;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment