3.1.33 Ensure 'log_executor_stats' is disabled

Information

Enabling the log_executor_stats setting causes executor performance statistics to be written to the server log. This is a crude profiling instrument, similar to the Unix getrusage() operating system facility. This module reports per-module statistics. The executor performance statistics logging is disabled (off) by default and should only be enabled if directed to do so by your organization's logging policy.
Rationale:
The logging of these additional statistics when not mandated by your organization's logging policy greatly reduces the signal-to-noise ratio of the PostgreSQL logs.

Solution

Execute the following SQL statement(s) as superuser to remediate this setting:
postgres=# alter system set log_executor_stats = 'off';
ALTER SYSTEM
postgres=# select pg_reload_conf();
pg_reload_conf
----------------
t
(1 row)
Default Value:
off

See Also

https://workbench.cisecurity.org/files/2234

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-6, CSCv6|6, CSCv7|6

Plugin: PostgreSQLDB

Control ID: 30e964907645d1466850ee03647afedd923d282cf6e55dbb562f45c66c3b33fb