debug_print_plan

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_plan
short desc: Logs each query's execution plan.
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:d8418684ace6c85f36daa743458cfce985d35637c7ad79aa0f68def89428818c

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