wikispot=> 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 | in transaction relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | in transaction relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | in transaction relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | in transaction relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | in transaction relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | in transaction transactionid | | | 49523436 | | | | 49523436 | 24088 | ExclusiveLock | t | in transaction relation | | | | | | | 49523436 | 24088 | AccessShareLock | t | 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 | in transaction relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | pg_locks | in transaction relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | pg_stat_activity | in transaction relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | pg_class | in transaction relation | | | | | | | 50240709 | 32277 | AccessShareLock | t | pg_database | in transaction relation | | | | | | | 49523436 | 24088 | AccessShareLock | t | curpages | in transaction (6 rows)