Postgres Pro
Downloads
Home   >   mailing lists

Re: How can i find out top high load sql queries in PostgreSQL. - Mailing list pgsql-performance

From Igor Neyman
Subject Re: How can i find out top high load sql queries in PostgreSQL.
Date
Msg-id A76B25F2823E954C9E45E32FA49D70EC08F43B2C@mail.corp.perceptron.com
Whole thread Raw
In response to Re: How can i find out top high load sql queries in PostgreSQL.  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
List pgsql-performance
Tree view 
> -----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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: hash join vs nested loop join
Next
From: Rodrigo Rosenfeld Rosas
Date:
Subject: PG 9.1 performance loss due to query plan being changed depending on db data (4s vs 200ms)