Aha you are right. I tried this but set log min error statement instead and so *that* didn't work.
Setting the right variable worked and I can now see the plan. Thanks!! --elein On Wed, Mar 23, 2005 at 01:05:30PM -0700, Michael Fuhr wrote: > On Wed, Mar 23, 2005 at 11:38:21AM -0800, elein wrote: > > > > I cannot get debug_print_plan to print the query plan to the > > log. I have set it in the postgresql.conf file and bounced > > the server. The output is simply not there. show shows > > that the value is set, but no output. > > What's your log_min_messages setting? According to the documentation, > debug_print_* needs DEBUG1 or lower. > > http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])