pg.ddx.io pgsql-sql@postgresql.org mailing list archive help / color / mirror / Atom feed From: CN <cnliou9@fastmail.fm>
To: pgsql-sql@postgresql.org
Subject: Re: Creating Index
Date: Wed, 01 Oct 2003 09:02:31 -0800
Message-ID: <20031001170232.042667855B@smtp.us2.messagingengine.com> (raw )
In-Reply-To: <1065024516.85344.134.camel@jester >
References: <Pine.LNX.4.44.0310011419060.2932-100000@peter.localdomain >
<20031001152542.8C9C76F692@smtp.us2.messagingengine.com >
<1065024516.85344.134.camel@jester >
> > -> Seq Scan on table1 (cost=0.00..20.00 rows=1000 width=0) (actual
>
> Run VACUUM ANALYZE, then repost your EXPLAIN ANALYZE results please.
QUERY
PLAN
--------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1858.09..1858.09 rows=1 width=156) (actual
time=5089.34..5089.34 rows=1 loops=1)
-> Subquery Scan view1 (cost=187.86..1788.14 rows=27980 width=156)
(actual time=187.74..4952.09
rows=28482 loops=1)
-> Append (cost=187.86..1788.14 rows=27980 width=156) (actual
time=187.72..4787.18 rows=28482
loops=1)
-> Subquery Scan "*SELECT* 1" (cost=187.86..1788.14
rows=27979 width=69) (actual
time=187.72..4687.71 rows=28482 loops=1)
-> Hash Join (cost=187.86..1788.14 rows=27979
width=69) (actual time=187.68..4332.30
rows=28482 loops=1)
Hash Cond: ("outer".f1 = "inner".f1)
Join Filter: ("outer".f0 = "inner".f0)
-> Seq Scan on table2 (cost=0.00..745.82
rows=28482 width=47) (actual
time=0.27..547.90 rows=28482 loops=1)
-> Hash (cost=164.29..164.29 rows=9429
width=22) (actual time=165.17..165.17
rows=0 loops=1)
-> Seq Scan on table1
(cost=0.00..164.29 rows=9429 width=22)
(actual
time=0.23..89.18 rows=9429 loops=1)
-> Subquery Scan "*SELECT* 2" (cost=0.00..0.00 rows=1
width=156) (actual time=0.03..0.03
rows=0 loops=1)
-> Seq Scan on table3 (cost=0.00..0.00 rows=1
width=156) (actual time=0.01..0.01 rows=0
loops=1)
Total runtime: 5114.47 msec
(13 rows)
Thanks again! Gurus.
Regards,
CN
--
http://www.fastmail.fm - The professional email service
view thread (17+ messages) latest in thread
Message-ID: <20031001170232.042667855B@smtp.us2.messagingengine.com>
Permalink: ../20031001170232.042667855B@smtp.us2.messagingengine.com/
Also on: postgresql.org/message-id/20031001170232.042667855B@smtp.us2.messagingengine.com
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: cnliou9@fastmail.fm
Subject: Re: Creating Index
In-Reply-To: <20031001170232.042667855B@smtp.us2.messagingengine.com>
* 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