Step 2: Enable auto_explain

To enable auto_explain, you will need to find the parameter group for this server and add the auto_explain module to the shared_preload_libraries setting.

For example, if the current value is pg_stat_statements, you can set the new value to pg_stat_statements, auto_explain.

Since changes to shared_preload_libraries only take effect at server start, after you apply these settings, you will need to restart Postgres. You can do so from the Actions menu in the AWS console:

After the reboot completes, verify that shared_preload_libraries now includes auto_explain and that the setting change does not require a restart (pending_restart should be f):

SELECT setting, pending_restart FROM pg_settings WHERE name = 'shared_preload_libraries';

If auto_explain is enabled and no longer requires a restart, you can proceed to review our recommended auto_explain configuration settings: