Postgres Pro
Downloads
Home   >   mailing lists

Re: many idle processes - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: many idle processes
Date
Msg-id GNELIHDDFBOCMGBFGEFOKEHECDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to many idle processes  ("John Liu" <johnl@synthesys.com>)
List pgsql-hackers
Tree view 
> 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

pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Trimming the Fat, Part Deux ...
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Open 7.3 items