update_process_title
A configuration parameter determining whether 'ps' display is updated for every command
update_process_title
is a configuration parameter determining whether ps
display is updated for every command executed.
update_process_title
was added in PostgreSQL 8.2.
Default value
The default value for update_process_title
is: on
.
Usage
Normally there is no reason to disable update_process_title
, except on Windows platforms where there is a higher overhead for updating the process title.
Change history
- PostgreSQL 8.2
- added (commit 370a709c)
Examples
With update_process_title
set to on
(the default), each PostgreSQL process will display information about its current state in the process title; here the walreceiver:
$ for I in `seq 1 5`; do ps -u --user postgres | grep walreceiver; sleep 5; done postgres 826581 0.0 0.0 722988 7552 ? Ss 16:48 0:04 postgres: walreceiver streaming 7/C12BF730 postgres 826581 0.0 0.0 722988 7552 ? Ss 16:48 0:04 postgres: walreceiver streaming 7/C12BF828 postgres 826581 0.0 0.0 722988 7552 ? Ss 16:48 0:04 postgres: walreceiver streaming 7/C12BF8E8 postgres 826581 0.0 0.0 722988 7552 ? Ss 16:48 0:04 postgres: walreceiver streaming 7/C12C0948 postgres 826581 0.0 0.0 722988 7552 ? Ss 16:48 0:04 postgres: walreceiver streaming 7/C12C0948
If update_process_title
is set to off
, no such information will be displayed:
$ for I in `seq 1 5`; do ps -u --user postgres | grep walreceiver; sleep 5; done postgres 854731 0.0 0.0 722992 7192 ? Ss 21:45 0:00 postgres: walreceiver postgres 854731 0.0 0.0 722992 7192 ? Ss 21:45 0:00 postgres: walreceiver postgres 854731 0.0 0.0 722992 7192 ? Ss 21:45 0:00 postgres: walreceiver postgres 854731 0.0 0.0 722992 7192 ? Ss 21:45 0:00 postgres: walreceiver postgres 854731 0.0 0.0 722992 7192 ? Ss 21:45 0:00 postgres: walreceiver
References
- PostgreSQL documentation: update_process_title