explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EVWo

Settings
# exclusive inclusive rows x rows loops node
1. 28.155 667.741 ↓ 5.1 1,029 1

Sort (cost=1,530.78..1,531.28 rows=202 width=2,982) (actual time=667.695..667.741 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. 602.854 639.586 ↓ 5.1 1,029 1

Hash Left Join (cost=256.00..1,523.04 rows=202 width=2,982) (actual time=4.289..639.586 rows=1,029 loops=1)

  • Hash Cond: ((product29_.m_attributeset_id)::text = (attributes30_.m_attributeset_id)::text)
3. 1.563 36.713 ↓ 5.1 1,029 1

Nested Loop Left Join (cost=254.97..1,264.69 rows=202 width=3,013) (actual time=2.654..36.713 rows=1,029 loops=1)

4. 0.996 32.063 ↓ 5.1 1,029 1

Nested Loop Anti Join (cost=254.70..1,145.92 rows=202 width=2,980) (actual time=2.641..32.063 rows=1,029 loops=1)

  • Join Filter: ((obawo_erro31_.obawo_task_id)::text = (obawo_task0_.obawo_task_id)::text)
5. 0.952 31.067 ↓ 5.1 1,029 1

Hash Left Join (cost=254.55..1,123.36 rows=202 width=2,980) (actual time=2.636..31.067 rows=1,029 loops=1)

  • Hash Cond: ((product27_.c_uom_id)::text = (uom28_.c_uom_id)::text)
6. 1.010 30.095 ↓ 5.1 1,029 1

Nested Loop Left Join (cost=243.20..1,109.23 rows=202 width=2,902) (actual time=2.604..30.095 rows=1,029 loops=1)

7. 2.273 25.998 ↓ 5.1 1,029 1

Nested Loop Left Join (cost=242.92..990.45 rows=202 width=2,898) (actual time=2.592..25.998 rows=1,029 loops=1)

8. 0.871 17.551 ↓ 5.1 1,029 1

Hash Left Join (cost=242.65..871.68 rows=202 width=2,739) (actual time=2.564..17.551 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_internal_routing_id)::text = (obawo_inte22_.obawo_internal_routing_id)::text)
9. 0.781 16.575 ↓ 5.1 1,029 1

Hash Left Join (cost=225.10..851.36 rows=202 width=2,690) (actual time=2.447..16.575 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_internal_routing_id)::text = (obawo_inte24_.obawo_internal_routing_id)::text)
10. 0.772 15.689 ↓ 5.1 1,029 1

Hash Left Join (cost=207.55..831.03 rows=202 width=2,608) (actual time=2.330..15.689 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_pa_warehousealgorithm_id)::text = (obawo_ware21_.obawo_warehouse_algorithm_id)::text)
11. 0.508 14.897 ↓ 5.1 1,029 1

Hash Left Join (cost=204.97..825.85 rows=202 width=2,608) (actual time=2.298..14.897 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_pk_warehousealgorithm_id)::text = (obawo_ware20_.obawo_warehouse_algorithm_id)::text)
12. 0.472 14.369 ↓ 5.1 1,029 1

Hash Left Join (cost=202.38..822.46 rows=202 width=2,608) (actual time=2.267..14.369 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.c_aum)::text = (uom18_.c_uom_id)::text)
13. 0.522 13.875 ↓ 5.1 1,029 1

Hash Left Join (cost=191.03..810.31 rows=202 width=2,559) (actual time=2.235..13.875 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.confirmed_m_refinventory_id)::text = (materialmg17_.m_refinventory_id)::text)
14. 0.479 13.343 ↓ 5.1 1,029 1

Hash Left Join (cost=178.33..796.83 rows=202 width=2,481) (actual time=2.212..13.343 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.expected_m_refinventory_id)::text = (materialmg16_.m_refinventory_id)::text)
15. 0.778 12.855 ↓ 5.1 1,029 1

Hash Join (cost=165.63..783.33 rows=202 width=2,403) (actual time=2.191..12.855 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task14_.obawo_base_task_type_id)::text = (obawo_base15_.obawo_base_task_type_id)::text)
16. 0.871 12.065 ↑ 2.5 1,029 1

Hash Join (cost=164.54..770.73 rows=2,530 width=2,377) (actual time=2.165..12.065 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_task_type_id)::text = (obawo_task14_.obawo_task_type_id)::text)
17. 0.516 11.137 ↑ 2.5 1,029 1

Hash Left Join (cost=153.42..724.82 rows=2,530 width=1,872) (actual time=2.093..11.137 rows=1,029 loops=1)

  • Hash Cond: ((materialmg9_.m_refinventory_id)::text = (materialmg10_.m_refinventory_id)::text)
18. 0.828 10.607 ↑ 2.5 1,029 1

Hash Left Join (cost=140.72..702.01 rows=2,530 width=1,745) (actual time=2.067..10.607 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_internal_routing_id)::text = (obawo_inte13_.obawo_internal_routing_id)::text)
19. 0.476 9.708 ↑ 2.5 1,029 1

Hash Left Join (cost=136.23..662.74 rows=2,530 width=1,704) (actual time=1.980..9.708 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.confirmed_attribute_id)::text = (attributes12_.m_attributesetinstance_id)::text)
20. 0.639 9.050 ↑ 2.5 1,029 1

Hash Left Join (cost=122.88..637.42 rows=2,530 width=1,680) (actual time=1.786..9.050 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.expected_attribute_id)::text = (attributes11_.m_attributesetinstance_id)::text)
21. 0.506 8.213 ↑ 2.5 1,029 1

Hash Left Join (cost=109.52..600.80 rows=2,530 width=1,667) (actual time=1.570..8.213 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.m_storage_detail_id)::text = (materialmg9_.m_storage_detail_id)::text)
22. 0.470 7.004 ↑ 2.5 1,029 1

Hash Left Join (cost=63.97..543.57 rows=2,530 width=1,634) (actual time=0.851..7.004 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.confirmed_locator_from_id)::text = (locator8_.m_locator_id)::text)
23. 0.492 6.453 ↑ 2.5 1,029 1

Hash Left Join (cost=57.56..525.23 rows=2,530 width=1,545) (actual time=0.759..6.453 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.expected_locator_from_id)::text = (locator6_.m_locator_id)::text)
24. 0.763 5.874 ↑ 2.5 1,029 1

Hash Left Join (cost=51.16..506.46 rows=2,530 width=1,456) (actual time=0.660..5.874 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.expected_locator_to_id)::text = (locator5_.m_locator_id)::text)
25. 0.721 5.021 ↑ 2.5 1,029 1

Hash Left Join (cost=44.75..466.64 rows=2,530 width=1,367) (actual time=0.557..5.021 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_batchoftasks_id)::text = (obawo_batc2_.obawo_batchoftasks_id)::text)
26. 1.023 4.194 ↑ 2.5 1,029 1

Hash Left Join (cost=35.70..434.59 rows=2,530 width=1,351) (actual time=0.433..4.194 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_receptionlist_id)::text = (obawo_rece1_.obawo_receptionlist_id)::text)
27. 0.780 3.130 ↑ 2.5 1,029 1

Hash Left Join (cost=24.35..390.77 rows=2,530 width=1,175) (actual time=0.380..3.130 rows=1,029 loops=1)

  • Hash Cond: ((obawo_task0_.obawo_pickinglist_id)::text = (obawo_pick3_.obawo_pickinglist_id)::text)
28. 2.251 2.251 ↑ 2.5 1,029 1

Seq Scan on obawo_task obawo_task0_ (cost=0.00..356.67 rows=2,530 width=880) (actual time=0.212..2.251 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
29. 0.005 0.099 ↑ 6.7 9 1

Hash (cost=23.60..23.60 rows=60 width=328) (actual time=0.099..0.099 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
30. 0.045 0.094 ↑ 6.7 9 1

Hash Right Join (cost=11.35..23.60 rows=60 width=328) (actual time=0.089..0.094 rows=9 loops=1)

  • Hash Cond: ((materialmg4_.m_refinventory_id)::text = (obawo_pick3_.m_refinventory_id)::text)
31. 0.005 0.005 ↑ 12.0 10 1

Seq Scan on m_refinventory materialmg4_ (cost=0.00..11.20 rows=120 width=160) (actual time=0.003..0.005 rows=10 loops=1)

32. 0.016 0.044 ↑ 6.7 9 1

Hash (cost=10.60..10.60 rows=60 width=250) (actual time=0.044..0.044 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
33. 0.028 0.028 ↑ 6.7 9 1

Seq Scan on obawo_pickinglist obawo_pick3_ (cost=0.00..10.60 rows=60 width=250) (actual time=0.017..0.028 rows=9 loops=1)

34. 0.015 0.041 ↑ 1.4 42 1

Hash (cost=10.60..10.60 rows=60 width=176) (actual time=0.041..0.041 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
35. 0.026 0.026 ↑ 1.4 42 1

Seq Scan on obawo_receptionlist obawo_rece1_ (cost=0.00..10.60 rows=60 width=176) (actual time=0.006..0.026 rows=42 loops=1)

36. 0.054 0.106 ↑ 1.2 145 1

Hash (cost=6.80..6.80 rows=180 width=49) (actual time=0.106..0.106 rows=145 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
37. 0.052 0.052 ↑ 1.2 145 1

Seq Scan on obawo_batchoftasks obawo_batc2_ (cost=0.00..6.80 rows=180 width=49) (actual time=0.004..0.052 rows=145 loops=1)

38. 0.039 0.090 ↑ 1.0 107 1

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

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

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

40. 0.039 0.087 ↑ 1.0 107 1

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

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

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

42. 0.046 0.081 ↑ 1.0 107 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
43. 0.035 0.035 ↑ 1.0 107 1

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

44. 0.354 0.703 ↑ 1.0 780 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
45. 0.349 0.349 ↑ 1.0 780 1

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

46. 0.100 0.198 ↓ 1.0 240 1

Hash (cost=10.38..10.38 rows=238 width=42) (actual time=0.198..0.198 rows=240 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
47. 0.098 0.098 ↓ 1.0 240 1

Seq Scan on m_attributesetinstance attributes11_ (cost=0.00..10.38 rows=238 width=42) (actual time=0.007..0.098 rows=240 loops=1)

48. 0.093 0.182 ↓ 1.0 240 1

Hash (cost=10.38..10.38 rows=238 width=42) (actual time=0.182..0.182 rows=240 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
49. 0.089 0.089 ↓ 1.0 240 1

Seq Scan on m_attributesetinstance attributes12_ (cost=0.00..10.38 rows=238 width=42) (actual time=0.003..0.089 rows=240 loops=1)

50. 0.028 0.071 ↑ 1.0 66 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
51. 0.043 0.043 ↑ 1.0 66 1

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

52. 0.006 0.014 ↑ 12.0 10 1

Hash (cost=11.20..11.20 rows=120 width=160) (actual time=0.014..0.014 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
53. 0.008 0.008 ↑ 12.0 10 1

Seq Scan on m_refinventory materialmg10_ (cost=0.00..11.20 rows=120 width=160) (actual time=0.003..0.008 rows=10 loops=1)

54. 0.029 0.057 ↑ 4.5 11 1

Hash (cost=10.50..10.50 rows=50 width=538) (actual time=0.057..0.057 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
55. 0.028 0.028 ↑ 4.5 11 1

Seq Scan on obawo_task_type obawo_task14_ (cost=0.00..10.50 rows=50 width=538) (actual time=0.009..0.028 rows=11 loops=1)

56. 0.004 0.012 ↑ 1.0 4 1

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

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

58. 0.003 0.009 ↑ 12.0 10 1

Hash (cost=11.20..11.20 rows=120 width=160) (actual time=0.009..0.009 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
59. 0.006 0.006 ↑ 12.0 10 1

Seq Scan on m_refinventory materialmg16_ (cost=0.00..11.20 rows=120 width=160) (actual time=0.001..0.006 rows=10 loops=1)

60. 0.006 0.010 ↑ 12.0 10 1

Hash (cost=11.20..11.20 rows=120 width=160) (actual time=0.010..0.010 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
61. 0.004 0.004 ↑ 12.0 10 1

Seq Scan on m_refinventory materialmg17_ (cost=0.00..11.20 rows=120 width=160) (actual time=0.001..0.004 rows=10 loops=1)

62. 0.012 0.022 ↑ 1.7 36 1

Hash (cost=10.60..10.60 rows=60 width=82) (actual time=0.022..0.022 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
63. 0.010 0.010 ↑ 1.7 36 1

Seq Scan on c_uom uom18_ (cost=0.00..10.60 rows=60 width=82) (actual time=0.004..0.010 rows=36 loops=1)

64. 0.010 0.020 ↑ 1.0 26 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
65. 0.010 0.010 ↑ 1.0 26 1

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

66. 0.007 0.020 ↑ 1.0 26 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
67. 0.013 0.013 ↑ 1.0 26 1

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

68. 0.030 0.105 ↑ 1.0 66 1

Hash (cost=16.73..16.73 rows=66 width=115) (actual time=0.105..0.105 rows=66 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 7kB
69. 0.049 0.075 ↑ 1.0 66 1

Hash Left Join (cost=12.25..16.73 rows=66 width=115) (actual time=0.029..0.075 rows=66 loops=1)

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

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

71. 0.010 0.015 ↑ 5.6 18 1

Hash (cost=11.00..11.00 rows=100 width=82) (actual time=0.015..0.015 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
72. 0.005 0.005 ↑ 5.6 18 1

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

73. 0.032 0.105 ↑ 1.0 66 1

Hash (cost=16.72..16.72 rows=66 width=115) (actual time=0.105..0.105 rows=66 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
74. 0.050 0.073 ↑ 1.0 66 1

Hash Left Join (cost=12.25..16.72 rows=66 width=115) (actual time=0.024..0.073 rows=66 loops=1)

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

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

76. 0.006 0.012 ↑ 5.6 18 1

Hash (cost=11.00..11.00 rows=100 width=82) (actual time=0.012..0.012 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
77. 0.006 0.006 ↑ 5.6 18 1

Seq Scan on obawo_internal_routing_area obawo_inte23_ (cost=0.00..11.00 rows=100 width=82) (actual time=0.002..0.006 rows=18 loops=1)

78. 6.174 6.174 ↑ 1.0 1 1,029

Index Scan using m_product_key on m_product product26_ (cost=0.28..0.58 rows=1 width=159) (actual time=0.006..0.006 rows=1 loops=1,029)

  • Index Cond: ((obawo_task0_.m_product_id)::text = (m_product_id)::text)
79. 3.087 3.087 ↑ 1.0 1 1,029

Index Scan using m_product_key on m_product product27_ (cost=0.28..0.58 rows=1 width=37) (actual time=0.003..0.003 rows=1 loops=1,029)

  • Index Cond: ((obawo_task0_.m_product_id)::text = (m_product_id)::text)
80. 0.013 0.020 ↑ 1.7 36 1

Hash (cost=10.60..10.60 rows=60 width=82) (actual time=0.020..0.020 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
81. 0.007 0.007 ↑ 1.7 36 1

Seq Scan on c_uom uom28_ (cost=0.00..10.60 rows=60 width=82) (actual time=0.003..0.007 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)
86. 3.087 3.087 ↑ 1.0 1 1,029

Index Scan using m_product_key on m_product product29_ (cost=0.28..0.58 rows=1 width=66) (actual time=0.003..0.003 rows=1 loops=1,029)

  • Index Cond: ((obawo_task0_.m_product_id)::text = (m_product_id)::text)
87. 0.009 0.019 ↓ 26.0 26 1

Hash (cost=1.01..1.01 rows=1 width=2) (actual time=0.019..0.019 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
88. 0.010 0.010 ↓ 26.0 26 1

Seq Scan on m_attributeset attributes30_ (cost=0.00..1.01 rows=1 width=2) (actual time=0.004..0.010 rows=26 loops=1)