process list

Поиск
Список
Период
Сортировка
Искать

process list

От:
Hemapriya <priyam_1121@yahoo.com>
Дата:
How can i view the list of processes running in
postgresql.. is there any command for that??

Any help is appreciated.

Thanks
Priya

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

Re: process list

От:
"Anjan Dave" <adave@vantage.com>
Дата:
ps -eaf | grep postgres | grep -v idle (the last grep will get the actual command, and not the idle connection)
 
If you have the stats_command_string enabled, you can also do a 
$echo "select * from pg_stat_activity" | psql dbname
 
Thanks,
Anjan

	-----Original Message----- 
	From: Hemapriya [mailto:priyam_1121@yahoo.com] 
	Sent: Tue 3/23/2004 4:46 PM 
	To: pgsql-admin@postgresql.org 
	Cc: 
	Subject: [ADMIN] process list
	
	

	How can i view the list of processes running in
	postgresql.. is there any command for that??
	
	Any help is appreciated.
	
	Thanks
	Priya
	
	__________________________________
	Do you Yahoo!?
	Yahoo! Finance Tax Center - File online. File on time.
	http://taxes.yahoo.com/filing.html
	
	---------------------------(end of broadcast)---------------------------
	TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
	

FAQ