PostgreSQL - Find erroneous queries

SELECT * FROM pg_stat_activity ORDER BY backend_start ASC;
    -- Get PID for query where state = "idle in transaction"

--Try Cancel first:
SELECT pg_cancel_backend([enter PID here]);

--If Cancel does not succeed try Terminate:
SELECT pg_terminate_backend([enter PID here]);