Re: Reporting query duration

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