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 |      |       |               |         |       |          |    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)