Utilizando os comandos abaixo é possível monitorar as conexões ativas no banco de dados e a partir da análise terminar o processo diretamente no banco de dados.
select * from pg_stat_activity;
select client_addr, count(1) from pg_stat_activity group by 1;
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
where query ilike '%roll%' and client_addr <> '<IP_address>';
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
where client_addr = '<IP_address>';