explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uCdm

Settings
# exclusive inclusive rows x rows loops node
1. 1.247 84.160 ↑ 36.6 25 1

Unique (cost=2,689.44..2,879.31 rows=915 width=1,678) (actual time=82.862..84.160 rows=25 loops=1)

2. 12.878 82.913 ↓ 1.1 1,029 1

Sort (cost=2,689.44..2,691.73 rows=915 width=1,678) (actual time=82.861..82.913 rows=1,029 loops=1)

  • Sort Key: (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.priority ELSE obawo_getchildtaskmaxpriority(obawo_task0_.obawo_receptionlist_id, obawo_task0_.obawo_pickinglist_id, '100'::character varying) END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.obawo_travel_sequence ELSE '000000000'::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN locator6_.value ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN locator5_.value ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.created ELSE obawo_rece1_.created END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.obawo_task_id ELSE COALESCE(obawo_task0_.obawo_receptionlist_id, obawo_task0_.obawo_pickinglist_id) END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.m_product_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN product26_.name ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN product26_.characteristic_desc ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN btrim((product26_.upc)::text) ELSE NULL::text END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN uom18_.c_uom_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_getauomgtin(uom18_.c_uom_id, product26_.m_product_id) ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_getauomconversionrate(uom18_.c_uom_id, product26_.m_product_id) ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN uom28_.c_uom_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_ware20_.obawo_warehouse_algorithm_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_ware21_.obawo_warehouse_algorithm_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN attributes30_.m_attributeset_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN attributes11_.m_attributesetinstance_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN attributes11_.description ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN m_getjsondescription(attributes11_.m_attributesetinstance_id, 'Y'::character varying, '192'::character varying) ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.expected_qty ELSE NULL::numeric END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.expected_locator_to_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN locator5_.barcode ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN locator6_.m_locator_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN locator6_.barcode ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.m_storage_detail_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.expected_m_refinventory_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN materialmg16_.value ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.confirmed_m_refinventory_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN materialmg17_.value ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN materialmg10_.m_refinventory_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN materialmg10_.value ELSE NULL::character varying END), obawo_inte13_.isexternalrouting, (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_inte13_.externalwarehouse_scope ELSE NULL::character varying END), obawo_inte13_.isremovereference, (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_inte23_.obawo_internal_routing_area_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_inte25_.obawo_internal_routing_area_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_inte13_.obawo_internal_routing_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.obawo_inv_tran_type_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.swap_storage_detail_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.swap_qty ELSE NULL::numeric END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN locator8_.m_locator_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN locator8_.value ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN attributes12_.m_attributesetinstance_id ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN attributes12_.description ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN m_getjsondescription(attributes12_.m_attributesetinstance_id, 'Y'::character varying, '192'::character varying) ELSE NULL::character varying END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN false ELSE true END), (CASE WHEN (obawo_task0_.behaveasgroupwithri = 'N'::bpchar) THEN false ELSE true END), obawo_task14_.obawo_task_type_id, obawo_task14_.color, obawo_task14_.name, obawo_task14_.value, obawo_task14_.obawo_base_task_type_id, obawo_base15_.value, obawo_base15_.name, obawo_batc2_.obawo_batchoftasks_id, obawo_batc2_.documentno, obawo_batc2_.created, obawo_rece1_.obawo_receptionlist_id, obawo_rece1_.documentno, obawo_rece1_.created, obawo_rece1_.issotrx, obawo_pick3_.obawo_pickinglist_id, obawo_pick3_.documentno, obawo_pick3_.created, materialmg4_.m_refinventory_id, materialmg4_.value, (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN product26_.isquantityvariable ELSE NULL::bpchar END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.min_tolerance_qty ELSE NULL::numeric END), (CASE WHEN ((obawo_task0_.behaveasgroup = 'N'::bpchar) AND (obawo_task0_.behaveasgroupwithri = 'N'::bpchar)) THEN obawo_task0_.max_tolerance_qty ELSE NULL::numeric END), (COALESCE(obawo_task0_.document_info, ' '::character varying))
  • Sort Method: quicksort Memory: 593kB
3. 48.197 70.035 ↓ 1.1 1,029 1

Hash Left Join (cost=701.80..2,644.44 rows=915 width=1,678) (actual time=7.371..70.035 rows=1,029 loops=1)

  • Hash Cond: ((product29_.m_attributeset_id)::text = (attributes30_.m_attributeset_id)::text)
4. 0.849 21.822 ↓ 1.1 1,029 1

Hash Left Join (cost=700.21..1,263.41 rows=915 width=1,680) (actual time=6.391..21.822 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.m_product_id)::text = (product29_.m_product_id)::text)
5. 0.710 19.721 ↓ 1.1 1,029 1

Nested Loop Anti Join (cost=512.84..1,063.45 rows=915 width=1,647) (actual time=5.132..19.721 rows=1,029 loops=1)

  • Join Filter: ((obawo_erro31_.obawo_task_id)::text = (obawo_task0_.obawo_task_id)::text)
6. 0.624 19.011 ↓ 1.1 1,029 1

Hash Left Join (cost=512.69..1,030.19 rows=916 width=1,647) (actual time=5.127..19.011 rows=1,029 loops=1)

  • Hash Cond: ((product27_.c_uom_id)::text = (uom28_.c_uom_id)::text)
7. 0.897 18.368 ↓ 1.1 1,029 1

Hash Left Join (cost=510.88..1,015.78 rows=916 width=1,626) (actual time=5.101..18.368 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.m_product_id)::text = (product27_.m_product_id)::text)
8. 0.845 16.474 ↓ 1.1 1,029 1

Hash Left Join (cost=323.50..815.81 rows=916 width=1,622) (actual time=4.093..16.474 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.m_product_id)::text = (product26_.m_product_id)::text)
9. 0.699 13.850 ↓ 1.1 1,029 1

Hash Left Join (cost=136.12..615.84 rows=916 width=1,463) (actual time=2.306..13.850 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_internal_routing_id)::text = (obawo_inte22_.obawo_internal_routing_id)::text)
10. 0.635 13.074 ↓ 1.1 1,029 1

Hash Left Join (cost=129.43..596.54 rows=916 width=1,463) (actual time=2.224..13.074 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_internal_routing_id)::text = (obawo_inte24_.obawo_internal_routing_id)::text)
11. 0.720 12.361 ↓ 1.1 1,029 1

Hash Left Join (cost=122.72..577.24 rows=916 width=1,430) (actual time=2.141..12.361 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_pa_warehousealgorithm_id)::text = (obawo_ware21_.obawo_warehouse_algorithm_id)::text)
12. 0.435 11.629 ↓ 1.1 1,029 1

Hash Left Join (cost=120.14..562.94 rows=916 width=1,430) (actual time=2.124..11.629 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_pk_warehousealgorithm_id)::text = (obawo_ware20_.obawo_warehouse_algorithm_id)::text)
13. 0.427 11.179 ↓ 1.1 1,029 1

Hash Left Join (cost=117.55..556.70 rows=916 width=1,430) (actual time=2.104..11.179 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.c_aum)::text = (uom18_.c_uom_id)::text)
14. 0.425 10.735 ↓ 1.1 1,029 1

Hash Left Join (cost=115.74..551.28 rows=916 width=1,438) (actual time=2.084..10.735 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.confirmed_m_refinventory_id)::text = (materialmg17_.m_refinventory_id)::text)
15. 0.413 10.303 ↓ 1.1 1,029 1

Hash Left Join (cost=114.52..546.49 rows=916 width=1,428) (actual time=2.073..10.303 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.expected_m_refinventory_id)::text = (materialmg16_.m_refinventory_id)::text)
16. 0.652 9.882 ↓ 1.1 1,029 1

Hash Join (cost=113.29..541.67 rows=916 width=1,418) (actual time=2.061..9.882 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task14_.obawo_base_task_type_id)::text = (obawo_base15_.obawo_base_task_type_id)::text)
17. 0.665 9.194 ↓ 1.1 1,029 1

Hash Join (cost=112.20..527.98 rows=916 width=1,392) (actual time=2.005..9.194 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_task_type_id)::text = (obawo_task14_.obawo_task_type_id)::text)
18. 0.666 8.512 ↓ 1.1 1,029 1

Hash Left Join (cost=110.95..514.14 rows=916 width=1,327) (actual time=1.969..8.512 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_internal_routing_id)::text = (obawo_inte13_.obawo_internal_routing_id)::text)
19. 0.434 7.791 ↓ 1.1 1,029 1

Hash Left Join (cost=106.47..497.06 rows=916 width=1,286) (actual time=1.909..7.791 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.confirmed_attribute_id)::text = (attributes12_.m_attributesetinstance_id)::text)
20. 0.518 7.220 ↓ 1.1 1,029 1

Hash Left Join (cost=93.07..479.32 rows=916 width=1,263) (actual time=1.766..7.220 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.expected_attribute_id)::text = (attributes11_.m_attributesetinstance_id)::text)
21. 0.360 6.488 ↓ 1.1 1,029 1

Hash Left Join (cost=79.67..457.50 rows=916 width=1,251) (actual time=1.533..6.488 rows=1,029 loops=1)

  • Hash Cond: ((materialmg9_.m_refinventory_id)::text = (materialmg10_.m_refinventory_id)::text)
22. 0.453 6.106 ↓ 1.1 1,029 1

Hash Left Join (cost=78.44..452.62 rows=916 width=1,241) (actual time=1.485..6.106 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.m_storage_detail_id)::text = (materialmg9_.m_storage_detail_id)::text)
23. 0.408 4.928 ↓ 1.1 1,029 1

Hash Left Join (cost=32.89..402.83 rows=916 width=1,208) (actual time=0.735..4.928 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.confirmed_locator_from_id)::text = (locator8_.m_locator_id)::text)
24. 0.359 4.454 ↓ 1.1 1,029 1

Hash Left Join (cost=26.48..392.11 rows=916 width=1,197) (actual time=0.650..4.454 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.expected_locator_from_id)::text = (locator6_.m_locator_id)::text)
25. 0.583 4.003 ↓ 1.1 1,029 1

Hash Left Join (cost=20.08..381.23 rows=916 width=1,108) (actual time=0.542..4.003 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.expected_locator_to_id)::text = (locator5_.m_locator_id)::text)
26. 0.656 3.328 ↓ 1.1 1,029 1

Hash Left Join (cost=13.67..362.73 rows=916 width=1,019) (actual time=0.419..3.328 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_batchoftasks_id)::text = (obawo_batc2_.obawo_batchoftasks_id)::text)
27. 0.559 2.521 ↓ 1.1 1,029 1

Hash Left Join (cost=5.41..341.87 rows=916 width=1,003) (actual time=0.247..2.521 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_receptionlist_id)::text = (obawo_rece1_.obawo_receptionlist_id)::text)
28. 0.477 1.916 ↓ 1.1 1,029 1

Hash Left Join (cost=2.46..327.16 rows=916 width=946) (actual time=0.187..1.916 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_pickinglist_id)::text = (obawo_pick3_.obawo_pickinglist_id)::text)
29. 1.375 1.375 ↓ 1.1 1,029 1

Seq Scan on obawo_task obawo_task0_ (cost=0.00..321.16 rows=916 width=880) (actual time=0.096..1.375 rows=1,029 loops=1)

  • Filter: (((ad_user_id)::text = '100'::text) AND ((m_warehouse_id)::text = 'F66CF439D1EC4ACDBD15A78A6195BCC1'::text) AND ((status)::text = 'AV'::text))
  • Rows Removed by Filter: 123
30. 0.007 0.064 ↑ 1.0 9 1

Hash (cost=2.35..2.35 rows=9 width=99) (actual time=0.064..0.064 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
31. 0.028 0.057 ↑ 1.0 9 1

Hash Right Join (cost=1.20..2.35 rows=9 width=99) (actual time=0.047..0.057 rows=9 loops=1)

  • Hash Cond: ((materialmg4_.m_refinventory_id)::text = (obawo_pick3_.m_refinventory_id)::text)
32. 0.007 0.007 ↑ 1.0 10 1

Seq Scan on m_refinventory materialmg4_ (cost=0.00..1.10 rows=10 width=43) (actual time=0.006..0.007 rows=10 loops=1)

33. 0.007 0.022 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=138) (actual time=0.022..0.022 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
34. 0.015 0.015 ↑ 1.0 9 1

Seq Scan on obawo_pickinglist obawo_pick3_ (cost=0.00..1.09 rows=9 width=138) (actual time=0.009..0.015 rows=9 loops=1)

35. 0.017 0.046 ↑ 1.0 42 1

Hash (cost=2.42..2.42 rows=42 width=57) (actual time=0.046..0.046 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
36. 0.029 0.029 ↑ 1.0 42 1

Seq Scan on obawo_receptionlist obawo_rece1_ (cost=0.00..2.42 rows=42 width=57) (actual time=0.006..0.029 rows=42 loops=1)

37. 0.059 0.151 ↑ 1.0 145 1

Hash (cost=6.45..6.45 rows=145 width=49) (actual time=0.151..0.151 rows=145 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
38. 0.092 0.092 ↑ 1.0 145 1

Seq Scan on obawo_batchoftasks obawo_batc2_ (cost=0.00..6.45 rows=145 width=49) (actual time=0.008..0.092 rows=145 loops=1)

39. 0.033 0.092 ↑ 1.0 107 1

Hash (cost=5.07..5.07 rows=107 width=122) (actual time=0.092..0.092 rows=107 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
40. 0.059 0.059 ↑ 1.0 107 1

Seq Scan on m_locator locator5_ (cost=0.00..5.07 rows=107 width=122) (actual time=0.002..0.059 rows=107 loops=1)

41. 0.042 0.092 ↑ 1.0 107 1

Hash (cost=5.07..5.07 rows=107 width=122) (actual time=0.092..0.092 rows=107 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.050 0.050 ↑ 1.0 107 1

Seq Scan on m_locator locator6_ (cost=0.00..5.07 rows=107 width=122) (actual time=0.003..0.050 rows=107 loops=1)

43. 0.039 0.066 ↑ 1.0 107 1

Hash (cost=5.07..5.07 rows=107 width=44) (actual time=0.066..0.066 rows=107 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
44. 0.027 0.027 ↑ 1.0 107 1

Seq Scan on m_locator locator8_ (cost=0.00..5.07 rows=107 width=44) (actual time=0.003..0.027 rows=107 loops=1)

45. 0.246 0.725 ↑ 1.0 780 1

Hash (cost=35.80..35.80 rows=780 width=66) (actual time=0.725..0.725 rows=780 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
46. 0.479 0.479 ↑ 1.0 780 1

Seq Scan on m_storage_detail materialmg9_ (cost=0.00..35.80 rows=780 width=66) (actual time=0.006..0.479 rows=780 loops=1)

47. 0.009 0.022 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=43) (actual time=0.022..0.022 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
48. 0.013 0.013 ↑ 1.0 10 1

Seq Scan on m_refinventory materialmg10_ (cost=0.00..1.10 rows=10 width=43) (actual time=0.009..0.013 rows=10 loops=1)

49. 0.087 0.214 ↑ 1.0 240 1

Hash (cost=10.40..10.40 rows=240 width=41) (actual time=0.214..0.214 rows=240 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
50. 0.127 0.127 ↑ 1.0 240 1

Seq Scan on m_attributesetinstance attributes11_ (cost=0.00..10.40 rows=240 width=41) (actual time=0.006..0.127 rows=240 loops=1)

51. 0.068 0.137 ↑ 1.0 240 1

Hash (cost=10.40..10.40 rows=240 width=41) (actual time=0.137..0.137 rows=240 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
52. 0.069 0.069 ↑ 1.0 240 1

Seq Scan on m_attributesetinstance attributes12_ (cost=0.00..10.40 rows=240 width=41) (actual time=0.002..0.069 rows=240 loops=1)

53. 0.019 0.055 ↑ 1.0 66 1

Hash (cost=3.66..3.66 rows=66 width=41) (actual time=0.055..0.055 rows=66 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
54. 0.036 0.036 ↑ 1.0 66 1

Seq Scan on obawo_internal_routing obawo_inte13_ (cost=0.00..3.66 rows=66 width=41) (actual time=0.002..0.036 rows=66 loops=1)

55. 0.006 0.017 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=98) (actual time=0.017..0.017 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
56. 0.011 0.011 ↑ 1.0 11 1

Seq Scan on obawo_task_type obawo_task14_ (cost=0.00..1.11 rows=11 width=98) (actual time=0.007..0.011 rows=11 loops=1)

57. 0.008 0.036 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=59) (actual time=0.036..0.036 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
58. 0.028 0.028 ↑ 1.0 4 1

Seq Scan on obawo_base_task_type obawo_base15_ (cost=0.00..1.04 rows=4 width=59) (actual time=0.023..0.028 rows=4 loops=1)

59. 0.006 0.008 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=43) (actual time=0.008..0.008 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
60. 0.002 0.002 ↑ 1.0 10 1

Seq Scan on m_refinventory materialmg16_ (cost=0.00..1.10 rows=10 width=43) (actual time=0.001..0.002 rows=10 loops=1)

61. 0.002 0.007 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=43) (actual time=0.007..0.007 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
62. 0.005 0.005 ↑ 1.0 10 1

Seq Scan on m_refinventory materialmg17_ (cost=0.00..1.10 rows=10 width=43) (actual time=0.001..0.005 rows=10 loops=1)

63. 0.010 0.017 ↑ 1.0 36 1

Hash (cost=1.36..1.36 rows=36 width=25) (actual time=0.017..0.017 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
64. 0.007 0.007 ↑ 1.0 36 1

Seq Scan on c_uom uom18_ (cost=0.00..1.36 rows=36 width=25) (actual time=0.002..0.007 rows=36 loops=1)

65. 0.011 0.015 ↑ 1.0 26 1

Hash (cost=2.26..2.26 rows=26 width=33) (actual time=0.015..0.015 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
66. 0.004 0.004 ↑ 1.0 26 1

Seq Scan on obawo_warehouse_algorithm obawo_ware20_ (cost=0.00..2.26 rows=26 width=33) (actual time=0.001..0.004 rows=26 loops=1)

67. 0.007 0.012 ↑ 1.0 26 1

Hash (cost=2.26..2.26 rows=26 width=33) (actual time=0.012..0.012 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
68. 0.005 0.005 ↑ 1.0 26 1

Seq Scan on obawo_warehouse_algorithm obawo_ware21_ (cost=0.00..2.26 rows=26 width=33) (actual time=0.001..0.005 rows=26 loops=1)

69. 0.012 0.078 ↑ 1.0 66 1

Hash (cost=5.88..5.88 rows=66 width=66) (actual time=0.078..0.078 rows=66 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 7kB
70. 0.048 0.066 ↑ 1.0 66 1

Hash Left Join (cost=1.41..5.88 rows=66 width=66) (actual time=0.015..0.066 rows=66 loops=1)

  • Hash Cond: ((obawo_inte24_.internal_routing_area_to_id)::text = (obawo_inte25_.obawo_internal_routing_area_id)::text)
71. 0.008 0.008 ↑ 1.0 66 1

Seq Scan on obawo_internal_routing obawo_inte24_ (cost=0.00..3.66 rows=66 width=66) (actual time=0.001..0.008 rows=66 loops=1)

72. 0.005 0.010 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=33) (actual time=0.010..0.010 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
73. 0.005 0.005 ↑ 1.0 18 1

Seq Scan on obawo_internal_routing_area obawo_inte25_ (cost=0.00..1.18 rows=18 width=33) (actual time=0.002..0.005 rows=18 loops=1)

74. 0.024 0.077 ↑ 1.0 66 1

Hash (cost=5.87..5.87 rows=66 width=66) (actual time=0.077..0.077 rows=66 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
75. 0.032 0.053 ↑ 1.0 66 1

Hash Left Join (cost=1.41..5.87 rows=66 width=66) (actual time=0.013..0.053 rows=66 loops=1)

  • Hash Cond: ((obawo_inte22_.internal_routing_area_from_id)::text = (obawo_inte23_.obawo_internal_routing_area_id)::text)
76. 0.012 0.012 ↑ 1.0 66 1

Seq Scan on obawo_internal_routing obawo_inte22_ (cost=0.00..3.66 rows=66 width=66) (actual time=0.001..0.012 rows=66 loops=1)

77. 0.006 0.009 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=33) (actual time=0.009..0.009 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
78. 0.003 0.003 ↑ 1.0 18 1

Seq Scan on obawo_internal_routing_area obawo_inte23_ (cost=0.00..1.18 rows=18 width=33) (actual time=0.001..0.003 rows=18 loops=1)

79. 0.541 1.779 ↑ 1.0 1,439 1

Hash (cost=169.39..169.39 rows=1,439 width=159) (actual time=1.779..1.779 rows=1,439 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 125kB
80. 1.238 1.238 ↑ 1.0 1,439 1

Seq Scan on m_product product26_ (cost=0.00..169.39 rows=1,439 width=159) (actual time=0.004..1.238 rows=1,439 loops=1)

81. 0.411 0.997 ↑ 1.0 1,439 1

Hash (cost=169.39..169.39 rows=1,439 width=37) (actual time=0.997..0.997 rows=1,439 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 98kB
82. 0.586 0.586 ↑ 1.0 1,439 1

Seq Scan on m_product product27_ (cost=0.00..169.39 rows=1,439 width=37) (actual time=0.003..0.586 rows=1,439 loops=1)

83. 0.009 0.019 ↑ 1.0 36 1

Hash (cost=1.36..1.36 rows=36 width=25) (actual time=0.019..0.019 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
84. 0.010 0.010 ↑ 1.0 36 1

Seq Scan on c_uom uom28_ (cost=0.00..1.36 rows=36 width=25) (actual time=0.002..0.010 rows=36 loops=1)

85. 0.000 0.000 ↓ 0.0 0 1,029

Materialize (cost=0.14..19.53 rows=1 width=82) (actual time=0.000..0.000 rows=0 loops=1,029)

86. 0.000 0.000 ↓ 0.0 0 1

Nested Loop (cost=0.14..19.52 rows=1 width=82) (actual time=0.000..0.000 rows=0 loops=1)

87. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on obawo_errors obawo_erro32_ (cost=0.00..11.35 rows=1 width=82) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (((taskstatus)::text = 'N'::text) AND (blocks = 'Y'::bpchar))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using obawo_idx_errortask_error on obawo_error_task obawo_erro31_ (cost=0.14..8.16 rows=1 width=164) (never executed)

  • Index Cond: ((obawo_errors_id)::text = (obawo_erro32_.obawo_errors_id)::text)
89. 0.423 1.252 ↑ 1.0 1,439 1

Hash (cost=169.39..169.39 rows=1,439 width=66) (actual time=1.252..1.252 rows=1,439 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 110kB
90. 0.829 0.829 ↑ 1.0 1,439 1

Seq Scan on m_product product29_ (cost=0.00..169.39 rows=1,439 width=66) (actual time=0.003..0.829 rows=1,439 loops=1)

91. 0.007 0.016 ↑ 1.0 26 1

Hash (cost=1.26..1.26 rows=26 width=31) (actual time=0.016..0.016 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
92. 0.009 0.009 ↑ 1.0 26 1

Seq Scan on m_attributeset attributes30_ (cost=0.00..1.26 rows=26 width=31) (actual time=0.002..0.009 rows=26 loops=1)