debug_print_parse

These parameters enable various debugging output to be emitted. When set, they print the resulting parse tree, the query rewriter output, or the execution plan for each executed query. These messages are emitted at LOG message level, so by default they will appear in the server log but will not be sent to the client. You can change that by adjusting client_min_messages and/or log_min_messages. These parameters are off 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: off
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_print_parse
short desc: Logs each query's parse tree.
source: pg-settings-source-snapshot
unit: Unknown
vartype: bool

Definition PG 18

These parameters enable various debugging output to be emitted. When set, they print the resulting parse tree, the query rewriter output, or the execution plan for each executed query. These messages are emitted at LOG message level, so by default they will appear in the server log but will not be sent to the client. You can change that by adjusting client_min_messages and/or log_min_messages. These parameters are off by default.

Compare versions

Complete source facts

doc html

<p>
        These parameters enable various debugging output to be emitted.
        When set, they print the resulting parse tree, the query rewriter
        output, or the execution plan for each executed query.
        These messages are emitted at <code class="literal">LOG</code> message level, so by
        default they will appear in the server log but will not be sent to the
        client.  You can change that by adjusting
        <a class="xref" href="/docs/18/runtime-config-client.html#GUC-CLIENT-MIN-MESSAGES">client_min_messages</a> and/or
        <a class="xref" href="/docs/18/runtime-config-logging.html#GUC-LOG-MIN-MESSAGES">log_min_messages</a>.
        These parameters are off 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:a0f6f311784e5ceb03743372fc2d1f40207a55e85e1e6c3fa99c7b67fae024a5

Text language: en · wiki-repair-20261023:a0f6f311784e5ceb03743372fc2d1f40207a55e85e1e6c3fa99c7b67fae024a5