QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Sort (cost=216020.48..216022.23 rows=700 width=246) Sort Key: clntb.code, invh.invoiceno -> HashAggregate (cost=215856.15..215987.40 rows=700 width=246) -> Hash Join (cost=102579.76..215801.90 rows=700 width=246) Hash Cond: ("outer".sourcedetrecno = "inner".recno) -> Hash Join (cost=99564.97..212692.14 rows=16194 width=178) Hash Cond: ("outer".salesinvhdrrecno = "inner".recno) -> Hash Join (cost=99381.70..211151.67 rows=239051 width=160) Hash Cond: ("outer".l1productleveldetrecno = "inner".recno) -> Hash Join (cost=82092.34..174873.66 rows=239051 width=135) Hash Cond: ("outer".l2productleveldetrecno = "inner".recno) -> Hash Join (cost=64802.97..139995.65 rows=239051 width=110) Hash Cond: ("outer".l3productleveldetrecno = "inner".recno) -> Hash Join (cost=47513.61..100179.51 rows=239051 width=85) Hash Cond: ("outer".productrecno = "inner".recno) -> Hash Join (cost=34273.68..71910.67 rows=239051 width=77) Hash Cond: ("outer".supplierproductrecno = "inner".recno) -> Hash Join (cost=20284.75..43283.84 rows=239051 width=77) Hash Cond: ("outer".poorpackagerecno = "inner".recno) -> Seq Scan on salesinvdet invd (cost=0.00..8200.61 rows=241141 width=77) Filter: (linetype = 'P'::bpchar) -> Hash (cost=17417.00..17417.00 rows=415900 width=8) -> Seq Scan on sourcedetupgr srcu (cost=0.00..17417.00 rows=415900 width=8) -> Hash (cost=11227.94..11227.94 rows=400394 width=8) -> Seq Scan on supplierproduct suppp (cost=0.00..11227.94 rows=400394 width=8) -> Hash (cost=10087.95..10087.95 rows=400395 width=16) -> Seq Scan on product prod (cost=0.00..10087.95 rows=400395 width=16) -> Hash (cost=11959.49..11959.49 rows=516749 width=33) -> Seq Scan on productleveldet l3 (cost=0.00..11959.49 rows=516749 width=33) -> Hash (cost=11959.49..11959.49 rows=516749 width=33) -> Seq Scan on productleveldet l2 (cost=0.00..11959.49 rows=516749 width=33) -> Hash (cost=11959.49..11959.49 rows=516749 width=33) -> Seq Scan on productleveldet l1 (cost=0.00..11959.49 rows=516749 width=33) -> Hash (cost=180.79..180.79 rows=992 width=26) -> Bitmap Heap Scan on salesinvhdr invh (cost=12.43..180.79 rows=992 width=26) Recheck Cond: ((servicecobranchrecno = 2) AND (invoicedate >= '2008-09-01'::date) AND (invoicedate <= '2008-09-30'::date)) -> Bitmap Index Scan on salesinvhdr_1 (cost=0.00..12.43 rows=992 width=0) Index Cond: ((servicecobranchrecno = 2) AND (invoicedate >= '2008-09-01'::date) AND (invoicedate <= '2008-09-30'::date)) -> Hash (cost=3012.64..3012.64 rows=860 width=76) -> Hash Join (cost=2477.45..3012.64 rows=860 width=76) Hash Cond: ("outer".recno = "inner".customerrecno) -> Seq Scan on customer cust (cost=0.00..427.06 rows=19906 width=25) -> Hash (cost=2475.30..2475.30 rows=860 width=59) -> Hash Join (cost=1962.11..2475.30 rows=860 width=59) Hash Cond: ("outer".recno = "inner".sourcehdrrecno) -> Seq Scan on sourcehdr srch (cost=0.00..405.06 rows=19906 width=8) -> Hash (cost=1959.96..1959.96 rows=860 width=59) -> Hash Join (cost=914.50..1959.96 rows=860 width=59) Hash Cond: ("outer".recno = "inner".foreignrecno) -> Seq Scan on sourcedet srcd (cost=0.00..872.83 rows=16403 width=8) Filter: (actionstatus <> 'V'::bpchar) -> Hash (cost=911.89..911.89 rows=1044 width=51) -> Hash Join (cost=2.94..911.89 rows=1044 width=51) Hash Cond: ("outer".ownerforeignrecno = "inner".recno) -> Seq Scan on sourcedetextref srce (cost=0.00..800.93 rows=19840 width=22) Filter: (((tablename)::text = 'sourcedet'::text) AND ((ownerforeigntablename)::text = 'clientbranch'::text)) -> Hash (cost=2.94..2.94 rows=2 width=37) -> Hash Join (cost=1.24..2.94 rows=2 width=37) Hash Cond: ("outer".clientrecno = "inner".recno) -> Seq Scan on clientbranch clntb (cost=0.00..1.45 rows=45 width=41) -> Hash (cost=1.24..1.24 rows=1 width=4) -> Seq Scan on client clnt (cost=0.00..1.24 rows=1 width=4) Filter: (code ~~ 'RBS%'::text) (63 rows)