Re: debug_print_plan

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: pgsql-general(at)postgresql(dot)org, Josh Berkus <josh(at)agliodbs(dot)com>
Subject: Re: debug_print_plan
Date: 2005-03-23 20:05:30
Message-ID: 20050323200530.GA53187@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-03-23 20:13:41 Re: Changing constraints to deferrable
Previous Message Jim Buttafuoco 2005-03-23 20:04:20 Re: inherited table and rules