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

[suhas.basavaraj12]

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.

[Vibhor Kumar]

Post by suhas.basavaraj12
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

[Igor Neyman]

-----Original Message-----
Sent: Monday, December 17, 2012 11:34 AM
To: suhas.basavaraj12
Subject: Re: How can i find out top high load sql queries in
PostgreSQL.

Post by suhas.basavaraj12
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