SELECT relname,(array_agg(idx))[1] idx1,pg_get_indexdef((array_agg(idx))[1]) idx1_def,(array_agg(idx))[2] idx2,pg_get_indexdef((array_agg(idx))[2]) idx2_def,(array_agg(idx))[3] idx3,pg_get_indexdef((array_agg(idx))[3]) idx3_def FROM (SELECT indrelid::regclass AS relname,indexrelid::regclass AS idx,(indrelid::text || indclass::text || indkey::text || COALESCE(indexprs::text, ‘’) || COALESCE(indpred::text, ‘’)) AS KEY FROM pg_index) sub GROUP BY relname, KEY HAVING count(*) > 1;