On Fri, Dec 16, 2005 at 08:49:32PM +, Carlos Benkendorf wrote:
> I would like to say "take longer than" with "bad" statements...
> but I´m only logging statements that take longer than 700 ms
> and DECLARE statements are not logged of course.
>
> I think the only way in my case is logging
Sorry, I would like to say "take longer than" with "bad" statements... but I´m only logging statements that take longer than 700 ms and DECLARE statements are not logged of course. I think the only way in my case is logging all statements... Am I right? Or is there another way? Thanks
On Fri, Dec 16, 2005 at 06:28:03PM +, Carlos Benkendorf wrote:
> I´m trying to discover some bad SQL statements in our environment
> but the logs are not helping too much... they say we´ve some very
> bad fetch statements but I don´t know how to discover the
> corresponding SELECT statement...
Hi, I´m trying to discover some bad SQL statements in our environment but the logs are not helping too much... they say we´ve some very bad fetch statements but I don´t know how to discover the corresponding SELECT statement... How can I find them? Some example: <10.0.1.122(3821) 5072 200
