Sha256: 468c29df004b1a101c2fc54d1316a1280f423f8bbf3c65e4fdd0478b9e7f45ab
Contents?: true
Size: 459 Bytes
Versions: 40
Compression:
Stored size: 459 Bytes
Contents
/* Calculates your cache hit rate for reading indexes */
SELECT
relname AS name,
idx_blks_hit AS buffer_hits,
idx_blks_read AS block_reads,
idx_blks_hit + idx_blks_read AS total_read,
CASE (idx_blks_hit + idx_blks_read)::float
WHEN 0 THEN 'Insufficient data'
ELSE (idx_blks_hit / (idx_blks_hit + idx_blks_read)::float)::text
END ratio
FROM
pg_statio_user_tables
ORDER BY
idx_blks_hit / (idx_blks_hit + idx_blks_read + 1)::float DESC;
Version data entries
40 entries across 40 versions & 1 rubygems