explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d77

Settings
# exclusive inclusive rows x rows loops node
1. 27.198 622.016 ↓ 5.1 1,029 1

Sort (cost=1,530.78..1,531.28 rows=202 width=2,982) (actual time=621.963..622.016 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. 561.208 594.818 ↓ 5.1 1,029 1

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

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

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

4. 0.921 29.332 ↓ 5.1 1,029 1

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

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

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

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

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

7. 1.637 23.670 ↓ 5.1 1,029 1

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

8. 0.751 15.859 ↓ 5.1 1,029 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hash Join (cost=165.63..783.33 rows=202 width=2,403) (actual time=1.624..11.476 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.815 10.764 ↑ 2.5 1,029 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Hash Cond: ((obawo_task0_.obawo_pickinglist_id)::text = (obawo_pick3_.obawo_pickinglist_id)::text)
28. 1.904 1.904 ↑ 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.046..1.904 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.004 0.028 ↑ 6.7 9 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
30. 0.013 0.024 ↑ 6.7 9 1

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

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

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

32. 0.004 0.009 ↑ 6.7 9 1

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

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

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

34. 0.017 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.024 0.024 ↑ 1.4 42 1

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

36. 0.058 0.113 ↑ 1.2 145 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
37. 0.055 0.055 ↑ 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.055 rows=145 loops=1)

38. 0.038 0.091 ↑ 1.0 107 1

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

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

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

40. 0.032 0.080 ↑ 1.0 107 1

Hash (cost=5.07..5.07 rows=107 width=122) (actual time=0.080..0.080 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.036 0.078 ↑ 1.0 107 1

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

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

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

44. 0.243 0.603 ↑ 1.0 780 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
45. 0.360 0.360 ↑ 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.360 rows=780 loops=1)

46. 0.083 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
47. 0.099 0.099 ↓ 1.0 240 1

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

48. 0.088 0.179 ↓ 1.0 240 1

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

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

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

50. 0.026 0.061 ↑ 1.0 66 1

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

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

52. 0.005 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
53. 0.004 0.004 ↑ 12.0 10 1

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

54. 0.005 0.013 ↑ 4.5 11 1

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

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

Seq Scan on obawo_task_type obawo_task14_ (cost=0.00..10.50 rows=50 width=538) (actual time=0.003..0.008 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.005 0.008 ↑ 12.0 10 1

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

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

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

60. 0.004 0.008 ↑ 12.0 10 1

Hash (cost=11.20..11.20 rows=120 width=160) (actual time=0.008..0.008 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.013 0.025 ↑ 1.7 36 1

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

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

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

64. 0.007 0.019 ↑ 1.0 26 1

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

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

66. 0.014 0.017 ↑ 1.0 26 1

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

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

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

68. 0.029 0.098 ↑ 1.0 66 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 7kB
69. 0.046 0.069 ↑ 1.0 66 1

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

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

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

71. 0.008 0.013 ↑ 5.6 18 1

Hash (cost=11.00..11.00 rows=100 width=82) (actual time=0.013..0.013 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.003..0.005 rows=18 loops=1)

73. 0.020 0.095 ↑ 1.0 66 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
74. 0.047 0.075 ↑ 1.0 66 1

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

  • Hash Cond: ((obawo_inte22_.internal_routing_area_from_id)::text = (obawo_inte23_.obawo_internal_routing_area_id)::text)
75. 0.015 0.015 ↑ 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.015 rows=66 loops=1)

76. 0.009 0.013 ↑ 5.6 18 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
77. 0.004 0.004 ↑ 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.004 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.005..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.012 0.019 ↑ 1.7 36 1

Hash (cost=10.60..10.60 rows=60 width=82) (actual time=0.019..0.019 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.002..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.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)

84. 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))
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.002..0.003 rows=1 loops=1,029)

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

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

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

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