CPU usage by sqls - Mailing list pgsql-admin

From Thara Vadakkeveedu
Subject CPU usage by sqls
Date
Msg-id 1382372298.2702.YahooMailNeo@web125005.mail.ne1.yahoo.com
Whole thread Raw
In response to accidentally deleted data directory  (Thara Vadakkeveedu <tharagv@yahoo.com>)
Responses Re: CPU usage by sqls  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: CPU usage by sqls  ("ktm@rice.edu" <ktm@rice.edu>)
Re: CPU usage by sqls  (Igor Neyman <ineyman@perceptron.com>)
List 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.

pgsql-admin by date:

Previous
From: Oscar Calderon
Date:
Subject: Re: Strange results using pg_restore
Next
From: Scott Marlowe
Date:
Subject: Re: CPU usage by sqls