Re: Auto-explain patch

On 9/2/08, ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> wrote:
>  "Marko Kreen" <markokr@gmail.com> wrote:
>  > On 8/28/08, ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.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