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 121878B9C50 for ; Sun, 6 Feb 2005 00:10:31 +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 62294-07 for ; Sun, 6 Feb 2005 00:10:13 +0000 (GMT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by svr1.postgresql.org (Postfix) with ESMTP id B0ADB8B9B58 for ; Sun, 6 Feb 2005 00:10:14 +0000 (GMT) Received: from [212.227.126.207] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1Cxa0B-00005v-00; Sun, 06 Feb 2005 01:10:11 +0100 Received: from [192.59.128.130] (helo=stromboli) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 1Cxa0B-0002BI-00; Sun, 06 Feb 2005 01:10:11 +0100 From: "Simon Riggs" To: "Simon Riggs" , "Tom Lane" , Cc: Subject: Re: log_duration Date: Sat, 5 Feb 2005 15:10:04 -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) In-Reply-To: Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 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.021 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/49 X-Sequence-Number: 16217 >Simon Riggs > > 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, Further update on this: We've isolated this issue to JDBC client access. When connecting using the latest JDBC driver, we do not get "Duration:" LOG messages when using log_duration = true. [driver 8.0-310.jdbc2.jar] We've tested both localhost connections and remotely connected users with libpq clients and these do produce the log records for the "Duration:" as we would expect. Is this a V2/V3 protocol issue? Or a bug? (If so, where) Thanks for any help. Best Regards, Simon Riggs