datname | relation | transactionid | mode | granted | usename | query | query_start | age | pid ----------+---------------------------+---------------+-----------------+---------+----------+----------------------------------------------+-------------------------------+----------+------- postgres | pg_locks | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:48:20.700583+00 | 00:00:00 | 16609 | | | | | | 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; | | | postgres | pg_stat_activity | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:48:20.700583+00 | 00:00:00 | 16609 | | | | | | 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; | | | postgres | | | ExclusiveLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:48:20.700583+00 | 00:00:00 | 16609 | | | | | | 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; | | | postgres | pg_authid | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:48:20.700583+00 | 00:00:00 | 16609 | | | | | | 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; | | | postgres | pg_database_datname_index | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:48:20.700583+00 | 00:00:00 | 16609 | | | | | | 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; | | | postgres | pg_database | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:48:20.700583+00 | 00:00:00 | 16609 | | | | | | 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; | | | postgres | pg_authid_rolname_index | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:48:20.700583+00 | 00:00:00 | 16609 | | | | | | 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; | | | postgres | pg_authid_oid_index | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:48:20.700583+00 | 00:00:00 | 16609 | | | | | | 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; | | | postgres | pg_database_oid_index | | AccessShareLock | t | postgres | SELECT a.datname, +| 2021-03-25 16:48:20.700583+00 | 00:00:00 | 16609 | | | | | | 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; | | | (9 rows)