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