On 9/2/08, ITAGAKI Takahiro <[EMAIL PROTECTED]> wrote: > "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.
I was interested if it is possible to enable it for single session. Seems it is. Good. -- marko -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
