| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Thara Vadakkeveedu <tharagv(at)yahoo(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: CPU usage by sqls |
| Date: | 2013-10-21 17:05:53 |
| Message-ID: | CAOR=d=103YrZZv9LRg+PMvXHF49wb6mDF_dM-7B1bY9AAsBUXQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Oct 21, 2013 at 10:18 AM, Thara Vadakkeveedu <tharagv(at)yahoo(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ktm@rice.edu | 2013-10-21 17:48:40 | Re: CPU usage by sqls |
| Previous Message | Thara Vadakkeveedu | 2013-10-21 16:18:18 | CPU usage by sqls |