SELECT schemaname, relid::regclass AS TABLE , indexrelid::regclass AS INDEX, pg_size_pretty( pg_relation_size( indexrelid::regclass )) AS index_size, idx_tup_read, idx_tup_fetch, idx_scan, Indisunique, Indisprimary FROM pg_stat_user_indexes JOIN pg_index USING ( indexrelid ) WHERE idx_scan = 0 --AND pg_size_pretty(pg_relation_size(indexrelid::regclass)) >= '81 bytes' AND indisunique IS FALSE ORDER BY pg_relation_size(indexrelid) DESC;
