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 27A1553676 for ; Fri, 25 Mar 2005 17:25:45 +0000 (GMT) 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 31697-10 for ; Fri, 25 Mar 2005 17:25:39 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 6DE6B53803 for ; Fri, 25 Mar 2005 17:25:39 +0000 (GMT) Received: from 192.168.1.52 (fc1smp [66.93.38.87]) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j2PHMckh020453; Fri, 25 Mar 2005 09:22:38 -0800 Subject: Re: explain analyze of PG server level From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: Lee Wu Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Organization: Joshua D. Drake Date: Fri, 25 Mar 2005 09:25:37 -0800 Message-Id: <1111771537.5025.27.camel@jd2.commandprompt.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.037 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/418 X-Sequence-Number: 16916 On Fri, 2005-03-25 at 10:00 -0700, Lee Wu wrote: > --> > > Hello, > > > > Is there a global PG server level explain analyze parameter I can turn > on to catch > > all SQLs issued against PG server, like Oracle SQL_TRACE, and PG > log_statement Some of these options in the postgresql.conf might help you out: #debug_print_parse = false #debug_print_rewritten = false #debug_print_plan = false #debug_pretty_print = false > > in PG 7.3.2? > > > > Thanks, > > > > > > -- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564 Custom programming, 24x7 support, managed services, and hosting Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG Reliable replication, Mammoth Replicator - http://www.commandprompt.com/