Re: [GENERAL] Procedural Code Profiling

2007-08-06 Thread korry.douglas
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

Re: [GENERAL] "timer" script from SAMS book or equivalent?

2007-10-09 Thread korry.douglas
In the book PostgreSQL (2nd ed) the author mentions a timer script he wrote to analyze various performance bits about PostgreSQL. I've looked everywhere and can't find it. Does anyone know where I can find a copy, or find an equivalent tool? Hi John, sorry for the delay in getting back to