Re: auto_explain contrib moudle - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: auto_explain contrib moudle
Date
Msg-id 1226078250.30638.3.camel@jdavis
Whole thread Raw
In response to Re: auto_explain contrib moudle  (Martin Pihlak <martin.pihlak@gmail.com>)
Responses Re: auto_explain contrib moudle  (Martin Pihlak <martin.pihlak@gmail.com>)
List pgsql-hackers
On Fri, 2008-11-07 at 18:03 +0200, Martin Pihlak wrote:
> One thing that I noticed was that tab completion queries are also explained
> if "explain.log_min_duration" is set to zero. Actually this also applies to
> psql \dX commands. Don't know if this is deliberate or not. Example:

It's logged at the LOG level, just like log_min_duration_statement, and
seems to have the same behavior. What do you think it should do
differently?

> Another thing is a feature I am interested in -- ability to auto-explain statements
> execututed from within functions. I'm thinking of adding an extra boolean GUC --
> "explain.log_nested_statements" (defaults to false). Quick test seems to give
> expected results, but there maybe something I missed.
> 

I like that idea, I'll take a look at it.

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: Gianni Ciolli
Date:
Subject: Re: Bitmap index - first look
Next
From: Jeff Davis
Date:
Subject: Re: Distinct types