From: ktm@rice.edu <ktm@rice.edu>
To: Thara Vadakkeveedu <tharagv@yahoo.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: CPU usage by sqls
Date: Mon, 21 Oct 2013 12:48:40 -0500
Message-ID: <20131021174840.GA20049@aart.rice.edu> (raw)
In-Reply-To: <1382372298.2702.YahooMailNeo@web125005.mail.ne1.yahoo.com>
References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com>
<1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com>
<1382372298.2702.YahooMailNeo@web125005.mail.ne1.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ktm@rice.edu, tharagv@yahoo.com
Subject: Re: CPU usage by sqls
In-Reply-To: <20131021174840.GA20049@aart.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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