AlexanderOnbysh
11/22/2017 - 1:07 PM

Kill blocking process

View active processes

select pid, client_addr, client_port, query_start, state from pg_stat_activity where state = 'active';

Cancel process

select pg_cancel_backend(<pid of the process>)

Kill process

select pg_terminate_backend(<pid of the process>)