debug_print_plan

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/

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

elein@varlena.com (elein) writes:

I cannot get debug_print_plan to print the query plan to the
log.

/*
* Print plan if debugging.
*/
if (Debug_print_plan)
elog_node_display(DEBUG1, "plan", plan, Debug_pretty_print);

Looks like you also need to have server_min_messages <= DEBUG1.

regards, tom lane