Thread: Re: How can i find out top high load sql queries in PostgreSQL.

There is a tool called pg Fouine . I am sure this will help  you..

http://pgfouine.projects.pgfoundry.org/tutorial.html

Rgrds
Suhas



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-can-i-find-out-top-high-load-sql-queries-in-PostgreSQL-tp5736854p5736865.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

On Dec 17, 2012, at 3:21 AM, suhas.basavaraj12 <suhas.b@verse.in> wrote:

> There is a tool called pg Fouine . I am sure this will help  you..
>
> http://pgfouine.projects.pgfoundry.org/tutorial.html

+1

You can also use pgbadger, which seemed more flexible than pgFouine.
http://dalibo.github.com/pgbadger/

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog:http://vibhork.blogspot.com

> -----Original Message-----
> From: Vibhor Kumar [mailto:vibhor.kumar@enterprisedb.com]
> Sent: Monday, December 17, 2012 11:34 AM
> To: suhas.basavaraj12
> Cc: pgsql-performance@postgresql.org
> Subject: Re: How can i find out top high load sql queries in
> PostgreSQL.
>
>
> On Dec 17, 2012, at 3:21 AM, suhas.basavaraj12 <suhas.b@verse.in>
> wrote:
>
> > There is a tool called pg Fouine . I am sure this will help  you..
> >
> > http://pgfouine.projects.pgfoundry.org/tutorial.html
>
> +1
>
> You can also use pgbadger, which seemed more flexible than pgFouine.
> http://dalibo.github.com/pgbadger/
>
> Thanks & Regards,
> Vibhor Kumar
> EnterpriseDB Corporation
> The Enterprise PostgreSQL Company
> Blog:http://vibhork.blogspot.com
>

Pg_stat_statements extension tracks SQL statements execution statistics.

Regards,
Igor Neyman