| From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
|---|---|
| To: | Thara Vadakkeveedu <tharagv(at)yahoo(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: CPU usage by sqls |
| Date: | 2013-10-22 13:56:27 |
| Message-ID: | A76B25F2823E954C9E45E32FA49D70EC42838BF4@mail.corp.perceptron.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Linus Kamb | 2013-10-23 16:25:08 | Unable to connect. Log : PDTWARNING: worker took too long to start; canceled |
| Previous Message | Ilya Kosmodemiansky | 2013-10-22 09:05:55 | PostgreSQL 9.2.5 Open SuSe rpm |