All locks
Queries with active locks
Queries with active locks
| Pid | Relname | Transactionid | Granted | Query snippet | Mode | Age |
|---|---|---|---|---|---|---|
| 185982 | pg_attribute_relid_attnum_index | 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]::text as idx1, (array_agg(idx))[2]::text as idx2, (array_agg(idx))[3]::text as idx3, (array_agg(idx))[4]::text 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; | AccessShareLock | 0.0-2734 seconds | |
| 185982 | pg_attribute | 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]::text as idx1, (array_agg(idx))[2]::text as idx2, (array_agg(idx))[3]::text as idx3, (array_agg(idx))[4]::text 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; | AccessShareLock | 0.0-2734 seconds | |
| 185982 | pg_toast_1417_index | 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]::text as idx1, (array_agg(idx))[2]::text as idx2, (array_agg(idx))[3]::text as idx3, (array_agg(idx))[4]::text 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; | AccessShareLock | 0.0-2734 seconds | |
| 185982 | pg_index_indexrelid_index | 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]::text as idx1, (array_agg(idx))[2]::text as idx2, (array_agg(idx))[3]::text as idx3, (array_agg(idx))[4]::text 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; | AccessShareLock | 0.0-2734 seconds | |
| 185982 | pg_index_indrelid_index | 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]::text as idx1, (array_agg(idx))[2]::text as idx2, (array_agg(idx))[3]::text as idx3, (array_agg(idx))[4]::text 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; | AccessShareLock | 0.0-2734 seconds | |
| 185982 | pg_index | 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]::text as idx1, (array_agg(idx))[2]::text as idx2, (array_agg(idx))[3]::text as idx3, (array_agg(idx))[4]::text 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; | AccessShareLock | 0.0-2734 seconds | |
| 185982 | 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]::text as idx1, (array_agg(idx))[2]::text as idx2, (array_agg(idx))[3]::text as idx3, (array_agg(idx))[4]::text 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-2734 seconds |