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? You would

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 only

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 for

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 pid, I