Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > If you are using an external tool, can't you just restrict what you
> > display based on the logged duration?
> I think his basic complaint is that doing the full logging pushup for
> even short-duration queries is too expensive, and that logging only the
> duration and not the query text or parameters makes a significant speed
> difference.  I'm not at all sure that I buy that, but if it's true then
> subsequent filtering obviously doesn't help.

Well, except for bind, all the log output display is zero cost, just a
printf(), as I remember.  The only cost that is significant, I think, is
the timing of the query, and that is happening for all the setttings

  Bruce Momjian   [EMAIL PROTECTED]

  + If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to