Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9669E9FB7C5 for ; Mon, 19 Feb 2007 12:56:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 71475-03 for ; Mon, 19 Feb 2007 12:56:07 -0400 (AST) X-Greylist: delayed 00:16:04.100987 by SQLgrey-1.7.4 Received: from cooma-1.andyshellam.eu (cooma-1.andyshellam.eu [82.165.38.62]) by postgresql.org (Postfix) with ESMTP id F41079FB5A9 for ; Mon, 19 Feb 2007 12:56:07 -0400 (AST) Received: from [213.146.143.243] (port=35645 helo=[172.16.208.165]) by cooma-1.andyshellam.eu with esmtpa (Exim 4.66) (envelope-from ) id 1HJBaO-0006Wm-Mw; Mon, 19 Feb 2007 16:41:56 +0000 Message-ID: <45D9D2CB.1040600@mailnetwork.co.uk> Date: Mon, 19 Feb 2007 16:39:39 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Ray Stell CC: pgsql-admin@postgresql.org Subject: Re: log_duration? References: <20070219161937.GA7927@cns.vt.edu> In-Reply-To: <20070219161937.GA7927@cns.vt.edu> Content-Type: multipart/alternative; boundary="------------010402020806060606080103" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.375 tagged_above=0 required=5 tests=BAYES_50, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/271 X-Sequence-Number: 24736 This is a multi-part message in MIME format. --------------010402020806060606080103 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Ray Stell wrote: > 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. > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > !DSPAM:37,45d9d01c18514452914812! > > > Probably best to restart Postgres, yes. I've observed logging functions to not take effect without a restart. Andy. --------------010402020806060606080103 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Ray Stell wrote:
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.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

!DSPAM:37,45d9d01c18514452914812!


  
Probably best to restart Postgres, yes.  I've observed logging functions to not take effect without a restart.

Andy.

--------------010402020806060606080103--