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 discussed. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + 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 match
