David Parker wrote: > How difficult would it be to make the combination > > log_statement = all > log_duration = true > > just put the duration on the same line as the statement? Then > log_min_duration_statement could be used to > do the desired log-at-threshold behavior, which certainly seems > valuable. You'd need a way to visually/scriptually (?) distinguish those > log records, though, I guess. > > Note that my original post on this was more of a question than an > objection - it's entirely possible to sed around having duration and > statement on separate lines - I just wanted clarification. Having them > on the same line IS handy, however....
Many people want the statement printed when it starts (for real-time server monitoring), not when it finishes, meaning we don't know the duration at start time. -- 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 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
