Thanks Chandler Thompson for this!

Identify Long Running Processes

SELECT pg_stat_activity.pid,
pg_class.relname,
pg_locks.transactionid,
pg_locks.granted,
age(now(), pg_stat_activity.query_start) AS "age"
FROM pg_stat_activity,
     pg_locks LEFT OUTER
JOIN pg_class ON (pg_locks.relation = pg_class.oid)
WHERE pg_stat_activity.query <> ''
  AND pg_locks.pid = pg_stat_activity.pid AND pg_stat_activity.pid <> pg_backend_pid()
ORDER BY age DESC
LIMIT 10;

If you need to stop a process try to CANCEL first, as Terminate can have some unwanted effects.

Cancel Process

SELECT pg_cancel_backend(${pid});

Terminate Process

Only if absolutely necessary

SELECT pg_terminate_backend(${pid});