lib/postgres/vacuum/monitor/query.rb in postgres-vacuum-monitor-0.5.0 vs lib/postgres/vacuum/monitor/query.rb in postgres-vacuum-monitor-0.6.0
- old
+ new
@@ -19,10 +19,13 @@
pid,
xact_start,
EXTRACT(EPOCH FROM (now() - xact_start)) AS seconds,
application_name,
query,
- state
+ state,
+ backend_xid,
+ backend_xmin,
+ wait_event_type
FROM pg_stat_activity
WHERE state IN (#{STATES.join(', ')})
ORDER BY seconds DESC
) AS long_queries
WHERE seconds > #{TIME_LIMIT};