lib/postgres/vacuum/monitor/query.rb in postgres-vacuum-monitor-0.10.0 vs lib/postgres/vacuum/monitor/query.rb in postgres-vacuum-monitor-0.10.1
- old
+ new
@@ -102,10 +102,10 @@
<<-SQL
SELECT
state, count(*) as connection_count
FROM pg_stat_activity
GROUP BY state
- ORDER BY count DESC;
+ ORDER BY connection_count DESC;
SQL
end
def connection_idle_time
<<-SQL