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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | saravanan | 2011-07-13 07:25:37 | Re: Importing the dump file in postgresql-7.4.23 |
Previous Message | Kevin Grittner | 2011-07-12 16:07:16 | Re: R: Too many IDLE in current_query |