Ryszard Lach wrote: > > Hi. > > I'm trying to set run-time environment in pgsql7.4 so, that it prints > all statements with duration time, but I can't understand why setting > log_min_duration_statement to '0' causes printing to syslog plenty of > lines ending with 'duration: statement:', i.e. without any statement > string (except expected ones). Can anybody help me?
Can you show us some of the log file? If I do: test=> set log_min_duration_statement = 0; SET test=> select 1; ?column? ---------- 1 (1 row) I get: LOG: duration: 0.861 ms statement: select 1; -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org