Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id BB161B5DC53 for ; Tue, 12 Jul 2011 13:04:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 89184-04-7 for ; Tue, 12 Jul 2011 16:03: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 293D3B5DD53 for ; Tue, 12 Jul 2011 13:03:55 -0300 (ADT) X-CTCH-Spam: Unknown X-CTCH-RefID: str=0001.0A0B0209.4E1C706B.0062,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 4E09A78E016C1AC6; Tue, 12 Jul 2011 18:03:55 +0200 Message-ID: <12467584.1379131310486635079.JavaMail.defaultUser@defaultHost> Date: Tue, 12 Jul 2011 18:03:55 +0200 (CEST) From: "francescoboccacci@libero.it" Reply-To: "francescoboccacci@libero.it" To: , Subject: R: 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=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201107/75 X-Sequence-Number: 37854 Hi, i add another question to my previous mail.. why all the rows of my query have waiting field false? Thanks Francesco >----Messaggio originale---- >Da: francescoboccacci@libero.it >Data: 12/07/2011 17.38 >A: >Ogg: [ADMIN] Too many IDLE in current_query > >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 | > 34 days 06:53:59.924254 | > 34 days 06:53:56.870348 | > 34 days 06:04:34.553884 | > 34 days 06:04:24.975262 | > 34 days 06:04:20.951703 | > 34 days 06:04:11.200763 | > 34 days 02:45:07.633385 | > 20 days 06:21:00.519184 | > 20 days 04:56:16.008164 | > 20 days 04:35:46.465805 | > 20 days 01:44:22.723898 | > 19 days 07:32:29.484493 | > 2 days 09:08:29.955712 | > 2 days 09:08:29.929274 | > 2 days 09:08:29.914055 | > 2 days 09:08:29.910676 | > 2 days 09:08:29.231103 | > 2 days 09:08:29.22941 | > 2 days 09:08:29.20836 | > 2 days 09:08:29.203906 | > 2 days 09:08:29.198813 | > 2 days 09:08:29.19535 | > 2 days 09:08:28.214741 | > 2 days 09:08:28.210447 | > 2 days 09:08:28.183688 | > 2 days 09:08:28.179618 | > 2 days 09:08:28.161658 | > 2 days 09:08:28.151496 | > 1 day 09:03:14.978079 | > 1 day 09:03:12.246013 | > 1 day 08:53:47.763229 | > 1 day 08:53:46.744188 | > 1 day 08:49:21.584343 | > 1 day 07:44:18.245998 | > 1 day 05:18:29.171981 | > 1 day 03:25:18.260414 | > 1 day 02:47:34.402538 | > 1 day 02:47:33.816568 | > 1 day 02:47:33.472902 | > 1 day 00:59:58.531684 | > 07:07:43.146363 | > 06:52:19.014704 | >... >... > >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 > >-- >Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-admin >