Understanding the explain statement

From: "Benjamin Wragg" <bwragg(at)tpg(dot)com(dot)au>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Understanding the explain statement
Date: 2003-06-12 22:30:31
Message-ID: 000001c33132$3d9e82b0$0a00a8c0@mapping12
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

Something I never have really understood is the explain statement. I
know that it shows the query execution plan, but how am I meant to
understand the output? For example could someone give me some pointers
as to what is happening below?

Unique (cost=10.25..10.47 rows=4 width=80)

-> Sort (cost=10.25..10.25 rows=44 width=80)

-> Nested Loop (cost=0.00..9.04 rows=44 width=80)

-> Index Scan using region_pkey on region
(cost=0.00..3.01 rows=1 width=32)

-> Index Scan using feature_the_geom_idx on feature
(cost=0.00..6.01 rows=1 width=48

)

Any pointers to some docs would be good.

Thanks,

Benjamin

Browse pgsql-novice by date

  From Date Subject
Next Message Lynna Landstreet 2003-06-12 23:08:06 Multibyte support and accented characters
Previous Message Lynna Landstreet 2003-06-12 21:33:09 Re: Question regarding keyword checkboxes in database