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"
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
