Postgres Pro
Downloads
Home   >   mailing lists

Re: Too many IDLE in current_query - Mailing list pgsql-admin

From Vibhor Kumar
Subject Re: Too many IDLE in current_query
Date
Msg-id C9694754-9861-44B6-A4D8-668C4E06DADC@gmail.com
Whole thread Raw
In response to Too many IDLE in current_query  ("francescoboccacci@libero.it" <francescoboccacci@libero.it>)
List pgsql-admin
Tree view 
On Jul 12, 2011, at 9:08 PM, francescoboccacci@libero.it wrote:

> i know that this is just a snapshot of the situation of the server in a
> particular moment, so i know that i can see all IDLE queries.
> The strange thing is that there are quesries that are running from 34 days.I
> think is strange.

<IDLE> mean connection is idle.  It doesn't mean query is running.

> Do you have any suggestions? My postgresql version is 8.4. I know that in
> postgresql 9.0 i can see also application_name filed.


You can use pg_stat_Activity.client_addr and pg_stat_activity.client_port to find the informaiton of client machine.

Thanks & Regards,
Vibhor Kumar
vibhor.aim@gmail.com
Blogs: http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: R: Too many IDLE in current_query
Next
From: saravanan
Date:
Subject: Re: Importing the dump file in postgresql-7.4.23