Re: debug_print_plan (pg7.4) doesn't seem to do anything - Mailing list pgsql-general

Eric Brown <eric.brown@propel.com> writes:
> On Dec 29, 2004, at 2:28 PM, Tom Lane wrote:
>> Eric Brown <eric.brown@propel.com> writes:
>>> I thought setting debug_print_plan was supposed to explain every query
>>> in my log file? I don't see the plan print either.
>>
>> No, it just prints the plan.  With settings like yours I get

> I don't get the the "DEBUG:  parse tree:" or the DETAIL lines at all.

[ scratches head... ]  Are you sure debug_print_plan is really on?
Check it with SHOW.  It's hard to see why that debug output wouldn't get
to the log if the rest of the debug messages do.

            regards, tom lane