Re: EXPLAIN ANALYZE time calculations

[Michael Glaesemann <grzm(at)seespotcode(dot)net>]

On Dec 2, 2007, at 19:56 , Tom Lane wrote:

> IOW the actual time to get in and out of a node is going to be a  
> shade more
> than is reported.

Thanks, Tom. Should be close enough for jazz.

When I was first going over the Using Explain section, I stumbled a  
bit on the startup time/total time/loops bit (which is why explain- 
analyze.info times and percentages are currently miscalculated). I  
took startup time to be the time to return the first row *of the  
first loop*. But it's actually the average startup time to return the  
first row *in each loop*, right?

Michael Glaesemann
grzm seespotcode net