Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> I think the log entries should be separate: print the query text when > >> you start, print the duration when you're done. A little bit of > >> postprocessing can reassemble the two entries. > > > How would someone reassemble them? You would have to have the pid, I > > assume. > > Sure. > > > Do we auto-enable pid output when we enable duration? Yuck. > > No, you expect the user to select the options he needs. Let's not > over-engineer a perfectly simple feature.
OK, so I will rename debug_print_query to log_print_query, and Gavin's new print query on error will also be a log_*. I will add a new GUC variable to print the query duration, and recommend in the docs that log_pid be enabled at the same time so you can match the duration with the query. Originally, I wanted to make the time just print whenever you enabled print_query, but with them on separate lines, it should be a separate GUC variable. -- 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
