rendered paste bodywikispot=> 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 | | | | | | | 48758089 | 22060 | AccessShareLock | t | pg_authid | <IDLE>
relation | | | | | | | 48758089 | 22060 | AccessShareLock | t | pg_locks | <IDLE>
relation | | | | | | | 48758089 | 22060 | AccessShareLock | t | pg_stat_activity | <IDLE>
relation | | | | | | | 48758089 | 22060 | AccessShareLock | t | pg_class | <IDLE>
relation | | | | | | | 48758089 | 22060 | AccessShareLock | t | pg_database | <IDLE>
relation | | | | | | | 48757861 | 24109 | AccessShareLock | t | events | DELETE from links where source_pagename='front page' and wiki_id=2
relation | | | | | | | 48757861 | 24109 | AccessShareLock | t | files | DELETE from links where source_pagename='front page' and wiki_id=2
relation | | | | | | | 48757861 | 24109 | RowExclusiveLock | t | curpages | DELETE from links where source_pagename='front page' and wiki_id=2
relation | | | | | | | 48757861 | 24109 | AccessShareLock | t | curpages | DELETE from links where source_pagename='front page' and wiki_id=2
relation | | | | | | | 48757861 | 24109 | AccessShareLock | t | thumbnails | DELETE from links where source_pagename='front page' and wiki_id=2
relation | | | | | | | 48757861 | 24109 | RowExclusiveLock | t | imagecaptions | DELETE from links where source_pagename='front page' and wiki_id=2
relation | | | | | | | 48757861 | 24109 | AccessShareLock | t | imagecaptions | DELETE from links where source_pagename='front page' and wiki_id=2
relation | | | | | | | 48757861 | 24109 | AccessShareLock | t | imageinfo | DELETE from links where source_pagename='front page' and wiki_id=2
relation | | | | | | | 48757861 | 24109 | RowExclusiveLock | t | links | DELETE from links where source_pagename='front page' and wiki_id=2
relation | | | | | | | 48757861 | 24109 | RowExclusiveLock | t | pagedependencies | DELETE from links where source_pagename='front page' and wiki_id=2
relation | | | | | | | 48757861 | 24109 | AccessShareLock | t | pagedependencies | DELETE from links where source_pagename='front page' and wiki_id=2
(16 rows)