Re: Auto-explain patch

On 9/2/08, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> wrote:
> "Marko Kreen" <markokr(at)gmail(dot)com> wrote:
> > On 8/28/08, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> wrote:
> > > You can use shared_preload_libraries or local_preload_libraries to
> > > load the module automatically. If you do so, you also need to add
> > > "explain" in custom_variable_classes and define explain.* variables
> > > in your postgresql.conf.
> >
> > Is it possible to use LOAD command to load the module?
>
> Yes, but disabled in default.
> You need to enable it like:
>
> LOAD 'auto_explain';
> SET explain.log_min_duration = '100ms';
>
> SET explain.log_analyze = true;
>
> SELECT ...
>
> In that case, you don't need to define custom_variable_classes.

I was interested if it is possible to enable it for single session.
Seems it is. Good.

--
marko