lib/pghero/methods/maintenance.rb in pghero-3.2.0 vs lib/pghero/methods/maintenance.rb in pghero-3.3.0

- old
+ new

@@ -7,11 +7,11 @@ # warn when 10,000,000 transactions left def transaction_id_danger(threshold: 10000000, max_value: 2146483648) max_value = max_value.to_i threshold = threshold.to_i - select_all <<-SQL + select_all <<~SQL SELECT n.nspname AS schema, c.relname AS table, #{quote(max_value)} - GREATEST(AGE(c.relfrozenxid), AGE(t.relfrozenxid)) AS transactions_left FROM @@ -33,11 +33,11 @@ transaction_id_danger(threshold: 2000000, max_value: max_value) end def vacuum_progress if server_version_num >= 90600 - select_all <<-SQL + select_all <<~SQL SELECT pid, phase FROM pg_stat_progress_vacuum @@ -48,10 +48,10 @@ [] end end def maintenance_info - select_all <<-SQL + select_all <<~SQL SELECT schemaname AS schema, relname AS table, last_vacuum, last_autovacuum,