Re: [HACKERS] Reporting query duration

2002-08-30 Thread Bruce Momjian
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?

Re: [HACKERS] Reporting query duration

2002-08-29 Thread Tom Lane
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

Re: [HACKERS] Reporting query duration

2002-08-29 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > There is a TODO item: > > * Allow logging of query durations > > > Currently there is no easy way to get a list of query durations in the > > server log file. My idea is to add query duration to the end of the > > query string f

Re: [HACKERS] Reporting query duration

2002-08-29 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > There is a TODO item: > * Allow logging of query durations > Currently there is no easy way to get a list of query durations in the > server log file. My idea is to add query duration to the end of the > query string for 'debug_print_query'. My