Re: [PERFORM] EXPLAIN ANALYZE time calculations

2007-12-02 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > 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? Correct, just as the total time and tuples returned are averages over a

Re: [PERFORM] EXPLAIN ANALYZE time calculations

2007-12-02 Thread Michael Glaesemann
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/lo

Re: [PERFORM] EXPLAIN ANALYZE time calculations

2007-12-02 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > I'd like to get confirmation that I'm correctly understanding the > times given in EXPLAIN ANALYZE. > ... > Is this correct? Looks about right to me. Note that some of what you are calling "executor overhead" might also be classed as "gettimeofda