Monitor PG processes.sql

SELECT 
  age(now(), query_start) AS duration, 
  state, 
  pid, 
  query, 
  datname, 
  application_name, 
  waiting 
FROM pg_stat_activity
ORDER BY duration DESC NULLS LAST;

SELECT 
  age(now(), query_start) AS duration, 
  state, 
  pid, 
  query, 
  datname, 
  application_name, 
  waiting 
FROM pg_stat_activity
WHERE state = 'active'
ORDER BY duration DESC NULLS LAST;

SELECT pg_cancel_backend(procpid);

SELECT pg_terminate_backend(procpid);