[Postgres Query Duration] Find long running postgres tasks #postgres #database

command.sql

select now() - xact_start as duration, * from pg_stat_activity WHERE state = 'active';

SELECT max(now() - xact_start) FROM pg_stat_activity
                               WHERE state IN ('idle in transaction', 'active');
                               
--- https://dba.stackexchange.com/questions/44084/troubleshooting-high-cpu-usage-from-postgres-and-postmaster-services