]
cc
pgsql-performance@postgresql.org
Subject
Re: [PERFORM] Slow query. Any way
Patrick Hatcher [EMAIL PROTECTED] writes:
- Seq Scan on cdm_ddw_tran_item a1
(cost=0.00..1547562.88 rows=8754773 width=23) (actual
time=14.219..535704.691 rows=10838135 loops=1)
Filter: appl_id)::text = 'MCOM'::text)
OR
Patrick Hatcher [EMAIL PROTECTED] writes:
The following SQL takes 4+ mins to run. I have indexes on all join fields
and I've tried rearranging the table orders but haven't had any luck.
Please show EXPLAIN ANALYZE output, not just EXPLAIN. It's impossible
to tell whether the planner is making