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