QUERY PLAN                                                                                    
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=240446.37..240448.21 rows=735 width=246)
   Sort Key: clntb.code, invh.invoiceno
   ->  HashAggregate  (cost=240280.92..240411.38 rows=735 width=246)
         ->  Hash Join  (cost=125826.97..240223.95 rows=735 width=246)
               Hash Cond: ("outer".sourcedetrecno = "inner".foreignrecno)
               ->  Hash Join  (cost=122708.52..236191.45 rows=15641 width=178)
                     Hash Cond: ("outer".salesinvhdrrecno = "inner".recno)
                     ->  Hash Join  (cost=122412.59..233951.02 rows=238411 width=160)
                           Hash Cond: ("outer".l1productleveldetrecno = "inner".recno)
                           ->  Hash Join  (cost=105128.26..197124.42 rows=238411 width=135)
                                 Hash Cond: ("outer".l3productleveldetrecno = "inner".recno)
                                 ->  Hash Join  (cost=87843.94..161693.82 rows=238411 width=110)
                                       Hash Cond: ("outer".l2productleveldetrecno = "inner".recno)
                                       ->  Hash Join  (cost=70559.61..121359.74 rows=238412 width=85)
                                             Hash Cond: ("outer".productrecno = "inner".recno)
                                             ->  Hash Join  (cost=45828.68..82229.51 rows=238411 width=77)
                                                   Hash Cond: ("outer".supplierproductrecno = "inner".recno)
                                                   ->  Hash Join  (cost=20465.75..42858.31 rows=238411 width=77)
                                                         Hash Cond: ("outer".poorpackagerecno = "inner".recno)
                                                         ->  Seq Scan on salesinvdet invd  (cost=0.00..8211.74 rows=240981 width=77)
                                                               Filter: (linetype = 'P'::bpchar)
                                                         ->  Hash  (cost=17598.00..17598.00 rows=415900 width=8)
                                                               ->  Seq Scan on sourcedetupgr srcu  (cost=0.00..17598.00 rows=415900 width=8)
                                                   ->  Hash  (cost=22601.94..22601.94 rows=400394 width=8)
                                                         ->  Seq Scan on supplierproduct suppp  (cost=0.00..22601.94 rows=400394 width=8)
                                             ->  Hash  (cost=21578.95..21578.95 rows=400395 width=16)
                                                   ->  Seq Scan on product prod  (cost=0.00..21578.95 rows=400395 width=16)
                                       ->  Hash  (cost=11957.06..11957.06 rows=516506 width=33)
                                             ->  Seq Scan on productleveldet l2  (cost=0.00..11957.06 rows=516506 width=33)
                                 ->  Hash  (cost=11957.06..11957.06 rows=516506 width=33)
                                       ->  Seq Scan on productleveldet l3  (cost=0.00..11957.06 rows=516506 width=33)
                           ->  Hash  (cost=11957.06..11957.06 rows=516506 width=33)
                                 ->  Seq Scan on productleveldet l1  (cost=0.00..11957.06 rows=516506 width=33)
                     ->  Hash  (cost=293.51..293.51 rows=967 width=26)
                           ->  Index Scan using salesinvhdr_1 on salesinvhdr invh  (cost=0.00..293.51 rows=967 width=26)
                                 Index Cond: ((servicecobranchrecno = 2) AND (invoicedate >= '2008-09-01'::date) AND (invoicedate <= '2008-09-30'::date))
               ->  Hash  (cost=3116.25..3116.25 rows=878 width=76)
                     ->  Hash Join  (cost=2580.88..3116.25 rows=878 width=76)
                           Hash Cond: ("outer".recno = "inner".customerrecno)
                           ->  Seq Scan on customer cust  (cost=0.00..427.06 rows=19906 width=25)
                           ->  Hash  (cost=2578.69..2578.69 rows=878 width=59)
                                 ->  Hash Join  (cost=2064.32..2578.69 rows=878 width=59)
                                       Hash Cond: ("outer".recno = "inner".sourcehdrrecno)
                                       ->  Seq Scan on sourcehdr srch  (cost=0.00..406.06 rows=19906 width=8)
                                       ->  Hash  (cost=2062.12..2062.12 rows=878 width=59)
                                             ->  Hash Join  (cost=924.82..2062.12 rows=878 width=59)
                                                   Hash Cond: ("outer".recno = "inner".foreignrecno)
                                                   ->  Seq Scan on sourcedet srcd  (cost=0.00..879.83 rows=16423 width=8)
                                                         Filter: (actionstatus <> 'V'::bpchar)
                                                   ->  Hash  (cost=921.45..921.45 rows=1348 width=51)
                                                         ->  Hash Join  (cost=2.95..921.45 rows=1348 width=51)
                                                               Hash Cond: ("outer".ownerforeignrecno = "inner".recno)
                                                               ->  Seq Scan on sourcedetextref srce  (cost=0.00..803.93 rows=20218 width=22)
                                                                     Filter: (((tablename)::text = 'sourcedet'::text) AND ((ownerforeigntablename)::text = 'clientbranch'::text))
                                                               ->  Hash  (cost=2.94..2.94 rows=3 width=37)
                                                                     ->  Hash Join  (cost=1.24..2.94 rows=3 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)
(61 rows)