"Marko Kreen" <[EMAIL PROTECTED]> wrote: > On 8/28/08, ITAGAKI Takahiro <[EMAIL PROTECTED]> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
