debug_pretty_print

When set, debug_pretty_print indents the messages produced by debug_print_parse, debug_print_rewritten, or debug_print_plan. This results in more readable but much longer output than the “compact” format used when it is off. It is on by default.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

boot val: on
category: Reporting and Logging / What to Log
context: user
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: Unknown
lang: en
max val: Unknown
metadata version: 18
min val: Unknown
name: debug_pretty_print
short desc: Indents parse and plan tree displays.
source: pg-settings-source-snapshot
unit: Unknown
vartype: bool

Definition PG 18

When set, debug_pretty_print indents the messages produced by debug_print_parse, debug_print_rewritten, or debug_print_plan. This results in more readable but much longer output than the “compact” format used when it is off. It is on by default.

Compare versions

Complete source facts

doc html

<p>
        When set, <code class="varname">debug_pretty_print</code> indents the messages
        produced by <code class="varname">debug_print_parse</code>,
        <code class="varname">debug_print_rewritten</code>, or
        <code class="varname">debug_print_plan</code>.  This results in more readable
        but much longer output than the <span class="quote">“<span class="quote">compact</span>”</span> format used when
        it is off.  It is on by default.
       </p>

documentation revision

{"inputs":[{"file":"runtime-config-logging.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"278d913b9c0f735c5cd7b35fd7205826bbd9c449805370d2dbe54105c0ed1d88","version":"18.7"},{"file":"runtime-config-logging.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"68c010254e1859ec0b76f06a563babd51a6c38997f1242e35e4c6b649724b1cb","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:4d3db760d07b20bfaed514971378ea8db648ab8aaeef7bf557c4a2087df4062f

Text language: en · wiki-repair-20261023:4d3db760d07b20bfaed514971378ea8db648ab8aaeef7bf557c4a2087df4062f