Logging statement/duration on the same line

From: Baron Schwartz <baron(at)xaprb(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Logging statement/duration on the same line
Date: 2010-02-10 17:55:03
Message-ID: 4cfa0b031002100955w646b4527k59888d9baef5f367@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
Baron Schwartz
Percona Inc: Services and Support for MySQL
http://www.percona.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2010-02-10 18:05:32 Re: Logging statement/duration on the same line
Previous Message Gauthier, Dave 2010-02-10 17:05:29 Re: need clean way to copy col vals from one rec to another