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};