> > -> 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) (actualtime=5089.34..5089.34 rows=1 loops=1) -> Subquery Scan view1
(cost=187.86..1788.14rows=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=28482width=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.29rows=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)
(actualtime=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
