View of the current table locks in postgres and the queries holding them.

inf_locks.sql

CREATE VIEW inf_locks AS
SELECT locktype, relation::regclass, mode, transactionid AS tid,
virtualtransaction AS vtidi, usename, pid, granted, query
FROM pg_catalog.pg_locks l LEFT JOIN pg_catalog.pg_database db
ON db.oid = l.database left join pg_stat_activity using (pid) WHERE (db.datname = 'blue' OR db.datname IS NULL)
AND NOT pid = pg_backend_pid();