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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> -----Original Message-----
> From: Vibhor Kumar [mailto:vibhor.kumar@xxxxxxxxxxxxxxxx]
> Sent: Monday, December 17, 2012 11:34 AM
> To: suhas.basavaraj12
> Cc: pgsql-performance@xxxxxxxxxxxxxx
> 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@xxxxxxxx>
> 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


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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux