--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->
 Sort  (cost=16572.91..16574.59 rows=671 width=22666) (actual time=4518.996..4520.467 rows=2005 loops=1)
   Sort Key: order2_.dateordered, orderline0_.c_orderline_id
   Sort Method: external sort  Disk: 4760kB
   ->  Hash Join  (cost=31.30..10031.41 rows=671 width=22666) (actual time=1475.668..4498.452 rows=2005 loops=1)
         Hash Cond: ((orderline0_.c_uom_id)::text = (uom9_.c_uom_id)::text)
         ->  Nested Loop  (cost=19.95..9669.26 rows=671 width=21305) (actual time=1457.261..4005.555 rows=2005 loops=1)
               ->  Hash Join  (cost=19.66..8953.09 rows=671 width=16039) (actual time=1457.225..3994.204 rows=2005 loops=1)
                     Hash Cond: ((orderline0_.m_warehouse_id)::text = (warehouse7_.m_warehouse_id)::text)
                     ->  Hash Join  (cost=8.76..8940.24 rows=671 width=14127) (actual time=1441.490..3975.222 rows=2005 loops=1)
                           Hash Cond: ((orderline0_.c_bpartner_id)::text = (businesspa3_.c_bpartner_id)::text)
                           ->  Nested Loop  (cost=0.69..8930.34 rows=671 width=10790) (actual time=1406.356..3935.806 rows=2005 loops=1)
                                 Join Filter: ((orderline0_.ad_org_id)::text = (organizati1_.ad_org_id)::text)
                                 Rows Removed by Join Filter: 34083
                                 ->  Nested Loop  (cost=0.69..8898.12 rows=671 width=4678) (actual time=1405.850..3926.607 rows=2005 loops=1)
                                       ->  Nested Loop  (cost=0.41..5560.76 rows=1093 width=253) (actual time=1018.690..3862.653 rows=5025 loops=1)
                                             ->  Seq Scan on c_orderline orderline0_  (cost=0.00..2330.25 rows=3279 width=220) (actual time=41.388..228.223 rows=7065 loops=1)
                                                   Filter: (((ad_client_id)::text = ANY ('{0,A64C68776B544B0DB59C16456C43E608}'::text[])) AND ((ad_org_id)::text = ANY ('{0,BF67B59606F643E08>
                                                   Rows Removed by Filter: 8822
                                             ->  Index Only Scan using c_orderline_key on c_orderline orderline_6_  (cost=0.41..0.99 rows=1 width=33) (actual time=0.513..0.513 rows=1 loops=>
                                                   Index Cond: (c_orderline_id = (orderline0_.c_orderline_id)::text)
                                                   Filter: ((SubPlan 3) > '0'::numeric)
                                                   Rows Removed by Filter: 0
                                                   Heap Fetches: 0
                                                   SubPlan 3
                                                     ->  Result  (cost=0.00..0.26 rows=1 width=32) (actual time=0.405..0.405 rows=1 loops=7065)
                                       ->  Index Scan using c_order_key on c_order order2_  (cost=0.28..3.05 rows=1 width=4425) (actual time=0.012..0.012 rows=0 loops=5025)
                                             Index Cond: ((c_order_id)::text = (orderline0_.c_order_id)::text)
                                             Filter: ((issotrx = 'Y'::bpchar) AND ((docstatus)::text = 'CO'::text))
                                             Rows Removed by Filter: 1
                                 ->  Materialize  (cost=0.00..3.04 rows=3 width=6112) (actual time=0.000..0.001 rows=18 loops=2005)
                                       ->  Seq Scan on ad_org organizati1_  (cost=0.00..3.03 rows=3 width=6112) (actual time=0.468..0.480 rows=18 loops=1)
                           ->  Hash  (cost=6.92..6.92 rows=92 width=3337) (actual time=35.116..35.116 rows=92 loops=1)
                                 Buckets: 1024  Batches: 1  Memory Usage: 50kB
                                 ->  Seq Scan on c_bpartner businesspa3_  (cost=0.00..6.92 rows=92 width=3337) (actual time=20.383..35.060 rows=92 loops=1)
                     ->  Hash  (cost=10.40..10.40 rows=40 width=1912) (actual time=15.712..15.713 rows=25 loops=1)
                           Buckets: 1024  Batches: 1  Memory Usage: 15kB
                           ->  Seq Scan on m_warehouse warehouse7_  (cost=0.00..10.40 rows=40 width=1912) (actual time=15.673..15.695 rows=25 loops=1)
               ->  Index Scan using m_product_key on m_product product8_  (cost=0.28..1.07 rows=1 width=5266) (actual time=0.003..0.003 rows=1 loops=2005)
                     Index Cond: ((m_product_id)::text = (orderline0_.m_product_id)::text)
         ->  Hash  (cost=10.60..10.60 rows=60 width=1310) (actual time=17.778..17.778 rows=36 loops=1)
               Buckets: 1024  Batches: 1  Memory Usage: 13kB
               ->  Seq Scan on c_uom uom9_  (cost=0.00..10.60 rows=60 width=1310) (actual time=17.728..17.734 rows=36 loops=1)
         SubPlan 1
           ->  Result  (cost=0.00..0.26 rows=1 width=32) (actual time=0.117..0.117 rows=1 loops=2005)
         SubPlan 2
           ->  Result  (cost=0.00..0.26 rows=1 width=32) (actual time=0.116..0.116 rows=1 loops=2005)
 Planning time: 1800.816 ms
 Execution time: 4522.780 ms
(48 rows)