select pg_stat_activity.current_query , pg_class.relname, pg_locks.transaction, pg_locks.mode, pg_locks.granted, pg_stat_activity.procpid from pg_stat_activity,pg_locks left outer join pg_class on (pg_locks.relation = pg_class.oid) where pg_locks.pid=pg_stat_activity.procpid order by pg_locks.mode, pg_class.relname;
for the output is thereby:
"user" "locked" "object " "kind of lock" "who waiting for object"