update_process_title

Enables updating of the process title every time a new SQL command is received by the server. This setting defaults to on on most platforms, but it defaults to off on Windows due to that platform's larger overhead for updating the process title. Only superusers and users with the appropriate SET privilege can change this setting.

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

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 / Process Title
context: superuser
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: Enables updating of the process title every time a new SQL command is received by the server.
lang: en
max val: Unknown
metadata version: 18
min val: Unknown
name: update_process_title
short desc: Updates the process title to show the active SQL command.
source: pg-settings-source-snapshot
unit: Unknown
vartype: bool

Definition PG 18

Enables updating of the process title every time a new SQL command is received by the server. This setting defaults to on on most platforms, but it defaults to off on Windows due to that platform's larger overhead for updating the process title. Only superusers and users with the appropriate SET privilege can change this setting.

Compare versions

Complete source facts

doc html

<p>
        Enables updating of the process title every time a new SQL command
        is received by the server.
        This setting defaults to <code class="literal">on</code> on most platforms, but it
        defaults to <code class="literal">off</code> on Windows due to that platform's larger
        overhead for updating the process title.
        Only superusers and users with the appropriate <code class="literal">SET</code>
        privilege can change this setting.
       </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:4b7fd41205640565fd54fe0a4e0aa24d5089c03711428768f10f79d3575d3b0c

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