Re: CPU usage by sqls

On Mon, Oct 21, 2013 at 10:18 AM, Thara Vadakkeveedu <tharagv@yahoo.com> wrote:
> Hi
> Is there a way to get cpu utilization of various sql statements during a
> specific time period on postgresql ?
> Say I start a performance test, I would like to collect a top sql report at
> the end of the test (like in sql server) that gives details of the top cpu
> consuming sqls..
> Also wondering if there is a sql profiler on postgressql that indicates the
> number of rows read and written to by sql statements, cpu cost, elapsed time
> etc during a profiled session.

Maybe not the exact CPU usage but you can get a nice report on the
most expensive queries (either individually expensive or as a group
etc) from pgbadger.

http://dalibo.github.io/pgbadger/