Re: Auto-explain patch

"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.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center