module PgHero::Methods::Settings

Public Instance Methods

autovacuum_settings() click to toggle source
# File lib/pghero/methods/settings.rb, line 22
def autovacuum_settings
  fetch_settings %i(autovacuum autovacuum_max_workers autovacuum_vacuum_cost_limit autovacuum_vacuum_scale_factor autovacuum_analyze_scale_factor)
end
settings() click to toggle source
# File lib/pghero/methods/settings.rb, line 4
def settings
  names =
    if server_version_num >= 90500
      %i(
        max_connections shared_buffers effective_cache_size work_mem
        maintenance_work_mem min_wal_size max_wal_size checkpoint_completion_target
        wal_buffers default_statistics_target
      )
    else
      %i(
        max_connections shared_buffers effective_cache_size work_mem
        maintenance_work_mem checkpoint_segments checkpoint_completion_target
        wal_buffers default_statistics_target
      )
    end
  fetch_settings(names)
end
vacuum_settings() click to toggle source
# File lib/pghero/methods/settings.rb, line 26
def vacuum_settings
  fetch_settings %i(vacuum_cost_limit)
end

Private Instance Methods

fetch_settings(names) click to toggle source
# File lib/pghero/methods/settings.rb, line 32
def fetch_settings(names)
  Hash[names.map { |name| [name, select_one("SHOW #{name}")] }]
end