Skip to main content

All Settings

The All Settings tab shows every configuration parameter from pg_settings, live from the connected instance.

What it shows​

  • Current value — the runtime value from pg_settings.setting
  • Boot value — the value from postgresql.conf at server start (useful for drift detection)
  • Unit — parameter unit where applicable (KB, MB, ms, etc.)
  • Context — how the parameter is changed: postmaster (restart required), sighup (reload), user (session), superuser
  • Source — where the current value came from: default, configuration file, command line, etc.
  • Description — short description of the parameter's purpose

The tab supports client-side filtering: typing in the search box narrows rows to matching parameter names or values. This replaces the old whitelist approach — the full rowset (~300-400 rows depending on PostgreSQL version and extensions) is available.

Connection to tuning​

Settings are cross-referenced with the Recommendations tab:

  • Parameters that have been changed from their boot value are highlighted
  • Tuning recommendations include the current value and rollback SQL sourced from this rowset
  • Restart-required parameters are flagged in recommendations