CPU usage by sqls

From: Thara Vadakkeveedu <tharagv(at)yahoo(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: CPU usage by sqls
Date: 2013-10-21 16:18:18
Message-ID: 1382372298.2702.YahooMailNeo@web125005.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.
thanks,
thara.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2013-10-21 17:05:53 Re: CPU usage by sqls
Previous Message Oscar Calderon 2013-10-18 17:23:51 Re: Strange results using pg_restore