Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 07CE99F9265 for ; Fri, 10 Aug 2007 18:43:49 -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 43352-02 for ; Fri, 10 Aug 2007 18:43:39 -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 9F8C09F9972 for ; Fri, 10 Aug 2007 18:43:14 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1IJcGH-0002uW-JR for pgsql-performance@postgresql.org; Fri, 10 Aug 2007 14:43:13 -0700 Message-ID: <12099590.post@talk.nabble.com> Date: Fri, 10 Aug 2007 14:43:13 -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> <12096180.post@talk.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.186 tagged_above=0 required=5 tests=AWL=-0.141, 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/119 X-Sequence-Number: 26249 Jeff, You are CORRECT...my queries were going to /var/log/messages...had to get the Linux Admin to grant me READ access to the file... Thanks for your reply. Michelle. Jeff Frost wrote: > > Michelle, > > What platform are you on? If you're on linux, than logging to syslog will > likely show up in the /var/log/messages file. > > On Fri, 10 Aug 2007, smiley2211 wrote: > >> >> 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 >>> >>> >> >> > > -- > Jeff Frost, Owner > Frost Consulting, LLC http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > -- View this message in context: http://www.nabble.com/How-to-ENABLE-SQL-capturing----tf4238694.html#a12099590 Sent from the PostgreSQL - performance mailing list archive at Nabble.com.