Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I think they fit pretty nicely on one line, and lot of folks want that
> > information.  I realize it looks like bloatware because it duplicates
> > some existing functionality, but I think it is a combination of duration
> > and statement output that can't be done easily separately.
> Sure it can.  You're essentially arguing that DBAs are too dumb to match
> up matching query and duration log outputs.  I don't buy that.  I think
> they'll be analyzing their logs with little Perl scripts anyway, and
> that consistency of log output format will be worth more to those
> scripts than sometimes having related items all on one log line.

Yes, I am arguing that we shouldn't make people jump through Perl hoops
to get a statement/duration line in their log files.  I think it is
asked for enough that a nice printed line will help them.

If we already have the parameter, why not make it easy.  If they are
using Perl, they can already use log_statement and log_duration to print
only queries taking over a certain amount of time.

> >> BTW, there's a separate set of problems that have yet to be addressed,
> >> which is how any of these logging options apply for V3-protocol query
> >> operations.  The existing code only seems to work for the old-style
> >> query path.
> > You mean how are they passed to the client?  I assumed that would work
> > for pre-V3 clients.
> No, I mean the functionality isn't in the extended-query code path at
> all, and it's not immediately clear where to insert it (eg, which steps
> of parse/bind/execute do what logging, or where you measure duration).

I assume it would be all executor stuff, but I see what you mean that
the perpare isn't going through the normal query path.

  Bruce Momjian                        |
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to