Re: Reporting query duration

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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