From: Ray Stell <stellr@cns.vt.edu>
To: pgsql-admin@postgresql.org
Subject: log_duration?
Date: Mon, 19 Feb 2007 11:19:37 -0500
Message-ID: <20070219161937.GA7927@cns.vt.edu> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: stellr@cns.vt.edu
Subject: Re: log_duration?
In-Reply-To: <20070219161937.GA7927@cns.vt.edu>
References: <20070219161937.GA7927@cns.vt.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox