Re: process list

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(at)yahoo(dot)com]
Sent: Tue 3/23/2004 4:46 PM
To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org