postgres commands that I like - benclifford/text GitHub Wiki

ps-like display - application_name is not set by default much but eg set $PGAPPNAME in each client process environment

select pid, application_name, waiting, state, left(query,75) from pg_stat_activity order by application_name;

When waiting = t, check out pg_locks:

select * from pg_locks where pid = 1234;

and see which relations are being waited for. Then see what else is waiting on that relation:

select * from pg_locks where relation = 65812;

and kill anything that is naughtly:

select pg_terminate_backend(27566);