| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Lewis Cunningham" <lewisc(at)rocketmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Procedural Code Profiling |
| Date: | 2007-08-17 07:31:19 |
| Message-ID: | 162867790708170031v318bbc1dyb3e85bdbcdf280d7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2007/8/6, Lewis Cunningham <lewisc(at)rocketmail(dot)com>:
> Hi all,
>
> What is the best tool for an app to profile procedural code in
> postgres? I want to instrument my code and trace it so that I can
> see which code bits are sucking up the cpu and time. I know I can
> stick messages in the code and gather my own stats but I was
> wondering is there are any good tools to automate this.
>
> Specifically working with pl/pgSQL and 8.2 (on Linux or windows) if
> that helps.
>
> Thanks,
>
> LewisC
>
pgfouine is the best
Regards
Pavel Stehule
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kari Lavikka | 2007-08-17 07:35:20 | Vacuum problem |
| Previous Message | Tyson Lloyd Thwaites | 2007-08-17 07:08:36 | Re: [RESEND] Transaction auto-abort causes grief with Spring Framework |