From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | David Parker <dparker(at)tazznetworks(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Increasing the length of |
Date: | 2004-12-01 18:12:06 |
Message-ID: | 1101924726.2560.20.camel@camel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 2004-12-01 at 11:47, Bruce Momjian wrote:
> David Parker wrote:
> > How difficult would it be to make the combination
> >
> > log_statement = all
> > log_duration = true
> >
> > just put the duration on the same line as the statement? Then
> > log_min_duration_statement could be used to
> > do the desired log-at-threshold behavior, which certainly seems
> > valuable. You'd need a way to visually/scriptually (?) distinguish those
> > log records, though, I guess.
> >
> > Note that my original post on this was more of a question than an
> > objection - it's entirely possible to sed around having duration and
> > statement on separate lines - I just wanted clarification. Having them
> > on the same line IS handy, however....
>
> Many people want the statement printed when it starts (for real-time
> server monitoring), not when it finishes, meaning we don't know the
> duration at start time.
>
I think what David is asking for is log_statement and log_duration to
print on the same line at query completion time. We could then change
log_min_duration_statement to print DurationExceeded <duration> rather
than just Duration <time> like it does now, also on the same line, but
with a way to differentiate the two.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | simon | 2004-12-01 18:34:03 | Re: Please release (was Re: nodeAgg perf tweak) |
Previous Message | Antti Salmela | 2004-12-01 17:24:15 | Index used incorrectly with regular expressions on 7.4.6 |