pg.ddx.io pgsql-sql@postgresql.org mailing list archive help / color / mirror / Atom feed From: Ehab Galal <ehabgalal123@hotmail.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: materialize
Date: Mon, 26 Nov 2007 16:17:14 -0500
Message-ID: <BAY138-W1297C42D3E676BE815771E96750@phx.gbl> (raw )
In-Reply-To: <14450.1194194136@sss.pgh.pa.us >
References: <BAY138-W43A1A93DB7B84F57B84211968F0@phx.gbl >
<14450.1194194136@sss.pgh.pa.us >
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=
view thread (2+ messages) latest in thread
Message-ID: <BAY138-W1297C42D3E676BE815771E96750@phx.gbl>
Permalink: ../BAY138-W1297C42D3E676BE815771E96750@phx.gbl/
Also on: postgresql.org/message-id/BAY138-W1297C42D3E676BE815771E96750@phx.gbl
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ehabgalal123@hotmail.com
Subject: Re: materialize
In-Reply-To: <BAY138-W1297C42D3E676BE815771E96750@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox