| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com> |
| Cc: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, Alex Hunsaker <badalex(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: auto_explain contrib moudle |
| Date: | 2008-11-07 17:17:30 |
| Message-ID: | 1226078250.30638.3.camel@jdavis |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2008-11-07 17:24:37 | Re: Distinct types |
| Previous Message | Gianni Ciolli | 2008-11-07 17:02:05 | Re: Bitmap index - first look |