Sha256: 159bcf580bb54cd9da6d42f3e24e3bce4b04ca58a77c9af36349cd713dc080d5
Contents?: true
Size: 492 Bytes
Versions: 40
Compression:
Stored size: 492 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
WHERE
schemaname = '%{schema}'
ORDER BY
idx_blks_hit / (idx_blks_hit + idx_blks_read + 1)::float DESC;
Version data entries
40 entries across 40 versions & 1 rubygems