3.1.19 Ensure 'debug_pretty_print' is enabled

Information

Enabling debug_pretty_print indents the messages produced by debug_print_parse debug_print_rewritten or debug_print_plan making them significantly easier to read.

If this setting is disabled, the "compact" format is used instead, significantly reducing the readability of the DEBUG statement log messages.

Solution

Execute the following SQL statement(s) to enable this setting:

postgres=# alter system set debug_pretty_print = 'on';
ALTER SYSTEM
postgres=# select pg_reload_conf();
pg_reload_conf
----------------
t
(1 row)

Impact:

Be advised that the aforementioned DEBUG printing options are disabled but if your organizational logging policy requires them to be on then this option comes into play.

See Also

https://workbench.cisecurity.org/benchmarks/19478

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-3, 800-53|AU-3(1), 800-53|AU-7, 800-53|AU-12, CSCv7|6.3

Plugin: PostgreSQLDB

Control ID: b70e51daa7aee1347132981d457a4771339bf55a77c3d1226060ec79df14b48d