2007/8/6, Lewis Cunningham <lewisc@rocketmail.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