Aggregate  (cost=187.80..187.84 rows=1 width=699) (actual time=142704.64..148066.77 rows=125769 loops=1)
   ->  Group  (cost=187.80..187.82 rows=1 width=699) (actual time=142704.48..144239.11 rows=125769 loops=1)
         ->  Sort  (cost=187.80..187.81 rows=1 width=699) (actual time=142704.45..142947.14 rows=125769 loops=1)
               Sort Key: m.group_code, m.sku, m.brn_code, m.stktype_code, ss.supplier_price_curr_cost, sk.sku_price_curr_cost
               ->  Nested Loop  (cost=140.07..187.79 rows=1 width=699) (actual time=49796.26..135679.87 rows=125769 loops=1)
                     Join Filter: (("outer".sku = "inner".sku) AND ("outer".group_code = "inner".group_code))
                     ->  Nested Loop  (cost=140.07..181.76 rows=1 width=635) (actual time=49742.50..118086.42 rows=125769 loops=1)
                           Join Filter: (("inner".group_cde = "outer".group_cde) AND ("inner".price_tmpl_hdr_cde = "outer".price_tmpl_hdr_cde) AND ("inner".price_tmpl_hdr_reg = "outer".price_tmpl_hdr_reg) AND ("inner".supplier_cde = "outer".supplier_code))
                           ->  Nested Loop  (cost=140.07..176.91 rows=1 width=485) (actual time=49741.95..90991.39 rows=125769 loops=1)
                                 Join Filter: (("inner".price_tmpl_hdr_cde = "outer".price_tmpl_hdr_cde) AND ("inner".price_tmpl_hdr_reg = "outer".price_tmpl_hdr_reg) AND ("inner".group_cde = "outer".group_cde))
                                 ->  Hash Join  (cost=140.07..172.07 rows=1 width=367) (actual time=49741.16..52345.71 rows=162115 loops=1)
                                       Hash Cond: ("outer".branch_cde = "inner".brn_code)
                                       Join Filter: ("inner".group_code = "outer".group_cde)
                                       ->  Seq Scan on price_tmpl_det p  (cost=0.00..20.00 rows=1000 width=100) (actual time=0.09..9.50 rows=202 loops=1)
                                       ->  Hash  (cost=140.00..140.00 rows=27 width=267) (actual time=49740.97..49740.97 rows=0 loops=1)
                                             ->  Nested Loop  (cost=0.00..140.00 rows=27 width=267) (actual time=432.55..49360.23 rows=162115 loops=1)
                                                   ->  Nested Loop  (cost=0.00..30.79 rows=1 width=115) (actual time=154.19..184.03 rows=198 loops=1)
                                                         ->  Seq Scan on forex f  (cost=0.00..25.00 rows=1 width=51) (actual time=50.86..51.12 rows=4 loops=1)
                                                               Filter: ((to_ctry = 'ZAF'::text) AND (fpp_code = '200307'::text))
                                                         ->  Index Scan using master_branch_descr_idx4 on master_branch_descr b  (cost=0.00..5.78 rows=1 width=64) (actual time=25.90..32.81 rows=50 loops=4)
                                                               Index Cond: (b.country_code = "outer".from_ctry)
                                                   ->  Index Scan using master_fpp_values_uidx1 on master_fpp_values m  (cost=0.00..108.88 rows=27 width=152) (actual time=3.41..243.55 rows=819 loops=198)
                                                         Index Cond: ((m.fpp_code = '200307'::text) AND (m.brn_code = "outer".brn_code))
                                 ->  Index Scan using idx_sku_price on sku_price sk  (cost=0.00..4.83 rows=1 width=118) (actual time=0.09..0.21 rows=4 loops=162115)
                                       Index Cond: ((sk.group_cde = "outer".group_code) AND (sk.sku_mst_cde = "outer".sku))
                           ->  Index Scan using idx_supplier_price on supplier_price ss  (cost=0.00..4.83 rows=1 width=150) (actual time=0.11..0.16 rows=5 loops=125769)
                                 Index Cond: (("outer".group_cde = ss.group_cde) AND ("outer".sku_mst_cde = ss.sku_mst_cde))
                     ->  Index Scan using master_sku_descr_idx1 on master_sku_descr s  (cost=0.00..6.02 rows=1 width=64) (actual time=0.12..0.12 rows=1 loops=125769)
                           Index Cond: (("outer".group_cde = s.group_code) AND ("outer".sku_mst_cde = s.sku) AND (s.control_code = '0'::text))
 Total runtime: 148710.78 msec
(30 rows)