All locks
Queries with active locks
Queries with active locks
| Pid | Relname | Transactionid | Granted | Query snippet | Mode | Age |
|---|---|---|---|---|---|---|
| 6934 | pg_namespace_oid_index | true | /* ECTO_PSQL_EXTRAS: Size of the tables (including indexes), descending by size */ SELECT n.nspname AS schema, c.relname AS name, pg_total_relation_size(c.oid) AS size FROM pg_class c LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace) WHERE n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND c.relkind IN ('r', 'm') ORDER BY pg_total_relation_size(c.oid) DESC; | AccessShareLock | 0.371487 seconds | |
| 6934 | pg_namespace_nspname_index | true | /* ECTO_PSQL_EXTRAS: Size of the tables (including indexes), descending by size */ SELECT n.nspname AS schema, c.relname AS name, pg_total_relation_size(c.oid) AS size FROM pg_class c LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace) WHERE n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND c.relkind IN ('r', 'm') ORDER BY pg_total_relation_size(c.oid) DESC; | AccessShareLock | 0.371487 seconds | |
| 6934 | pg_class_tblspc_relfilenode_index | true | /* ECTO_PSQL_EXTRAS: Size of the tables (including indexes), descending by size */ SELECT n.nspname AS schema, c.relname AS name, pg_total_relation_size(c.oid) AS size FROM pg_class c LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace) WHERE n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND c.relkind IN ('r', 'm') ORDER BY pg_total_relation_size(c.oid) DESC; | AccessShareLock | 0.371487 seconds | |
| 6934 | pg_class_relname_nsp_index | true | /* ECTO_PSQL_EXTRAS: Size of the tables (including indexes), descending by size */ SELECT n.nspname AS schema, c.relname AS name, pg_total_relation_size(c.oid) AS size FROM pg_class c LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace) WHERE n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND c.relkind IN ('r', 'm') ORDER BY pg_total_relation_size(c.oid) DESC; | AccessShareLock | 0.371487 seconds | |
| 6934 | pg_class_oid_index | true | /* ECTO_PSQL_EXTRAS: Size of the tables (including indexes), descending by size */ SELECT n.nspname AS schema, c.relname AS name, pg_total_relation_size(c.oid) AS size FROM pg_class c LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace) WHERE n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND c.relkind IN ('r', 'm') ORDER BY pg_total_relation_size(c.oid) DESC; | AccessShareLock | 0.371487 seconds | |
| 6934 | pg_namespace | true | /* ECTO_PSQL_EXTRAS: Size of the tables (including indexes), descending by size */ SELECT n.nspname AS schema, c.relname AS name, pg_total_relation_size(c.oid) AS size FROM pg_class c LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace) WHERE n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND c.relkind IN ('r', 'm') ORDER BY pg_total_relation_size(c.oid) DESC; | AccessShareLock | 0.371487 seconds | |
| 6934 | pg_class | true | /* ECTO_PSQL_EXTRAS: Size of the tables (including indexes), descending by size */ SELECT n.nspname AS schema, c.relname AS name, pg_total_relation_size(c.oid) AS size FROM pg_class c LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace) WHERE n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND c.relkind IN ('r', 'm') ORDER BY pg_total_relation_size(c.oid) DESC; | AccessShareLock | 0.371487 seconds | |
| 6934 | true | /* ECTO_PSQL_EXTRAS: Size of the tables (including indexes), descending by size */ SELECT n.nspname AS schema, c.relname AS name, pg_total_relation_size(c.oid) AS size FROM pg_class c LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace) WHERE n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND c.relkind IN ('r', 'm') ORDER BY pg_total_relation_size(c.oid) DESC; | ExclusiveLock | 0.371487 seconds |