Bruce Momjian <pgman@candle.pha.pa.us> 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 problem is that to print
> the duration, I would have to print the query _after_ it is executed,
> rather than before.
Well, that's what makes it a bad idea, eh?
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.
> Should we rename it and support both log_print_query and
> debug_print_query for one release?
If we're gonna rename config variables, let's just rename them.
People don't try to pipe their old postgresql.conf files into psql,
so I don't think there's a really good argument for supporting old
variable names for a long time.
regards, tom lane