Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 790FFB5DC0E
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 12 Jul 2011 12:39:04 -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 26611-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 12 Jul 2011 15:38:58 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from outrelay02.libero.it (outrelay02.libero.it [212.52.84.102])
	by mail.postgresql.org (Postfix) with ESMTP id 20728B5D80A
	for <pgsql-admin@postgresql.org>; Tue, 12 Jul 2011 12:38:57 -0300 (ADT)
X-CTCH-Spam: Unknown
X-CTCH-RefID: str=0001.0A0B020D.4E1C6A90.0129,ss=1,re=0.000,fgs=0
X-libjamoibt: 1821
Received: from wmail50 (172.31.0.240) by outrelay02.libero.it (8.5.133)
	(authenticated as francescoboccacci@libero.it)
	id 4E09A78E016B2CD0 for pgsql-admin@postgresql.org;
	Tue, 12 Jul 2011 17:38:56 +0200
Message-ID: <11819940.1364211310485136585.JavaMail.defaultUser@defaultHost>
Date: Tue, 12 Jul 2011 17:38:56 +0200 (CEST)
From: "francescoboccacci@libero.it" <francescoboccacci@libero.it>
Reply-To: "francescoboccacci@libero.it" <francescoboccacci@libero.it>
To: pgsql-admin@postgresql.org
Subject: Too many IDLE in current_query
MIME-Version: 1.0
Content-Type: text/plain;charset="UTF-8"
Content-Transfer-Encoding: 7bit
X-SenderIP: 213.182.95.210
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=-10 required=5 tests=BAYES_40=-0.001,
	FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01,
	T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201107/74
X-Sequence-Number: 37853

Dear all,
i'm checking my postgresql server to try to monitoring all activity that are 
running.
i run this query:

postgres=#  select
current_timestamp - query_start as runtime,
current_query
from pg_stat_activity
order by 1 desc;

and the resul is many rows like this:


         runtime         |                current_query
-------------------------+---------------------------------------------
 34 days 06:53:59.959751 | <IDLE>
 34 days 06:53:59.924254 | <IDLE>
 34 days 06:53:56.870348 | <IDLE>
 34 days 06:04:34.553884 | <IDLE>
 34 days 06:04:24.975262 | <IDLE>
 34 days 06:04:20.951703 | <IDLE>
 34 days 06:04:11.200763 | <IDLE>
 34 days 02:45:07.633385 | <IDLE>
 20 days 06:21:00.519184 | <IDLE>
 20 days 04:56:16.008164 | <IDLE>
 20 days 04:35:46.465805 | <IDLE>
 20 days 01:44:22.723898 | <IDLE>
 19 days 07:32:29.484493 | <IDLE>
 2 days 09:08:29.955712  | <IDLE>
 2 days 09:08:29.929274  | <IDLE>
 2 days 09:08:29.914055  | <IDLE>
 2 days 09:08:29.910676  | <IDLE>
 2 days 09:08:29.231103  | <IDLE>
 2 days 09:08:29.22941   | <IDLE>
 2 days 09:08:29.20836   | <IDLE>
 2 days 09:08:29.203906  | <IDLE>
 2 days 09:08:29.198813  | <IDLE>
 2 days 09:08:29.19535   | <IDLE>
 2 days 09:08:28.214741  | <IDLE>
 2 days 09:08:28.210447  | <IDLE>
 2 days 09:08:28.183688  | <IDLE>
 2 days 09:08:28.179618  | <IDLE>
 2 days 09:08:28.161658  | <IDLE>
 2 days 09:08:28.151496  | <IDLE>
 1 day 09:03:14.978079   | <IDLE>
 1 day 09:03:12.246013   | <IDLE>
 1 day 08:53:47.763229   | <IDLE>
 1 day 08:53:46.744188   | <IDLE>
 1 day 08:49:21.584343   | <IDLE>
 1 day 07:44:18.245998   | <IDLE>
 1 day 05:18:29.171981   | <IDLE>
 1 day 03:25:18.260414   | <IDLE>
 1 day 02:47:34.402538   | <IDLE>
 1 day 02:47:33.816568   | <IDLE>
 1 day 02:47:33.472902   | <IDLE>
 1 day 00:59:58.531684   | <IDLE>
 07:07:43.146363         | <IDLE>
 06:52:19.014704         | <IDLE>
...
...

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.
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.
Thanks for your help

Francesco Boccacci