| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Geek Matter <geekmatter(at)yahoo(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: profiling store procedure |
| Date: | 2012-03-23 08:04:37 |
| Message-ID: | 1332489877.3142.5.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2012-03-23 at 00:16 -0700, Geek Matter wrote:
> what tool is suitable for profiling store procedure in postgresql? sql server has sql profiles, how about postgresql?
The EDB PL/pgsql profiler tool is probably the easier tool to work with
if you want to profile PL/pgsql functions. That's also the only
available automatic tool I know.
You can also use the manual way, but it isn't easy. See this great post
from Hubert Lubaczewski (aka Depesz):
http://www.depesz.com/2010/03/18/profiling-stored-proceduresfunctions/
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Lanitz | 2012-03-23 08:14:06 | Re: PostgreSQL 64 Bit XIDs - Transaction IDs |
| Previous Message | Sergey Konoplev | 2012-03-23 08:04:01 | Re: profiling store procedure |