explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FPo8

Settings
# exclusive inclusive rows x rows loops node
1. 26.824 615.071 ↓ 1.1 1,029 1

Sort (cost=2,270.51..2,272.80 rows=915 width=1,725) (actual time=615.017..615.071 rows=1,029 loops=1)

  • Sort Key: obawo_task0_.priority, obawo_rece1_.obawo_receptionlist_id, obawo_pick3_.obawo_pickinglist_id, obawo_task0_.obawo_travel_sequence, locator6_.value, locator5_.value, obawo_task0_.created
  • Sort Method: quicksort Memory: 1103kB
2. 570.250 588.247 ↓ 1.1 1,029 1

Nested Loop Anti Join (cost=512.84..2,225.50 rows=915 width=1,725) (actual time=3.652..588.247 rows=1,029 loops=1)

  • Join Filter: ((obawo_erro31_.obawo_task_id)::text = (obawo_task0_.obawo_task_id)::text)
3. 0.797 17.997 ↓ 1.1 1,029 1

Hash Left Join (cost=512.69..1,030.19 rows=916 width=1,725) (actual time=2.669..17.997 rows=1,029 loops=1)

  • Hash Cond: ((product27_.c_uom_id)::text = (uom28_.c_uom_id)::text)
4. 0.906 17.189 ↓ 1.1 1,029 1

Hash Left Join (cost=510.88..1,015.78 rows=916 width=1,704) (actual time=2.654..17.189 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.m_product_id)::text = (product27_.m_product_id)::text)
5. 0.921 15.751 ↓ 1.1 1,029 1

Hash Left Join (cost=323.50..815.81 rows=916 width=1,700) (actual time=2.117..15.751 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.m_product_id)::text = (product26_.m_product_id)::text)
6. 0.689 13.653 ↓ 1.1 1,029 1

Hash Left Join (cost=136.12..615.84 rows=916 width=1,541) (actual time=0.932..13.653 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_internal_routing_id)::text = (obawo_inte22_.obawo_internal_routing_id)::text)
7. 0.671 12.920 ↓ 1.1 1,029 1

Hash Left Join (cost=129.43..596.54 rows=916 width=1,541) (actual time=0.886..12.920 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_internal_routing_id)::text = (obawo_inte24_.obawo_internal_routing_id)::text)
8. 0.663 12.205 ↓ 1.1 1,029 1

Hash Left Join (cost=122.72..577.24 rows=916 width=1,508) (actual time=0.839..12.205 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_pa_warehousealgorithm_id)::text = (obawo_ware21_.obawo_warehouse_algorithm_id)::text)
9. 0.436 11.535 ↓ 1.1 1,029 1

Hash Left Join (cost=120.14..562.94 rows=916 width=1,508) (actual time=0.829..11.535 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_pk_warehousealgorithm_id)::text = (obawo_ware20_.obawo_warehouse_algorithm_id)::text)
10. 0.409 11.089 ↓ 1.1 1,029 1

Hash Left Join (cost=117.55..556.70 rows=916 width=1,508) (actual time=0.818..11.089 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.c_aum)::text = (uom18_.c_uom_id)::text)
11. 0.421 10.670 ↓ 1.1 1,029 1

Hash Left Join (cost=115.74..551.28 rows=916 width=1,516) (actual time=0.805..10.670 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.confirmed_m_refinventory_id)::text = (materialmg17_.m_refinventory_id)::text)
12. 0.431 10.245 ↓ 1.1 1,029 1

Hash Left Join (cost=114.52..546.49 rows=916 width=1,506) (actual time=0.799..10.245 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.expected_m_refinventory_id)::text = (materialmg16_.m_refinventory_id)::text)
13. 0.686 9.810 ↓ 1.1 1,029 1

Hash Join (cost=113.29..541.67 rows=916 width=1,496) (actual time=0.794..9.810 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task14_.obawo_base_task_type_id)::text = (obawo_base15_.obawo_base_task_type_id)::text)
14. 0.698 9.118 ↓ 1.1 1,029 1

Hash Join (cost=112.20..527.98 rows=916 width=1,470) (actual time=0.783..9.118 rows=1,029 loops=1)

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

Hash Left Join (cost=110.95..514.14 rows=916 width=1,405) (actual time=0.774..8.414 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_internal_routing_id)::text = (obawo_inte13_.obawo_internal_routing_id)::text)
16. 0.362 7.716 ↓ 1.1 1,029 1

Hash Left Join (cost=106.47..497.06 rows=916 width=1,364) (actual time=0.739..7.716 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.confirmed_attribute_id)::text = (attributes12_.m_attributesetinstance_id)::text)
17. 0.536 7.274 ↓ 1.1 1,029 1

Hash Left Join (cost=93.07..479.32 rows=916 width=1,341) (actual time=0.657..7.274 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.expected_attribute_id)::text = (attributes11_.m_attributesetinstance_id)::text)
18. 0.386 6.651 ↓ 1.1 1,029 1

Hash Left Join (cost=79.67..457.50 rows=916 width=1,329) (actual time=0.567..6.651 rows=1,029 loops=1)

  • Hash Cond: ((materialmg9_.m_refinventory_id)::text = (materialmg10_.m_refinventory_id)::text)
19. 0.388 6.261 ↓ 1.1 1,029 1

Hash Left Join (cost=78.44..452.62 rows=916 width=1,319) (actual time=0.560..6.261 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.m_storage_detail_id)::text = (materialmg9_.m_storage_detail_id)::text)
20. 0.407 5.575 ↓ 1.1 1,029 1

Hash Left Join (cost=32.89..402.83 rows=916 width=1,286) (actual time=0.259..5.575 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.confirmed_locator_from_id)::text = (locator8_.m_locator_id)::text)
21. 0.395 5.116 ↓ 1.1 1,029 1

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

  • Hash Cond: ((obawo_task0_.expected_locator_from_id)::text = (locator6_.m_locator_id)::text)
22. 0.636 4.681 ↓ 1.1 1,029 1

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

  • Hash Cond: ((obawo_task0_.expected_locator_to_id)::text = (locator5_.m_locator_id)::text)
23. 0.574 4.001 ↓ 1.1 1,029 1

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

  • Hash Cond: ((obawo_task0_.obawo_batchoftasks_id)::text = (obawo_batc2_.obawo_batchoftasks_id)::text)
24. 0.872 3.376 ↓ 1.1 1,029 1

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

  • Hash Cond: ((obawo_task0_.obawo_receptionlist_id)::text = (obawo_rece1_.obawo_receptionlist_id)::text)
25. 0.773 2.486 ↓ 1.1 1,029 1

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

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

Seq Scan on obawo_task obawo_task0_ (cost=0.00..321.16 rows=916 width=880) (actual time=0.026..1.698 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
27. 0.001 0.015 ↑ 1.0 9 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
28. 0.007 0.014 ↑ 1.0 9 1

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

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

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

30. 0.001 0.004 ↑ 1.0 9 1

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

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

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

32. 0.010 0.018 ↑ 1.0 42 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
33. 0.008 0.008 ↑ 1.0 42 1

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

34. 0.025 0.051 ↑ 1.0 145 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
35. 0.026 0.026 ↑ 1.0 145 1

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

36. 0.020 0.044 ↑ 1.0 107 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 0.024 0.024 ↑ 1.0 107 1

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

38. 0.013 0.040 ↑ 1.0 107 1

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

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

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

40. 0.018 0.052 ↑ 1.0 107 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
41. 0.034 0.034 ↑ 1.0 107 1

Seq Scan on m_locator locator8_ (cost=0.00..5.07 rows=107 width=122) (actual time=0.000..0.034 rows=107 loops=1)

42. 0.103 0.298 ↑ 1.0 780 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
43. 0.195 0.195 ↑ 1.0 780 1

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

44. 0.002 0.004 ↑ 1.0 10 1

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

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

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

46. 0.044 0.087 ↑ 1.0 240 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
47. 0.043 0.043 ↑ 1.0 240 1

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

48. 0.037 0.080 ↑ 1.0 240 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
49. 0.043 0.043 ↑ 1.0 240 1

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

50. 0.015 0.032 ↑ 1.0 66 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
51. 0.017 0.017 ↑ 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.017 rows=66 loops=1)

52. 0.003 0.006 ↑ 1.0 11 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
53. 0.003 0.003 ↑ 1.0 11 1

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

54. 0.002 0.006 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
55. 0.004 0.004 ↑ 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.002..0.004 rows=4 loops=1)

56. 0.002 0.004 ↑ 1.0 10 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
57. 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)

58. 0.002 0.004 ↑ 1.0 10 1

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

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

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

60. 0.005 0.010 ↑ 1.0 36 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
61. 0.005 0.005 ↑ 1.0 36 1

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

62. 0.003 0.010 ↑ 1.0 26 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
63. 0.007 0.007 ↑ 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.007 rows=26 loops=1)

64. 0.003 0.007 ↑ 1.0 26 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
65. 0.004 0.004 ↑ 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.004 rows=26 loops=1)

66. 0.007 0.044 ↑ 1.0 66 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 7kB
67. 0.028 0.037 ↑ 1.0 66 1

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

  • Hash Cond: ((obawo_inte24_.internal_routing_area_to_id)::text = (obawo_inte25_.obawo_internal_routing_area_id)::text)
68. 0.004 0.004 ↑ 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.004 rows=66 loops=1)

69. 0.003 0.005 ↑ 1.0 18 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
70. 0.002 0.002 ↑ 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.001..0.002 rows=18 loops=1)

71. 0.009 0.044 ↑ 1.0 66 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
72. 0.024 0.035 ↑ 1.0 66 1

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

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

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

74. 0.004 0.005 ↑ 1.0 18 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
75. 0.001 0.001 ↑ 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.000..0.001 rows=18 loops=1)

76. 0.281 1.177 ↑ 1.0 1,439 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 125kB
77. 0.896 0.896 ↑ 1.0 1,439 1

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

78. 0.219 0.532 ↑ 1.0 1,439 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 98kB
79. 0.313 0.313 ↑ 1.0 1,439 1

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

80. 0.006 0.011 ↑ 1.0 36 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
81. 0.005 0.005 ↑ 1.0 36 1

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

82. 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)

83. 0.000 0.001 ↓ 0.0 0 1

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

84. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: (((taskstatus)::text = 'N'::text) AND (blocks = 'Y'::bpchar))
85. 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)