From: | Ehab Galal <ehabgalal123(at)hotmail(dot)com> |
---|---|
To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | materialize |
Date: | 2007-11-26 21:17:14 |
Message-ID: | BAY138-W1297C42D3E676BE815771E96750@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Greetings,
I was wondering why do we need the Materialize node in the plan below when i explain a query?
1: QUERY PLAN = "Nested Loop (cost=10.99..24.34 rows=1 width=846)" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " Join Filter: (("inner".cover)::text = ("outer".cover)::text)" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " -> Index Scan using idx_cover_ftn_ on c_cover_ftn (cost=0.00..9.30 rows=2 width=86)" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " Index Cond: (username = 'user1'::name)" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " -> Materialize (cost=10.99..11.89 rows=90 width=842)" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " -> Seq Scan on books (cost=0.00..10.90 rows=90 width=842)" (typeid = 25, len = -1, typmod = -1, byval = f)
----
Thanks,
Ehab
_________________________________________________________________
Your smile counts. The more smiles you share, the more we donate. Join in.
www.windowslive.com/smile?ocid=TXT_TAGLM_Wave2_oprsmilewlhmtagline
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-11-26 21:53:45 | Re: materialize |
Previous Message | Andreas Joseph Krogh | 2007-11-26 21:08:01 | PG trouble with index-usage in sort |