Re: Logging statement/duration on the same line

On Wed, Feb 10, 2010 at 12:55:03PM -0500, Baron Schwartz wrote:
> I'm writing a log parser front-end. I've seen some log samples that
> look like this, with the duration and statement on the same line:
>
> LOG: duration: 1.565 ms statement: SELECT * FROM users WHERE user_id='692'
>
> But in my 8.3.9 test installation, durations are always logged on a
> separate line. Is the sample above from a different version? Or is
> there a way to get this output with different configuration? Here's
> the type of output that I see in 8.3.9:
>
> 2010-02-08 15:31:50.872 EST LOG: statement: select 1;
> 2010-02-08 15:31:50.881 EST LOG: duration: 10.870 ms

turn off log_Statement and log_duration. instead set to 0
log_min_duration_statement.

depesz

--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007