Limit (cost=419589.16..419625.68 rows=2 width=1204) (actual time=371508.778..371786.673 rows=101 loops=1) -> Result (cost=419589.16..419625.68 rows=2 width=1204) (actual time=371508.775..371786.606 rows=101 loops=1) -> Sort (cost=419589.16..419589.16 rows=2 width=1059) (actual time=371469.331..371469.366 rows=101 loops=1) Sort Key: locator2_.value Sort Method: quicksort Memory: 112kB -> Nested Loop Left Join (cost=8478.86..419589.15 rows=2 width=1059) (actual time=233905.747..371469.094 rows=170 loops=1) Join Filter: ((materialmg0_.m_refinventory_id)::text = (materialmg6_.m_refinventory_id)::text) Rows Removed by Join Filter: 131920 -> Nested Loop Left Join (cost=8478.86..419109.90 rows=2 width=1189) (actual time=233901.774..371448.946 rows=170 loops=1) Join Filter: ((materialmg0_.c_uom_id)::text = (uom5_.c_uom_id)::text) Rows Removed by Join Filter: 1870 -> Hash Left Join (cost=8478.86..419107.54 rows=2 width=941) (actual time=233901.750..371448.486 rows=170 loops=1) Hash Cond: ((materialmg0_.m_product_id)::text = (product1_.m_product_id)::text) Filter: ((upper((product1_.value)::text) ~~ '%5503-BVV%'::text) OR (upper((product1_.upc)::text) ~~ '%5503-BVV%'::text) OR (upper((product1_.name)::text ) ~~ '%5503-BVV%'::text) OR (upper((locator2_.value)::text) ~~ '%5503-BVV%'::text) OR (upper((attributes4_.description)::text) ~~ '%5503-BVV%'::text)) Rows Removed by Filter: 717310 -> Nested Loop Left Join (cost=8336.07..418952.40 rows=4663 width=923) (actual time=55.249..368481.543 rows=717480 loops=1) -> Nested Loop (cost=8335.51..393051.28 rows=4663 width=863) (actual time=55.228..361227.817 rows=717480 loops=1) -> Nested Loop Left Join (cost=0.00..2.31 rows=1 width=722) (actual time=0.016..0.099 rows=10 loops=1) Join Filter: ((locator2_.m_warehouse_id)::text = (warehouse3_.m_warehouse_id)::text) -> Seq Scan on m_locator locator2_ (cost=0.00..1.24 rows=1 width=486) (actual time=0.011..0.024 rows=10 loops=1) Filter: ((m_warehouse_id)::text = 'FCA81F56E9E643E096E86F5F379459FB'::text) Rows Removed by Filter: 11 -> Seq Scan on m_warehouse warehouse3_ (cost=0.00..1.06 rows=1 width=318) (actual time=0.002..0.002 rows=1 loops=10) Filter: ((m_warehouse_id)::text = 'FCA81F56E9E643E096E86F5F379459FB'::text) Rows Removed by Filter: 4 -> Bitmap Heap Scan on m_storage_detail materialmg0_ (cost=8335.51..392871.79 rows=17718 width=174) (actual time=6.131..36094.274 rows=71748 loops=10) Recheck Cond: ((m_locator_id)::text = (locator2_.m_locator_id)::text) Filter: ((qtyonhand > '0'::numeric) AND ((qtyonhand - (SubPlan 3)) > '0'::numeric)) Rows Removed by Filter: 47 Heap Blocks: exact=44618 -> Bitmap Index Scan on m_storage_detail_locator (cost=0.00..8331.09 rows=53155 width=0) (actual time=4.911..4.911 rows=76128 loops=10) Index Cond: ((m_locator_id)::text = (locator2_.m_locator_id)::text) SubPlan 3 -> Aggregate (cost=6.32..6.33 rows=1 width=32) (actual time=0.500..0.500 rows=1 loops=717948) -> Index Scan using obawo_task_status_ix on obawo_task obawo_task10_ (cost=0.55..6.32 rows=1 width=4) (actual time=0.499..0.499 rows=0 loops=717948) Index Cond: ((status)::text = 'AV'::text) Filter: ((m_storage_detail_id)::text = (materialmg0_.m_storage_detail_id)::text) Rows Removed by Filter: 1226 -> Index Scan using m_attributesetinstance_key on m_attributesetinstance attributes4_ (cost=0.55..5.55 rows=1 width=93) (actual time=0.009..0.009 rows=1 loops=717480) Index Cond: ((materialmg0_.m_attributesetinstance_id)::text = (m_attributesetinstance_id)::text) -> Hash (cost=121.24..121.24 rows=1724 width=157) (actual time=0.756..0.756 rows=1724 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 206kB -> Seq Scan on m_product product1_ (cost=0.00..121.24 rows=1724 width=157) (actual time=0.012..0.453 rows=1724 loops=1) -> Materialize (cost=0.00..1.48 rows=32 width=252) (actual time=0.000..0.001 rows=12 loops=170) -> Seq Scan on c_uom uom5_ (cost=0.00..1.32 rows=32 width=252) (actual time=0.012..0.014 rows=12 loops=1) -> Materialize (cost=0.00..311.50 rows=6100 width=42) (actual time=0.004..0.052 rows=777 loops=170) -> Seq Scan on m_refinventory materialmg6_ (cost=0.00..281.00 rows=6100 width=42) (actual time=0.643..3.779 rows=777 loops=1) SubPlan 1 -> Hash Join (cost=8.17..9.59 rows=1 width=82) (actual time=0.006..0.006 rows=0 loops=101) Hash Cond: ((uom8_.c_uom_id)::text = (productaum7_.c_uom_id)::text) -> Seq Scan on c_uom uom8_ (cost=0.00..1.32 rows=32 width=82) (actual time=0.007..0.007 rows=1 loops=1) -> Hash (cost=8.16..8.16 rows=1 width=82) (actual time=0.003..0.003 rows=0 loops=101) Buckets: 1024 Batches: 1 Memory Usage: 8kB -> Index Scan using m_product_aum_unq on m_product_aum productaum7_ (cost=0.14..8.16 rows=1 width=82) (actual time=0.002..0.002 rows=0 loops=101) Index Cond: ((m_product_id)::text = (product1_.m_product_id)::text) Filter: ((logistics)::text = 'P'::text) SubPlan 2 -> Index Scan using m_product_aum_product_id on m_product_aum productaum9_ (cost=0.14..8.16 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=101) Index Cond: ((m_product_id)::text = (product1_.m_product_id)::text) Filter: ((logistics)::text = 'P'::text) Planning time: 3.534 ms Execution time: 371787.353 ms (62 rows)