X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 04A52D1B502 for ; Wed, 1 Oct 2003 17:04:26 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 73629-07 for ; Wed, 1 Oct 2003 14:03:36 -0300 (ADT) Received: from mail.messagingengine.com (out1.smtp.messagingengine.com [66.111.4.25]) by svr1.postgresql.org (Postfix) with ESMTP id 53C39D1B4F1 for ; Wed, 1 Oct 2003 14:03:35 -0300 (ADT) Received: from smtp.us2.messagingengine.com (localhost [127.0.0.1]) by localhost.localdomain (Postfix) with ESMTP id 72A84245E32 for ; Wed, 1 Oct 2003 13:02:32 -0400 (EDT) Received: from 10.202.2.133 ([10.202.2.133] helo=smtp.us2.messagingengine.com) by messagingengine.com with SMTP; Wed, 01 Oct 2003 13:02:32 -0400 Received: by smtp.us2.messagingengine.com (Postfix, from userid 99) id 042667855B; Wed, 1 Oct 2003 13:02:32 -0400 (EDT) Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="Big5" MIME-Version: 1.0 X-Mailer: MIME::Lite 1.2 (F2.71; T1.001; A1.51; B2.12; Q2.03) From: "CN" To: pgsql-sql@postgresql.org Date: Wed, 01 Oct 2003 09:02:31 -0800 X-Epoch: 1065027752 X-Sasl-enc: dqlRMTRsyRXfXhb4aKhqNg Subject: Re: Creating Index References: <20031001152542.8C9C76F692@smtp.us2.messagingengine.com> <1065024516.85344.134.camel@jester> In-Reply-To: <1065024516.85344.134.camel@jester> Message-Id: <20031001170232.042667855B@smtp.us2.messagingengine.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/16 X-Sequence-Number: 15416 > > -> 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