Re: Understanding EXPLAIN ANALYZE output - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Understanding EXPLAIN ANALYZE output
Date
Msg-id 20050209190430.GB13746@dcc.uchile.cl
Whole thread Raw
In response to Understanding EXPLAIN ANALYZE output  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
On Wed, Feb 09, 2005 at 11:00:00AM -0700, Ed L. wrote:

>     34       ->  Index Scan using idx_queryoutcome_occurrencehistory_key on queryoutcome  (cost=0.00..10.28 rows=28
width=1065)(actual time=4.63..4.63 rows=0 loops=1014) 

                      ^^^^^^^^^^              ^^^^ 
>     35             Index Cond: ("outer"."key" = queryoutcome.occurrencehistory_key)


> If I understand these correctly, line 22's nested loop finished
> returning the last row 72.80ms into the query, and then line
> 21's nested loop returns its 0 rows 4769.59ms into the query.
> That would seem to mean 4696.79ms were spent executing the
> nested loop on line 21 prior to returning the first row.

4796.0 ms are the time it took for 34's index scan to complete the 1014
loops, I'd think.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"La naturaleza, tan frágil, tan expuesta a la muerte... y tan viva"

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: EXTPROC External Procedure
Next
From: Pavel Stehule
Date:
Subject: Re: EXTPROC External Procedure