Re: EXPLAIN ANALYZE time calculations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: EXPLAIN ANALYZE time calculations
Date: 2007-12-03 01:10:25
Message-ID: 549.1196644225@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Michael Glaesemann <grzm(at)seespotcode(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew 2007-12-03 10:35:27 Re: Dealing with big tables
Previous Message Michael Glaesemann 2007-12-03 01:06:07 Re: EXPLAIN ANALYZE time calculations