Procedural Code Profiling

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



-----------------------------------------------------------
Lewis R Cunningham

An Expert's Guide to Oracle Technology
http://blogs.ittoolbox.com/oracle/guide/

LewisC's Random Thoughts
http://lewiscsrandomthoughts.blogspot.com/

EnterpriseDB: The Definitive Reference
http://tinyurl.com/39246e
----------------------------------------------------------