Horton

Re: many idle processes

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread View on postgr.es
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "John Liu" <johnl@synthesys.com>, <pgsql-hackers@postgresql.org>
Date: 2002-08-01T01:41:15Z
Lists: pgsql-hackers 
> Is there a catalog to track those
> psql processes - what their functions, who
> issues, etc.?
> 
> thanks.
> 
> johnl  

If you have it enabled in your postgresql.conf, just go:

select * from pg_stat_activity;

Chris