X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D1AA332A173 for ; Wed, 20 Oct 2004 21:16:19 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22493-09 for ; Wed, 20 Oct 2004 20:16:14 +0000 (GMT) Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id 9C75332A11A for ; Wed, 20 Oct 2004 21:16:10 +0100 (BST) thread-index: AcS24aR5CezrwqLOQUugMB0+yP2+IA== Received: from [10.4.13.50] ([66.194.26.150]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.211); Wed, 20 Oct 2004 16:16:11 -0400 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Message-ID: <4176C7CA.6060006@sermonaudio.com> Date: Wed, 20 Oct 2004 16:17:14 -0400 From: "Chris Hoover" User-Agent: Mozilla Thunderbird 0.8 (X11/20040920) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Subject: question on postgresql.conf parameters (debug_print_xxx) X-Enigmail-Version: 0.86.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 20 Oct 2004 20:16:11.0607 (UTC) FILETIME=[A4725670:01C4B6E1] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/262 X-Sequence-Number: 15255 I need some help understanding what the difference is between the following debug_print parameters. I have tried them all and they all seem to give me the same output (looks like an explain verbose). Anyway, I am really wanted to just have the db print a simple explain to the log for each query so we can see where problems may be in some new code we are developing. Is there a way to do this? I really don't want the verbose output since I'm not very comfortable figuring out what it is telling me. Parameters: debug_print_parse debug_print_rewritten debug_print_plan Thanks for any explanation on these. Chris postgresql-7.3.4