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