Locks
Queries with active exclusive locks
Queries with active exclusive locks
| Pid | Relname | Transactionid | Granted | Query snippet | Mode | Age |
|---|---|---|---|---|---|---|
| 2916 | true | /* ECTO_PSQL_EXTRAS: 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' '|| indclass::text ||E' '|| indkey::text ||E' '|| coalesce(indexprs::text,'')||E' ' || coalesce(indpred::text,'')) as key FROM pg_index) sub GROUP BY key HAVING count(*)>1 ORDER BY sum(pg_relation_size(idx)) DESC; | ExclusiveLock | 0.0-1717 seconds |