watch_another_process_blocks.sql

blocks.sql

SELECT  a.pid, a.usename, mode, locktype, query, state, granted,
  tuple, transactionid, classid, objid, objsubid
FROM  pg_catalog.pg_locks         bl
JOIN pg_catalog.pg_stat_activity a  ON a.pid = bl.pid
where granted and a.pid <>  pg_backend_pid()
order by locktype;