Friday, 18 January 2019

Determining if Autovacuum Is Currently Running and For How Long

SELECT datname, usename, pid, waiting, current_timestamp - xact_start
AS xact_runtime, query
FROM pg_stat_activity WHERE upper(query) like '%VACUUM%' ORDER BY
xact_start; 

No comments:

Post a Comment

Currently running queries on Postgresql DB

shown, sorted from the longest running, with select now()-query_start, * from pg_stat_activity where state<> 'idle' order...