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 gat

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 n

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

[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