Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Bruce Momjian writes: > >> LOG: duration(secs): 0.000257 > >> LOG: duration(secs): 0.000754 > >> LOG: duration(secs): 0.008115 select * from pg_class; > > > I think the units typically go after the number. > > In any case, this is unnecessarily incompatible with everything else. > EXPLAIN and psql's \timing show query durations in milliseconds. And > isn't log_min_duration_statement itself measured in milliseconds? > > I would prefer to see the log entries look like > > LOG: query: select * from pg_class; > LOG: duration: nn.nnn msec > > in all cases, rather than moving information around depending on which > combination of switches happens to have caused the log entries to be > generated. Am willing to fix the code to make this happen.
The problem with two lines is that another log message could get between them. I agree milliseconds makes more sense for output. Maybe: LOG: duration: nn.nnn msec, select * from pg_class; -- 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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly