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
