Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id D16E7B5DBFE
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 12 Jul 2011 13:23:18 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 30891-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 12 Jul 2011 16:23:12 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com
	[74.125.83.174])
	by mail.postgresql.org (Postfix) with ESMTP id 687EBB5D91F
	for <pgsql-admin@postgresql.org>; Tue, 12 Jul 2011 13:23:12 -0300 (ADT)
Received: by pvg12 with SMTP id 12so3922473pvg.19
	for <pgsql-admin@postgresql.org>; Tue, 12 Jul 2011 09:23:11 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	bh=pR66PA+CwI5nmjALa2SiS6p97U4y1N4P0niUFk3CTso=;
	b=TtUAFP3BvQmDA4qDzD5wLageDapq8w67EGpGWD5Te2eUVYEbRQRuZInzDPs/XTSyAd
	zWf4GLXOwbdPXCf3zhVZuuOvDCGyAAoTDTF4qNeQ3XQFXjKdqQJ/RhUo3KRvXsmpTF6C
	JSnT4Kj9EFsBMKzsLwILvG1/Gr/TtcozeOsmQ=
Received: by 10.68.17.73 with SMTP id m9mr126028pbd.180.1310487790168;
	Tue, 12 Jul 2011 09:23:10 -0700 (PDT)
Received: from [172.24.35.132] ([59.162.78.200])
	by mx.google.com with ESMTPS id m7sm8783289pbk.6.2011.07.12.09.23.05
	(version=TLSv1/SSLv3 cipher=OTHER);
	Tue, 12 Jul 2011 09:23:08 -0700 (PDT)
Subject: Re: Too many IDLE in current_query
Mime-Version: 1.0 (Apple Message framework v1084)
Content-Type: text/plain; charset=us-ascii
From: Vibhor Kumar <vibhor.aim@gmail.com>
In-Reply-To: <11819940.1364211310485136585.JavaMail.defaultUser@defaultHost>
Date: Tue, 12 Jul 2011 22:05:19 +0530
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <C9694754-9861-44B6-A4D8-668C4E06DADC@gmail.com>
References: <11819940.1364211310485136585.JavaMail.defaultUser@defaultHost>
To: "francescoboccacci@libero.it" <francescoboccacci@libero.it>
X-Mailer: Apple Mail (2.1084)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001
X-Spam-Level: 
X-Archive-Number: 201107/78
X-Sequence-Number: 37857


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=20
> 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=20
> 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=20
> 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