| Lists: | pgsql-hackers |
|---|
| From: | Emanuel Calvo <postgres(dot)arg(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Additional information on log_line_prefix |
| Date: | 2013-10-25 17:50:45 |
| Message-ID: | CAGHEX6burs2RD9GL+67Whex1SCDnn1ptW6aeEUyB4N=gT6WD6g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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!
--
--
Emanuel Calvo
| From: | David Johnston <polobo(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Additional information on log_line_prefix |
| Date: | 2013-10-25 18:06:25 |
| Message-ID: | 1382724385470-5775958.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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.
| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Emanuel Calvo <postgres(dot)arg(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Additional information on log_line_prefix |
| Date: | 2013-10-25 18:58:12 |
| Message-ID: | 526ABF44.5090601@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Emanuel Calvo <postgres(dot)arg(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Additional information on log_line_prefix |
| Date: | 2013-11-14 19:07:14 |
| Message-ID: | 20131114190714.GH24549@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +