Re: Additional information on log_line_prefix

On Fri, Oct 25, 2013 at 02:58:12PM -0400, Andrew Dunstan wrote:
>
> On 10/25/2013 01:50 PM, Emanuel Calvo wrote:
> >
> >Hi guys,
> >
> >I'm working on a quick convertion script for query reviews and I
> >wonder if a feature request to add the following values will be
> >possible:
> >
> > %D = duration
> > %L = lock_time (lock only for this query)
> > %E = estimated rows
> > %R = total rows returned
> > %B = total bytes sent
> > %T = temporal tables used
> >
> >Those prefixes/values are just examples/proposals.
> >
> >Thanks for the hard work!
> >
> >
>
> Pretty much all of this can be got with the auto_explain module, and
> I think that's where it belongs.

The other problem is that these mostly have meaning for a line generated
by a completed query, but not for the many other lines that can appear
in that log file.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +