select pid, client_addr, client_port, query_start, state from pg_stat_activity where state = 'active';
select pg_cancel_backend(<pid of the process>)
select pg_terminate_backend(<pid of the process>)