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@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