list_index.sql

SELECT i.indrelid::regclass AS "Table", i.indexrelid::regclass AS "Index",
       pg_size_pretty(pg_relation_size(i.indexrelid)) AS "Taille de l'index"
  FROM pg_index i JOIN (
  SELECT indrelid, indclass, indkey, indexprs, indpred
    FROM pg_index GROUP BY indrelid, indclass, indkey, indexprs, indpred
  HAVING COUNT (*) > 1
) g ON i.indrelid = g.indrelid AND i.indclass = g.indclass AND i.indkey = g.indkey 
    AND COALESCE(i.indexprs::text,'x') = COALESCE(g.indexprs::text,'x') 
    AND COALESCE(i.indpred::text,'x') = COALESCE(g.indpred::text,'x')
ORDER BY pg_relation_size(i.indexrelid) DESC, i.indexrelid::regclass;