Re: debug_print_plan (pg7.4) doesn't seem to do anything

On Dec 29, 2004, at 3:16 PM, Tom Lane wrote:
> Eric Brown <eric(dot)brown(at)propel(dot)com> writes:
>> On Dec 29, 2004, at 2:28 PM, Tom Lane wrote:
>>> Eric Brown <eric(dot)brown(at)propel(dot)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.

The problem was syslog. Postgresql logs to facility local0 by default
and I wasn't logging that at debug level.