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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eric Brown <eric(dot)brown(at)propel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: debug_print_plan (pg7.4) doesn't seem to do anything
Date: 2004-12-29 23:16:26
Message-ID: 18743.1104362186@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-12-29 23:30:42 Re: pg_dump and pgpool
Previous Message Eric Brown 2004-12-29 23:09:05 Re: debug_print_plan (pg7.4) doesn't seem to do anything