get_locks

get_locks.sql

select  locktype, database, relation,page,tuple,virtualxid,transactionid,classid,objid,objsubid,virtualtransaction,pid
,       mode,granted,datname,datdba,datctype,datistemplate,datallowconn,datconnlimit,datlastsysoid,datfrozenxid,dattablespace,datacl
,       c.relname as table_name
from    pg_locks l
join pg_database d
on d.oid = l.database
join pg_class c
on c.oid = l.relation;