The settings advisor helps you to identify which configuration settings could improve the performance of your system.
The advisor automatically analyzes your current configuration; if suboptimal settings are found, it shows a notification when EXPLAIN is run. More details about suboptimal settings is shown when EXPLAIN VERBOSE is run. The settings advisor only covers some PostgreSQL server settings, for a full list of recommendations see Recommended PostgreSQL settings. Furthermore, it recommends tuning the operating system as described in Tune operating system.
- swarm64da.enable_settings_advisor (boolean)
Enables or disables the settings advisor. The default is
- SELECT * FROM swarm64da.show_advice();
Displays a list of advice about suboptimal settings.
- SELECT * FROM swarm64da.show_checked_settings();
Displays a complete list of all checked settings, including the suboptimal settings.