rendered paste bodywikispot=> SELECT locktype, page, tuple, transactionid, classid, objid, objsubid, transaction, pid, mode, granted, pg_stat_activity.current_query from pg_locks, pg_stat_activity where pg_stat_activity.procpid=pid;
locktype | page | tuple | transactionid | classid | objid | objsubid | transaction | pid | mode | granted | current_query
---------------+------+-------+---------------+---------+-------+----------+-------------+-------+-----------------+---------+-----------------------
transactionid | | | 50240709 | | | | 50240709 | 32277 | ExclusiveLock | t | <IDLE> in transaction
relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | <IDLE> in transaction
relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | <IDLE> in transaction
relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | <IDLE> in transaction
relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | <IDLE> in transaction
relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | <IDLE> in transaction
transactionid | | | 49523436 | | | | 49523436 | 24088 | ExclusiveLock | t | <IDLE> in transaction
relation | | | | | | | 49523436 | 24088 | AccessShareLock | t | <IDLE> in transaction
(8 rows)
wikispot=> SELECT locktype, page, tuple, transactionid, classid, objid, objsubid, transaction, pid, mode, granted, pg_class.relname, pg_stat_activity.current_query from pg_locks, pg_class, pg_stat_activity where pg_class.oid=pg_locks.relation and pg_stat_activity.procpid=pid;
locktype | page | tuple | transactionid | classid | objid | objsubid | transaction | pid | mode | granted | relname | current_query
----------+------+-------+---------------+---------+-------+----------+-------------+-------+-----------------+---------+------------------+-----------------------
relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | pg_authid | <IDLE> in transaction
relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | pg_locks | <IDLE> in transaction
relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | pg_stat_activity | <IDLE> in transaction
relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | pg_class | <IDLE> in transaction
relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | pg_database | <IDLE> in transaction
relation | | | | | | | 49523436 | 24088 | AccessShareLock | t | curpages | <IDLE> in transaction
(6 rows)