Re: [GENERAL] Procedural Code Profiling

2007-08-17 Thread Pavel Stehule
2007/8/6, Lewis Cunningham [EMAIL PROTECTED]: 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

[GENERAL] Procedural Code Profiling

2007-08-06 Thread Lewis Cunningham
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

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] Procedural Code Profiling

2007-08-06 Thread Lewis Cunningham
--- korry.douglas [EMAIL PROTECTED] wrote: execution count (number of times each statement is executed) total execution time (how long did we spend executing each statement?) longest execution time (how long did the slowest iteration take?) number of scans (total number of