Understanding the output of EXPLAIN ANALYSE - Mailing list pgsql-novice

From Thurber, Fred
Subject Understanding the output of EXPLAIN ANALYSE
Date
Msg-id 42FD6908B3553343B8957500E798AABD19B4D93F03@EXCHCCR04.ad.local
Whole thread Raw
Responses Re: Understanding the output of EXPLAIN ANALYSE
Re: Understanding the output of EXPLAIN ANALYSE
List pgsql-novice
I am a newbie to PostgreSQL and am a little confused by the execution plan of a query we are working.  The SQL does some joins and the resulting plan looked like this:
 
"Nested Loop  (cost=78.63..101.14 rows=1 width=256) (actual time=0.000..16.000 rows=2818 loops=1)"
"Total runtime: 16.000 ms"
 
 
 
So the cost was 101.  We put indexes on the two tables that were being joined and re-ran EXPLAIN ANALYZE.  The cost went way down, but the execution time went way up.  What am I missing?
 
"Nested Loop  (cost=0.00..15.28 rows=1 width=256) (actual time=0.000..110.000 rows=2818 loops=1)"
"Total runtime: 110.000 ms"
 
 

pgsql-novice by date:

Previous
From: Christopher Browne
Date:
Subject: Re: [Slony1-general] Question on Load balancing
Next
From: Greg Stark
Date:
Subject: Re: Understanding the output of EXPLAIN ANALYSE