pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
process list
2+ messages / 2 participants
[nested] [flat]

* process list
@ 2004-03-23 21:46  Hemapriya <priyam_1121@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Hemapriya @ 2004-03-23 21:46 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: process list
@ 2004-03-23 22:00  Anjan Dave <adave@vantage.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Anjan Dave @ 2004-03-23 22:00 UTC (permalink / raw)
  To: Hemapriya <priyam_1121@yahoo.com>; pgsql-admin

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
	



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-03-23 22:00 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-23 21:46 process list Hemapriya <priyam_1121@yahoo.com>
2004-03-23 22:00 Re: process list Anjan Dave <adave@vantage.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox