Thanks Tom, Depesz,
On Wed, Feb 10, 2010 at 1:15 PM, Tom Lane wrote:
> turn off log_statement and instead set
> log_min_duration_statement = 0 to log everything via duration logging.
That does the trick. Time to write more test cases.
Thanks
Baron
--
Sent via pgsql-general mailing list (pgsq
Baron Schwartz writes:
> 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 alwa
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
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. I