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/
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 |