datname | relation | transactionid | mode | granted | usename | query | query_start | age | pid ---------+----------------------------+---------------+-----------------+---------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+-----------------+------- site | pg_namespace_oid_index | | AccessShareLock | t | debezium | SELECT DISTINCT ON (typname) typname, typinput='array_in'::regproc, typtype, sp.r, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace ORDER BY typname, sp.r, pg_type.oid | 2021-03-25 16:49:53.590547+00 | 00:00:02.227993 | 26909 site | pg_namespace_nspname_index | | AccessShareLock | t | debezium | SELECT DISTINCT ON (typname) typname, typinput='array_in'::regproc, typtype, sp.r, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace ORDER BY typname, sp.r, pg_type.oid | 2021-03-25 16:49:53.590547+00 | 00:00:02.227993 | 26909 site | pg_type_typname_nsp_index | | AccessShareLock | t | debezium | SELECT DISTINCT ON (typname) typname, typinput='array_in'::regproc, typtype, sp.r, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace ORDER BY typname, sp.r, pg_type.oid | 2021-03-25 16:49:53.590547+00 | 00:00:02.227993 | 26909 site | pg_type_oid_index | | AccessShareLock | t | debezium | SELECT DISTINCT ON (typname) typname, typinput='array_in'::regproc, typtype, sp.r, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace ORDER BY typname, sp.r, pg_type.oid | 2021-03-25 16:49:53.590547+00 | 00:00:02.227993 | 26909 site | pg_namespace | | AccessShareLock | t | debezium | SELECT DISTINCT ON (typname) typname, typinput='array_in'::regproc, typtype, sp.r, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace ORDER BY typname, sp.r, pg_type.oid | 2021-03-25 16:49:53.590547+00 | 00:00:02.227993 | 26909 site | pg_type | | AccessShareLock | t | debezium | SELECT DISTINCT ON (typname) typname, typinput='array_in'::regproc, typtype, sp.r, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace ORDER BY typname, sp.r, pg_type.oid | 2021-03-25 16:49:53.590547+00 | 00:00:02.227993 | 26909 site | | | ExclusiveLock | t | debezium | SELECT DISTINCT ON (typname) typname, typinput='array_in'::regproc, typtype, sp.r, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace ORDER BY typname, sp.r, pg_type.oid | 2021-03-25 16:49:53.590547+00 | 00:00:02.227993 | 26909 site | pg_locks | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:49:55.81854+00 | 00:00:00 | 25025 | | | | | | l.relation::regclass, +| | | | | | | | | l.transactionid, +| | | | | | | | | l.mode, +| | | | | | | | | l.GRANTED, +| | | | | | | | | a.usename, +| | | | | | | | | a.query, +| | | | | | | | | a.query_start, +| | | | | | | | | age(now(), a.query_start) AS "age", +| | | | | | | | | a.pid +| | | | | | | | | FROM pg_stat_activity a +| | | | | | | | | JOIN pg_locks l ON l.pid = a.pid +| | | | | | | | | ORDER BY a.query_start; | | | site | pg_stat_activity | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:49:55.81854+00 | 00:00:00 | 25025 | | | | | | l.relation::regclass, +| | | | | | | | | l.transactionid, +| | | | | | | | | l.mode, +| | | | | | | | | l.GRANTED, +| | | | | | | | | a.usename, +| | | | | | | | | a.query, +| | | | | | | | | a.query_start, +| | | | | | | | | age(now(), a.query_start) AS "age", +| | | | | | | | | a.pid +| | | | | | | | | FROM pg_stat_activity a +| | | | | | | | | JOIN pg_locks l ON l.pid = a.pid +| | | | | | | | | ORDER BY a.query_start; | | | site | | | ExclusiveLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:49:55.81854+00 | 00:00:00 | 25025 | | | | | | l.relation::regclass, +| | | | | | | | | l.transactionid, +| | | | | | | | | l.mode, +| | | | | | | | | l.GRANTED, +| | | | | | | | | a.usename, +| | | | | | | | | a.query, +| | | | | | | | | a.query_start, +| | | | | | | | | age(now(), a.query_start) AS "age", +| | | | | | | | | a.pid +| | | | | | | | | FROM pg_stat_activity a +| | | | | | | | | JOIN pg_locks l ON l.pid = a.pid +| | | | | | | | | ORDER BY a.query_start; | | | site | pg_database | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:49:55.81854+00 | 00:00:00 | 25025 | | | | | | l.relation::regclass, +| | | | | | | | | l.transactionid, +| | | | | | | | | l.mode, +| | | | | | | | | l.GRANTED, +| | | | | | | | | a.usename, +| | | | | | | | | a.query, +| | | | | | | | | a.query_start, +| | | | | | | | | age(now(), a.query_start) AS "age", +| | | | | | | | | a.pid +| | | | | | | | | FROM pg_stat_activity a +| | | | | | | | | JOIN pg_locks l ON l.pid = a.pid +| | | | | | | | | ORDER BY a.query_start; | | | site | pg_database_datname_index | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:49:55.81854+00 | 00:00:00 | 25025 | | | | | | l.relation::regclass, +| | | | | | | | | l.transactionid, +| | | | | | | | | l.mode, +| | | | | | | | | l.GRANTED, +| | | | | | | | | a.usename, +| | | | | | | | | a.query, +| | | | | | | | | a.query_start, +| | | | | | | | | age(now(), a.query_start) AS "age", +| | | | | | | | | a.pid +| | | | | | | | | FROM pg_stat_activity a +| | | | | | | | | JOIN pg_locks l ON l.pid = a.pid +| | | | | | | | | ORDER BY a.query_start; | | | site | pg_authid | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:49:55.81854+00 | 00:00:00 | 25025 | | | | | | l.relation::regclass, +| | | | | | | | | l.transactionid, +| | | | | | | | | l.mode, +| | | | | | | | | l.GRANTED, +| | | | | | | | | a.usename, +| | | | | | | | | a.query, +| | | | | | | | | a.query_start, +| | | | | | | | | age(now(), a.query_start) AS "age", +| | | | | | | | | a.pid +| | | | | | | | | FROM pg_stat_activity a +| | | | | | | | | JOIN pg_locks l ON l.pid = a.pid +| | | | | | | | | ORDER BY a.query_start; | | | site | pg_authid_rolname_index | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:49:55.81854+00 | 00:00:00 | 25025 | | | | | | l.relation::regclass, +| | | | | | | | | l.transactionid, +| | | | | | | | | l.mode, +| | | | | | | | | l.GRANTED, +| | | | | | | | | a.usename, +| | | | | | | | | a.query, +| | | | | | | | | a.query_start, +| | | | | | | | | age(now(), a.query_start) AS "age", +| | | | | | | | | a.pid +| | | | | | | | | FROM pg_stat_activity a +| | | | | | | | | JOIN pg_locks l ON l.pid = a.pid +| | | | | | | | | ORDER BY a.query_start; | | | site | pg_database_oid_index | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:49:55.81854+00 | 00:00:00 | 25025 | | | | | | l.relation::regclass, +| | | | | | | | | l.transactionid, +| | | | | | | | | l.mode, +| | | | | | | | | l.GRANTED, +| | | | | | | | | a.usename, +| | | | | | | | | a.query, +| | | | | | | | | a.query_start, +| | | | | | | | | age(now(), a.query_start) AS "age", +| | | | | | | | | a.pid +| | | | | | | | | FROM pg_stat_activity a +| | | | | | | | | JOIN pg_locks l ON l.pid = a.pid +| | | | | | | | | ORDER BY a.query_start; | | | site | pg_authid_oid_index | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:49:55.81854+00 | 00:00:00 | 25025 | | | | | | l.relation::regclass, +| | | | | | | | | l.transactionid, +| | | | | | | | | l.mode, +| | | | | | | | | l.GRANTED, +| | | | | | | | | a.usename, +| | | | | | | | | a.query, +| | | | | | | | | a.query_start, +| | | | | | | | | age(now(), a.query_start) AS "age", +| | | | | | | | | a.pid +| | | | | | | | | FROM pg_stat_activity a +| | | | | | | | | JOIN pg_locks l ON l.pid = a.pid +| | | | | | | | | ORDER BY a.query_start; | | | (16 rows)