Skip site navigation (1) Skip section navigation (2)

Re: Too many IDLE in current_query

From: Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com>
To: "francescoboccacci(at)libero(dot)it" <francescoboccacci(at)libero(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Too many IDLE in current_query
Date: 2011-07-12 16:35:19
Message-ID: C9694754-9861-44B6-A4D8-668C4E06DADC@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Jul 12, 2011, at 9:08 PM, francescoboccacci(at)libero(dot)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(dot)aim(at)gmail(dot)com
Blogs: http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com


In response to

pgsql-admin by date

Next:From: saravananDate: 2011-07-13 07:25:37
Subject: Re: Importing the dump file in postgresql-7.4.23
Previous:From: Kevin GrittnerDate: 2011-07-12 16:07:16
Subject: Re: R: Too many IDLE in current_query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group