In /usr/local/pgsql/doc/html/runtime-config.html: DEBUG_PRINT_PARSE (boolean), DEBUG_PRINT_PLAN (boolean), DEBUG_PRINT_REWRITTEN (boolean), DEBUG_PRINT_QUERY (boolean),DEBUG_PRETTY_PRINT (boolean) For any executed query, prints either the query, the parse tree, the execution plan, or the query rewriter output to the server log. DEBUG_PRETTY_PRINT selects are nicer but longer output format. The order of the lists do not seem to match. BTW can I send to the bugs list w/o subscribing? I'm not sure so I'm sending to general. -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html