Show Running Queries in PostgreSQL

chris48s

2020-06-20

SELECT
    pid,
    (CURRENT_TIMESTAMP - query_start) as query_time,
    datname,
    usename,
    query
FROM pg_stat_activity
ORDER BY query_time DESC;

This is particularly useful for keeping an eye on long-running queries. Bonus - if you need to kill one, grab the PID and run:

SELECT pg_terminate_backend(12345);