Re: Auto-explain patch

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

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