logoalt Hacker News

qeternityyesterday at 11:18 AM1 replyview on HN

Does not instill confidence when the queries they provide don't work.

For anyone curious, the corrected query:

SELECT sum(blks_hit)::numeric / nullif(sum(blks_hit + blks_read), 0) AS cache_hit_ratio FROM pg_stat_database;


Replies

itiswatitisyesterday at 6:08 PM

I just ran their query, and it works