Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id EE3E29FA57B for ; Tue, 9 Oct 2007 11:47:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 76841-07-4 for ; Tue, 9 Oct 2007 11:47:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.189]) by postgresql.org (Postfix) with ESMTP id 8ECD99FA587 for ; Tue, 9 Oct 2007 11:46:41 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so939233rvb for ; Tue, 09 Oct 2007 07:46:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=d56a14o9BtZRhsVKTsylfn0JUg3e6YMtd1C+V478UMM=; b=IPj9U1i3loWlpVduE0EW6P9YzrOjfQXJl6MRu8XQncK6QdB8d30hLQswgPuLfGaUjDM5Qn2IpVsB/7KOyiJLV/BFmWkO7nOVGGd03rRhtXB6yE7nq/LQOcWswN3mx4cFozoCKiFIp2pJm+2qZo8Gh6eK1+TZl+afyUae5oVClZ0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jDl1iq+Bh6wVaeQdgKr5lFDZ9o+YX+uUkC5m+lDjInVLY6QYgwW2ntdIyvACWWoILaXYiehP/so+7yQ3JHfx8TFQROhtV7+3TkH5YyXogFAOybTZelgH6Y28gHo8AcB+6ASGXuXqpQDE2h0uJjXPA2Xo9rb7tBFCJVvHNkgxg9U= Received: by 10.141.42.10 with SMTP id u10mr1562697rvj.1191940591883; Tue, 09 Oct 2007 07:36:31 -0700 (PDT) Received: by 10.140.148.11 with HTTP; Tue, 9 Oct 2007 07:36:31 -0700 (PDT) Message-ID: <179149fe0710090736l1a863d71yb04e2598d0faed4e@mail.gmail.com> Date: Tue, 9 Oct 2007 16:36:31 +0200 From: "=?UTF-8?Q?Marcin_St=C4=99pnicki?=" To: pgsql-performance@postgresql.org Subject: Re: SQL Monitoring In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/84 X-Sequence-Number: 27106 On 10/9/07, Campbell, Lance wrote: > I have noticed a slight spike in the amount of CPU usage in the last few > weeks. I am sure it has to do with a change or two that was made to some > queries. What is the best way to log the SQL that is being executed? I > would prefer to limit the size of the log file to 2 G. Is there a way to do > this? > Use http://pgfouine.projects.postgresql.org/.