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
----------------------------------------------------------