/* Queries with active locks */

SELECT

pg_stat_activity.pid,
pg_class.relname,
pg_locks.transactionid,
pg_locks.granted,
pg_locks.mode,
pg_stat_activity.query AS query_snippet,
age(now(),pg_stat_activity.query_start) AS "age"

FROM

pg_stat_activity,
pg_locks

LEFT OUTER JOIN

pg_class ON
  (pg_locks.relation = pg_class.oid)

WHERE

pg_stat_activity.query <> '<insufficient privilege>' AND
  pg_locks.pid = pg_stat_activity.pid AND
  pg_stat_activity.pid <> pg_backend_pid() order by query_start;