pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: How can i find out top high load sql queries in PostgreSQL.
3+ messages / 3 participants
[nested] [flat]
* Re: How can i find out top high load sql queries in PostgreSQL.
@ 2012-12-17 09:21 suhas.basavaraj12 <suhas.b@verse.in>
2012-12-17 16:33 ` Re: How can i find out top high load sql queries in PostgreSQL. Vibhor Kumar <vibhor.kumar@enterprisedb.com>
0 siblings, 1 reply; 3+ messages in thread
From: suhas.basavaraj12 @ 2012-12-17 09:21 UTC (permalink / raw)
To: pgsql-performance
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-t...
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How can i find out top high load sql queries in PostgreSQL.
2012-12-17 09:21 Re: How can i find out top high load sql queries in PostgreSQL. suhas.basavaraj12 <suhas.b@verse.in>
@ 2012-12-17 16:33 ` Vibhor Kumar <vibhor.kumar@enterprisedb.com>
2012-12-19 19:13 ` Re: How can i find out top high load sql queries in PostgreSQL. Igor Neyman <ineyman@perceptron.com>
0 siblings, 1 reply; 3+ messages in thread
From: Vibhor Kumar @ 2012-12-17 16:33 UTC (permalink / raw)
To: suhas.basavaraj12 <suhas.b@verse.in>; +Cc: pgsql-performance
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How can i find out top high load sql queries in PostgreSQL.
2012-12-17 09:21 Re: How can i find out top high load sql queries in PostgreSQL. suhas.basavaraj12 <suhas.b@verse.in>
2012-12-17 16:33 ` Re: How can i find out top high load sql queries in PostgreSQL. Vibhor Kumar <vibhor.kumar@enterprisedb.com>
@ 2012-12-19 19:13 ` Igor Neyman <ineyman@perceptron.com>
0 siblings, 0 replies; 3+ messages in thread
From: Igor Neyman @ 2012-12-19 19:13 UTC (permalink / raw)
To: Vibhor Kumar <vibhor.kumar@enterprisedb.com>; suhas.basavaraj12 <suhas.b@verse.in>; +Cc: pgsql-performance
> -----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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-12-19 19:13 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-12-17 09:21 Re: How can i find out top high load sql queries in PostgreSQL. suhas.basavaraj12 <suhas.b@verse.in>
2012-12-17 16:33 ` Vibhor Kumar <vibhor.kumar@enterprisedb.com>
2012-12-19 19:13 ` Igor Neyman <ineyman@perceptron.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox