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

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 

Categories

GUC configuration item, Management / adminstration

See also

cluster_name