Contents

/* Index and table hit rate */

SELECT
  'index hit rate' AS name,
  (sum(idx_blks_hit)) / nullif(sum(idx_blks_hit + idx_blks_read),0) AS ratio
FROM pg_statio_user_indexes
UNION ALL
SELECT
 'table hit rate' AS name,
  sum(heap_blks_hit) / nullif(sum(heap_blks_hit) + sum(heap_blks_read),0) AS ratio
FROM pg_statio_user_tables;

Version data entries

50 entries across 50 versions & 3 rubygems

Version	Path
ruby-pg-extras-2.3.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-2.2.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-2.1.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-2.0.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.6.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.5.3	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.5.2	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.5.1	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.5.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.4.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.3.1	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.3.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.2.4	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.2.3	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.2.2	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.2.1	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.2.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.1.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-1.0.0	lib/ruby-pg-extras/queries/cache_hit.sql
ruby-pg-extras-0.7.0	lib/ruby-pg-extras/queries/cache_hit.sql