New answers tagged


FWIW here's a query I've been using SELECT relname AS table, indexrelname AS index, pg_size_pretty(pg_relation_size(i.indexrelid)) AS index_size, idx_scan as index_scans FROM pg_stat_user_indexes ui JOIN pg_index i ON ui.indexrelid = i.indexrelid WHERE NOT indisunique AND idx_scan =0 AND pg_relation_size(relid) > 5 * 8192 ORDER BY ...

Top 50 recent answers are included