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,