postgresguide.com icon indicating copy to clipboard operation
postgresguide.com copied to clipboard

Index cache hit rate SQL is incorrect

Open Valve opened this issue 10 years ago • 0 comments

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;

Valve avatar Aug 03 '15 06:08 Valve