log_duration?

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: log_duration?
Date: 2007-02-19 16:19:37
Message-ID: 20070219161937.GA7927@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam (Mailing Lists) 2007-02-19 16:39:39 Re: log_duration?
Previous Message Alvaro Herrera 2007-02-19 15:53:08 Re: Built-in log rotation