Sha256: 26ce286f5c88ab01512c28d5f28290c14831e9b0492edba003e7ac7bb8b882b4
Contents?: true
Size: 626 Bytes
Versions: 62
Compression:
Stored size: 626 Bytes
Contents
/* Multiple indexes that have the same set of columns, same opclass, expression and predicate. */
SELECT pg_size_pretty(sum(pg_relation_size(idx))::bigint) as size,
(array_agg(idx))[1] as idx1, (array_agg(idx))[2] as idx2,
(array_agg(idx))[3] as idx3, (array_agg(idx))[4] as idx4
FROM (
SELECT indexrelid::regclass as idx, (indrelid::text ||E'\n'|| indclass::text ||E'\n'|| indkey::text ||E'\n'||
coalesce(indexprs::text,'')||E'\n' || coalesce(indpred::text,'')) as key
FROM pg_index) sub
GROUP BY key HAVING count(*)>1
ORDER BY sum(pg_relation_size(idx)) DESC;
Version data entries
62 entries across 62 versions & 1 rubygems