Postgres Pro
Downloads
Home   >   mailing lists

Re: log_min_duration_statement log parsing - Mailing list pgsql-admin

From Vladimir Rusinov
Subject Re: log_min_duration_statement log parsing
Date
Msg-id f6fdfb550803310605n115cf648q2d72f56da8f4fec1@mail.gmail.com
Whole thread Raw
In response to Re: log_min_duration_statement log parsing  (Alexey Klyukin <alexk@commandprompt.com>)
List pgsql-admin
Tree view


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

pgsql-admin by date:

Previous
From: Julius Tuskenis
Date:
Subject: Re: what is the origin of postgreSQL time
Next
From: Tom Lane
Date:
Subject: Re: what is the origin of postgreSQL time