Baron Schwartz <baron@xxxxxxxxx> 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 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? If the statement text was already printed due to log_statement, duration logging doesn't repeat it. So if you prefer that type of display, turn off log_statement and instead set log_min_duration_statement = 0 to log everything via duration logging. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
