X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E61408B9E63 for ; Sat, 5 Feb 2005 01:12:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62455-05 for ; Sat, 5 Feb 2005 01:12:49 +0000 (GMT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.189]) by svr1.postgresql.org (Postfix) with ESMTP id 367B78B9E7F for ; Sat, 5 Feb 2005 01:12:50 +0000 (GMT) Received: from [212.227.126.207] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1CxEV8-0007Es-00; Sat, 05 Feb 2005 02:12:42 +0100 Received: from [192.59.128.130] (helo=stromboli) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 1CxEV8-0003WT-00; Sat, 05 Feb 2005 02:12:42 +0100 From: "Simon Riggs" To: "Tom Lane" Cc: Subject: Re: log_duration Date: Fri, 4 Feb 2005 16:12:31 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 In-Reply-To: <17884.1107555067@sss.pgh.pa.us> Importance: Normal X-Provags-ID: kundenserver.de abuse@kundenserver.de auth:51320d06ba6b43864a3fe5d428030dbe X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.027 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/44 X-Sequence-Number: 16212 > From: Tom Lane > "Simon Riggs" writes: > > On top of a confusing day, I now have this: > > I set log_duration = true in a postgresql.conf file. > > I startup and test, local users connected via psql: > working, no problem. > > Users connecting remotely, same user, same database: no log of query > > statement durations. > > There is nothing in the code that sets this value > independently for sets > > of users (is there?) > > No. How sure are you that the remote users are really > connecting to the > same postmaster? Yes, very definitely. I'm sitting here watching the Statement: lines scroll up the screen for the remotely connected users. Local sessions show both Statement: and Duration: Can't see anything in the code that gives any kind of conditional on that. The code is straight 8.0.1, no code editing, but compiled on SUSE. I wouldn't care, but I'm trying to tune the database, so the missing data matters, Best Regards, Simon Riggs