# Pastebin mpyY1a83
127.0.0.1 postgres@musicbrainz_db=# SELECT                          
nspname,relname,
round(100 * pg_relation_size(indexrelid) /
pg_relation_size(indrelid)) / 100
AS index_ratio,
pg_size_pretty(pg_relation_size(indexrelid))
AS index_size,
pg_size_pretty(pg_relation_size(indrelid))
AS table_size
FROM pg_index I
LEFT JOIN pg_class C ON (C.oid = I.indexrelid)
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE
nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND
C.relkind='i' AND
pg_relation_size(indrelid) > 0 AND pg_relation_size(indexrelid) > 1000000 AND  pg_relation_size(indexrelid) / pg_relation_size(indrelid) > 0.5 ORDER by index_ratio;
┌─────────────┬────────────────────────────────────────────┬─────────────┬────────────┬────────────┐
│   nspname   │                  relname                   │ index_ratio │ index_size │ table_size │
├─────────────┼────────────────────────────────────────────┼─────────────┼────────────┼────────────┤
│ musicbrainz │ artist_tag_raw_pkey                        │        1.01 │ 12 MB      │ 12 MB      │
│ musicbrainz │ artist_credit_name_idx_musicbrainz_collate │        1.04 │ 145 MB     │ 138 MB     │
│ musicbrainz │ l_series_work_idx_entity1                  │        1.86 │ 6744 kB    │ 3608 kB    │
│ musicbrainz │ release_raw_idx_modify_count               │        2.22 │ 83 MB      │ 37 MB      │
│ musicbrainz │ l_series_work_pkey                         │        2.35 │ 8480 kB    │ 3608 kB    │
│ musicbrainz │ medium_index_idx                           │        3.36 │ 635 MB     │ 189 MB     │
│ musicbrainz │ l_series_work_idx_uniq                     │        3.83 │ 14 MB      │ 3608 kB    │
└─────────────┴────────────────────────────────────────────┴─────────────┴────────────┴────────────┘
(7 rows)

Time: 561.029 ms