pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCPU usage by sqls
4+ messages / 4 participants
[nested] [flat]
* CPU usage by sqls
@ 2013-10-21 16:18 Thara Vadakkeveedu <tharagv@yahoo.com>
2013-10-21 17:05 ` Re: CPU usage by sqls Scott Marlowe <scott.marlowe@gmail.com>
2013-10-21 17:48 ` Re: CPU usage by sqls ktm@rice.edu <ktm@rice.edu>
2013-10-22 13:56 ` Re: CPU usage by sqls Igor Neyman <ineyman@perceptron.com>
0 siblings, 3 replies; 4+ messages in thread
From: Thara Vadakkeveedu @ 2013-10-21 16:18 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: CPU usage by sqls
2013-10-21 16:18 CPU usage by sqls Thara Vadakkeveedu <tharagv@yahoo.com>
@ 2013-10-21 17:05 ` Scott Marlowe <scott.marlowe@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2013-10-21 17:05 UTC (permalink / raw)
To: Thara Vadakkeveedu <tharagv@yahoo.com>; +Cc: pgsql-admin
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/
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: CPU usage by sqls
2013-10-21 16:18 CPU usage by sqls Thara Vadakkeveedu <tharagv@yahoo.com>
@ 2013-10-21 17:48 ` ktm@rice.edu <ktm@rice.edu>
2 siblings, 0 replies; 4+ messages in thread
From: ktm@rice.edu @ 2013-10-21 17:48 UTC (permalink / raw)
To: Thara Vadakkeveedu <tharagv@yahoo.com>; +Cc: pgsql-admin
On Mon, Oct 21, 2013 at 09:18:18AM -0700, Thara Vadakkeveedu 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.
> thanks,
> thara.
Hi Thara,
Have you looked at pgbadger?
Cheers,
Ken
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: CPU usage by sqls
2013-10-21 16:18 CPU usage by sqls Thara Vadakkeveedu <tharagv@yahoo.com>
@ 2013-10-22 13:56 ` Igor Neyman <ineyman@perceptron.com>
2 siblings, 0 replies; 4+ messages in thread
From: Igor Neyman @ 2013-10-22 13:56 UTC (permalink / raw)
To: Thara Vadakkeveedu <tharagv@yahoo.com>; pgsql-admin
Subject: [ADMIN] CPU usage by sqls
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.
Take a look at pg_stat_statements extension.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2013-10-22 13:56 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-10-21 16:18 CPU usage by sqls Thara Vadakkeveedu <tharagv@yahoo.com>
2013-10-21 17:05 ` Scott Marlowe <scott.marlowe@gmail.com>
2013-10-21 17:48 ` ktm@rice.edu <ktm@rice.edu>
2013-10-22 13:56 ` Igor Neyman <ineyman@perceptron.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox