Postgres Pro
Downloads
Home   >   mailing lists

Re: EXPLAIN ANALYZE time calculations - Mailing list pgsql-performance

From Tom Lane
Subject Re: EXPLAIN ANALYZE time calculations
Date
Msg-id 549.1196644225@sss.pgh.pa.us
Whole thread Raw
In response to Re: EXPLAIN ANALYZE time calculations  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-performance
Tree view 
Michael Glaesemann <grzm@seespotcode.net> 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 all
the loops.

            regards, tom lane

pgsql-performance by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: EXPLAIN ANALYZE time calculations
Next
From: Matthew
Date:
Subject: Re: Dealing with big tables