From: Vibhor Kumar <vibhor.aim@gmail.com>
To: francescoboccacci@libero.it <francescoboccacci@libero.it>
Cc: pgsql-admin@postgresql.org
Subject: Re: Too many IDLE in current_query
Date: Tue, 12 Jul 2011 22:05:19 +0530
Message-ID: <C9694754-9861-44B6-A4D8-668C4E06DADC@gmail.com> (raw)
In-Reply-To: <11819940.1364211310485136585.JavaMail.defaultUser@defaultHost>
References: <11819940.1364211310485136585.JavaMail.defaultUser@defaultHost>
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.comhttp://vibhorkumar.wordpress.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vibhor.aim@gmail.com, francescoboccacci@libero.it
Subject: Re: Too many IDLE in current_query
In-Reply-To: <C9694754-9861-44B6-A4D8-668C4E06DADC@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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