Re: [PERFORM] How can i find out top high load sql queries in PostgreSQL.

2012-12-17 Thread 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.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


Re: [PERFORM] How can i find out top high load sql queries in PostgreSQL.

2012-12-17 Thread Vibhor Kumar

On Dec 17, 2012, at 3:21 AM, suhas.basavaraj12  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



-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance