Sha256: bb0b3c8e66391405ae7975aa82cb66c1807c7237cfb3823e8db1368419be83ad
Contents?: true
Size: 312 Bytes
Versions: 50
Compression:
Stored size: 312 Bytes
Contents
/* Index hit rate (effective databases are at 99% and up) */
SELECT relname,
CASE idx_scan
WHEN 0 THEN 'Insufficient data'
ELSE (100 * idx_scan / (seq_scan + idx_scan))::text
END percent_of_times_index_used,
n_live_tup rows_in_table
FROM
pg_stat_user_tables
ORDER BY
n_live_tup DESC;
Version data entries
50 entries across 50 versions & 3 rubygems