Settings advisor
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.
Settings
- swarm64da.enable_settings_advisor (boolean)
-
Enables or disables the settings advisor. The default is
on
.
Functions
- 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.