Kill SQL process

kill_iddle.sql

SELECT *
FROM pg_stat_activity
WHERE state = 'active';

SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'payhub'
  AND pid <> pg_backend_pid()
  AND state in ('active');

############################

SELECT * FROM pg_stat_activity WHERE state = 'active';
Find the process you want to kill, then type:

SELECT pg_cancel_backend(<pid of the process>)
If the process cannot be killed, try:

SELECT pg_terminate_backend(<pid of the process>)