Re: [GENERAL] Logging statement/duration on the same line

2010-02-10 Thread Baron Schwartz
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

Re: [GENERAL] Logging statement/duration on the same line

2010-02-10 Thread Tom Lane
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

Re: [GENERAL] Logging statement/duration on the same line

2010-02-10 Thread hubert depesz lubaczewski
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

[GENERAL] Logging statement/duration on the same line

2010-02-10 Thread Baron Schwartz
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