"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