| From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
|---|---|
| To: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>, suhas(dot)basavaraj12 <suhas(dot)b(at)verse(dot)in> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: How can i find out top high load sql queries in PostgreSQL. |
| Date: | 2012-12-19 19:13:42 |
| Message-ID: | A76B25F2823E954C9E45E32FA49D70EC08F43B2C@mail.corp.perceptron.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> -----Original Message-----
> From: Vibhor Kumar [mailto:vibhor(dot)kumar(at)enterprisedb(dot)com]
> Sent: Monday, December 17, 2012 11:34 AM
> To: suhas.basavaraj12
> Cc: pgsql-performance(at)postgresql(dot)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(dot)b(at)verse(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo Rosenfeld Rosas | 2012-12-19 19:35:57 | PG 9.1 performance loss due to query plan being changed depending on db data (4s vs 200ms) |
| Previous Message | Jeff Janes | 2012-12-19 14:40:54 | Re: [PERFORM] Slow query: bitmap scan troubles |