Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8B1B99FB89E for ; Mon, 19 Feb 2007 12:19:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 75736-08 for ; Mon, 19 Feb 2007 12:19:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by postgresql.org (Postfix) with ESMTP id B9D449FB27E for ; Mon, 19 Feb 2007 12:19:37 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 23D94118A35; Mon, 19 Feb 2007 11:19:37 -0500 (EST) Date: Mon, 19 Feb 2007 11:19:37 -0500 From: Ray Stell To: pgsql-admin@postgresql.org Subject: log_duration? Message-ID: <20070219161937.GA7927@cns.vt.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200702/270 X-Sequence-Number: 24735 I toggle log_duration: wiki=# \!date Mon Feb 19 11:14:35 EST 2007 wiki=# set log_duration=off; SET wiki=# SELECT current_setting('log_duration'); current_setting ----------------- off (1 row) yet duration continues to be logged: wiki,13190,wiki,2007-02-19 11:16:00.926 EST,45d94f9e.3386,36108,2007-02-19 02:19:58 EST,270828,BIND LOG: duration: 0.034 ms wiki,13190,wiki,2007-02-19 11:16:00.929 EST,45d94f9e.3386,36109,2007-02-19 02:19:58 EST,0,COMMIT LOG: duration: 2.840 ms do I have to bounce to get it set? Thx.