Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 25EAD2E002D for ; Mon, 31 Mar 2008 10:05:50 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 77785-01 for ; Mon, 31 Mar 2008 10:05:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.234]) by developer.postgresql.org (Postfix) with ESMTP id 2FA352E003B for ; Mon, 31 Mar 2008 10:05:43 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id r21so1451271wxc.28 for ; Mon, 31 Mar 2008 06:05:42 -0700 (PDT) Received: by 10.70.36.20 with SMTP id j20mr7951763wxj.57.1206968741261; Mon, 31 Mar 2008 06:05:41 -0700 (PDT) Received: by 10.70.126.7 with HTTP; Mon, 31 Mar 2008 06:05:41 -0700 (PDT) Message-ID: Date: Mon, 31 Mar 2008 17:05:41 +0400 From: "Vladimir Rusinov" To: "Vladimir Rusinov" , pgsql-admin@postgresql.org Subject: Re: log_min_duration_statement log parsing In-Reply-To: <20080331121934.GA7007@vollmond> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3821_12938528.1206968741260" References: <20080331121934.GA7007@vollmond> X-Archive-Number: 200803/278 X-Sequence-Number: 28761 ------=_Part_3821_12938528.1206968741260 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Mon, Mar 31, 2008 at 4:19 PM, Alexey Klyukin wrote: > > And may be someone have such script or other ideas how to log > long-running > > statements in order to optimize them? > > I suggest you to take a look at pgFouine: > http://pgfouine.projects.postgresql.org/ Yes, according to description it is actually what we need. Thanks a lot! (Next time I should google before asking questions, sorry) -- Vladimir Rusinov Voronezh, Russia UNIX Admin @ Murano Software ------=_Part_3821_12938528.1206968741260 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On Mon, Mar 31, 2008 at 4:19 PM, Alexey Klyukin <alexk@commandprompt.com> wrote:
> And may be someone have such script or other ideas how to log long-running
> statements in order to optimize them?

I suggest you to take a look at pgFouine:
http://pgfouine.projects.postgresql.org/
 
Yes, according to description it is actually what we need.
Thanks a lot!

(Next time I should google before asking questions, sorry)

--
Vladimir Rusinov
Voronezh, Russia
UNIX Admin @ Murano Software ------=_Part_3821_12938528.1206968741260--