Re: log_duration is redundant, no? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: log_duration is redundant, no?
Date
Msg-id 241.1157669125@sss.pgh.pa.us
Whole thread Raw
In response to Re: log_duration is redundant, no?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: log_duration is redundant, no?  (Bruce Momjian <bruce@momjian.us>)
Re: log_duration is redundant, no?  ("Guillaume Smet" <guillaume.smet@gmail.com>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: log_duration is redundant, no?
Next
From: "Guillaume Smet"
Date:
Subject: Re: log_duration is redundant, no?