Find and kill locks in PostgreSQL

find_and_stop_locks.sql

-- Find process ids

select pid 
from pg_locks l 
join pg_class t on l.relation = t.oid 
where t.relkind = 'r';

-- Find queries that are locked

select pid, state, usename, query, query_start 
from pg_stat_activity 
where pid in (
  select pid from pg_locks l 
  join pg_class t on l.relation = t.oid 
  and t.relkind = 'r' 
);

-- Stop the process ids
SELECT pg_cancel_backend(pid);

-- Force stop the process ids
SELECT pg_terminate_backend(pid);