Re: [HACKERS] Additional information on log_line_prefix

2013-11-14 Thread Bruce Momjian
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 = dura

Re: [HACKERS] Additional information on log_line_prefix

2013-10-25 Thread Andrew Dunstan
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

Re: [HACKERS] Additional information on log_line_prefix

2013-10-25 Thread David Johnston
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

[HACKERS] Additional information on log_line_prefix

2013-10-25 Thread Emanuel Calvo
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 tabl