Re: Creating Index

> > -> 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