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:[EMAIL PROTECTED]
Sent: Tue 3/23/2004 4:46 PM
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
