Additional information on log_line_prefix

emanuel_calvo wrote

%E = estimated rows

How would you expect this to work? This information seems mostly useless
without the context of a full EXPLAIN output.

%T = temporal tables used

I am guessing you mean "temporary", not temporal - the later also being
known as "time oriented"

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Additional-information-on-log-line-prefix-tp5775956p5775958.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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.

cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers