Eric Brown <[EMAIL PROTECTED]> writes:On Dec 29, 2004, at 2:28 PM, Tom Lane wrote:Eric Brown <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
