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,
In response to
pgsql-admin by date
|Next:||From: saravanan||Date: 2011-07-13 07:25:37|
|Subject: Re: Importing the dump file in postgresql-7.4.23|
|Previous:||From: Kevin Grittner||Date: 2011-07-12 16:07:16|
|Subject: Re: R: Too many IDLE in current_query|