Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 91F199F977C for ; Fri, 10 Aug 2007 14:54:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 93111-05 for ; Fri, 10 Aug 2007 14:54:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id E08809F977F for ; Fri, 10 Aug 2007 14:54:35 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1IJYh1-0004W7-3E for pgsql-performance@postgresql.org; Fri, 10 Aug 2007 10:54:35 -0700 Message-ID: <12096180.post@talk.nabble.com> Date: Fri, 10 Aug 2007 10:54:35 -0700 (PDT) From: smiley2211 To: pgsql-performance@postgresql.org Subject: Re: How to ENABLE SQL capturing??? In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: smiley2211@yahoo.com References: <12060736.post@talk.nabble.com> <20070808203612.GA26143@uio.no> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.179 tagged_above=0 required=5 tests=AWL=-0.148, BAYES_00=-2.599, DNS_FROM_OPENWHOIS=1.13, FORGED_YAHOO_RCVD=2.297, WHOIS_MYPRIVREG=1.499 X-Spam-Level: ** X-Archive-Number: 200708/108 X-Sequence-Number: 26238 Hello all, I have ENABLED this 'log_min_duration_statement = 100" but I can't figure out WHERE it's writing the commands to ...I have it set to 'syslogs' but this file is 0 bytes :confused: Should I set other parameters in my postgresql.conf file??? Thanks...Michelle Bryan Murphy-3 wrote: > > we currently have logging enabled for all queries over 100ms, and keep > the last 24 hours of logs before we rotate them. I've found this tool > very helpful in diagnosing new performance problems that crop up: > > http://pgfouine.projects.postgresql.org/ > > Bryan > > On 8/8/07, Steinar H. Gunderson wrote: >> On Wed, Aug 08, 2007 at 01:02:24PM -0700, smiley2211 wrote: >> > I am trying to enable capturing of the submitted code via an >> > application...how do I do this in Postgres? Performance is SLOW on my >> > server and I have autovacuum enabled as well as rebuilt >> indexes...whatelse >> > should be looked at? >> >> Try "log_min_duration_statement = 100" in postgresql.conf; it will show >> all >> statements that take more than 100ms. Set to 0 to log _all_ statements, >> or >> -1 to turn the logging back off. >> >> /* Steinar */ >> -- >> Homepage: http://www.sesse.net/ >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: explain analyze is your friend >> > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > -- View this message in context: http://www.nabble.com/How-to-ENABLE-SQL-capturing----tf4238694.html#a12096180 Sent from the PostgreSQL - performance mailing list archive at Nabble.com.