View and deal with stuck queries on Postgres

stuck.sql

-- View activity
select datname,usename,pid,client_addr,waiting,query_start,query from pg_stat_activity;

-- View locks
select * from pg_locks where relation=(select oid from pg_class where relname='tablename_str');

select pg_cancel_backend(pid_int);     -- ask nicely
select pg_terminate_backend(pid_int);  -- rude