explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QRvI

Settings
# exclusive inclusive rows x rows loops node
1. 2,343.665 2,343.665 ↑ 4.1 29 1

CTE Scan on cte_subarea_workload (cost=406,540.28..406,542.68 rows=120 width=98) (actual time=2,343.636..2,343.665 rows=29 loops=1)

2.          

CTE cte_recursive_source_subareas

3. 0.000 0.000 ↓ 0.0 0

Recursive Union (cost=4.11..501.92 rows=581 width=587) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1 (cost=4.11..4.14 rows=1 width=94) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Group (cost=4.11..4.13 rows=1 width=128) (never executed)

  • Group Key: replensourcesubareas.sourcesubareas_id, sa.id, sam.blackbox, replensourcesubareas.processconfigs_id
6. 0.000 0.000 ↓ 0.0 0

Sort (cost=4.11..4.12 rows=1 width=116) (never executed)

  • Sort Key: replensourcesubareas.sourcesubareas_id, sam.blackbox
7. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.68..4.10 rows=1 width=116) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.41..3.75 rows=1 width=115) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uk_processconfid_said_seq on wms_processconf_wms_srcsubarea replensourcesubareas (cost=0.14..1.26 rows=1 width=52) (never executed)

  • Index Cond: (processconfigs_id = 'PRC-REPLENISHMENT-GTM-WS07'::text)
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_wms_subarea_id on wms_subarea sa (cost=0.27..2.49 rows=1 width=63) (never executed)

  • Index Cond: ((id)::text = (replensourcesubareas.sourcesubareas_id)::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_wms_subarea_movecontrol_id on wms_subarea_movementcontrol sam (cost=0.27..0.34 rows=1 width=27) (never executed)

  • Index Cond: ((id)::text = (sa.id)::text)
12. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=42.10..48.62 rows=58 width=587) (never executed)

  • Hash Cond: ((sam_1.id)::text = (sa_1.id)::text)
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on wms_subarea_movementcontrol sam_1 (cost=0.00..4.63 rows=163 width=27) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Hash (cost=41.38..41.38 rows=58 width=603) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.27..41.38 rows=58 width=603) (never executed)

16. 0.000 0.000 ↓ 0.0 0

WorkTable Scan on cte_recursive_source_subareas rsa (cost=0.00..0.20 rows=10 width=630) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Index Scan using i_subarea_parent_id on wms_subarea sa_1 (cost=0.27..4.06 rows=6 width=63) (never executed)

  • Index Cond: ((parent_id)::text = (rsa.id)::text)
18.          

CTE cte_subarea_workload

19. 1.243 2,343.643 ↑ 4.1 29 1

HashAggregate (cost=87,295.98..87,297.18 rows=120 width=25) (actual time=2,343.632..2,343.643 rows=29 loops=1)

  • Group Key: locsa.subareas_id
20. 9.166 2,342.400 ↑ 26.4 2,409 1

Hash Join (cost=72,164.25..86,977.47 rows=63,701 width=54) (actual time=2,084.962..2,342.400 rows=2,409 loops=1)

  • Hash Cond: ((ins.id)::text = (movement.id)::text)
21. 249.771 249.771 ↓ 1.0 17,309 1

Seq Scan on wms_instruction ins (cost=0.00..14,682.65 rows=17,057 width=37) (actual time=0.028..249.771 rows=17,309 loops=1)

  • Filter: (status >= 6)
  • Rows Removed by Filter: 569
22. 1.322 2,083.463 ↑ 27.1 2,409 1

Hash (cost=71,347.67..71,347.67 rows=65,326 width=54) (actual time=2,083.463..2,083.463 rows=2,409 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 725kB
23. 7.690 2,082.141 ↑ 27.1 2,409 1

Hash Join (cost=58,471.48..71,347.67 rows=65,326 width=54) (actual time=1,946.817..2,082.141 rows=2,409 loops=1)

  • Hash Cond: ((locsa.subareas_id)::text = (secsub.subarea_id)::text)
24. 24.224 2,074.170 ↑ 5.1 22,425 1

Hash Join (cost=58,450.98..67,655.51 rows=114,987 width=54) (actual time=1,945.772..2,074.170 rows=22,425 loops=1)

  • Hash Cond: ((movement.grouptransportunit_id)::text = (sk.id)::text)
25. 106.508 106.508 ↑ 11.9 12,320 1

Seq Scan on wms_instruction_movement movement (cost=0.00..7,503.40 rows=147,000 width=74) (actual time=0.010..106.508 rows=12,320 loops=1)

  • Filter: (((type)::text = 'PUT'::text) AND ((controltype)::text = 'MOVE_TO_LOCATION'::text))
  • Rows Removed by Filter: 2652
26. 110.467 1,943.438 ↑ 1.8 163,777 1

Hash (cost=54,866.19..54,866.19 rows=286,783 width=34) (actual time=1,943.438..1,943.438 rows=163,777 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 18692kB
27. 762.743 1,832.971 ↑ 1.8 163,777 1

Merge Join (cost=2,291.79..54,866.19 rows=286,783 width=34) (actual time=490.724..1,832.971 rows=163,777 loops=1)

  • Merge Cond: ((sk.parent_id)::text = (locsa.locations_id)::text)
28. 169.868 169.868 ↑ 5.2 70,648 1

Index Scan using i_stockkeepable_parent_id on wms_stockkeepable sk (cost=0.42..59,370.22 rows=366,623 width=43) (actual time=0.016..169.868 rows=70,648 loops=1)

29. 900.360 900.360 ↑ 1.1 1,075,692 1

Index Scan using i_location_wms_subarea_loc_id on wms_location_wms_subarea locsa (cost=0.43..37,540.41 rows=1,163,846 width=29) (actual time=0.009..900.360 rows=1,075,692 loops=1)

30. 0.130 0.281 ↑ 1.0 431 1

Hash (cost=15.11..15.11 rows=431 width=29) (actual time=0.281..0.281 rows=431 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
31. 0.151 0.151 ↑ 1.0 431 1

Seq Scan on mfc_section_subarea secsub (cost=0.00..15.11 rows=431 width=29) (actual time=0.008..0.151 rows=431 loops=1)

  • Filter: (subarea_id IS NOT NULL)
  • Rows Removed by Filter: 80
32.          

CTE cte_source_subareas

33. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=112.58..115.08 rows=200 width=752) (never executed)

  • Group Key: rsa_1.id, rsa_1.parent_id, rsa_1.recursive_level, rsa_1.blocked, rsa_1.blackbox, rsa_1.sequence, rsa_1.positionindex, rsa_1.replenconfig_id
34. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=22.78..98.06 rows=581 width=753) (never executed)

  • Hash Cond: ((rsa_1.id)::text = (sawl.sa_id)::text)
35. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=18.88..88.49 rows=581 width=745) (never executed)

  • Hash Cond: ((childsa.parent_id)::text = (rsa_1.id)::text)
36. 0.000 0.000 ↓ 0.0 0

Seq Scan on wms_subarea childsa (cost=0.00..52.71 rows=171 width=47) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.62..11.62 rows=581 width=720) (never executed)

38. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte_recursive_source_subareas rsa_1 (cost=0.00..11.62 rows=581 width=720) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.40..2.40 rows=120 width=98) (never executed)

40. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte_subarea_workload sawl (cost=0.00..2.40 rows=120 width=98) (never executed)

41.          

CTE cte_recursive_stockkeepables

42. 0.000 0.000 ↓ 0.0 0

Recursive Union (cost=3.32..413.58 rows=101 width=1,559) (never executed)

43. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=3.32..9.45 rows=1 width=811) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.92..9.02 rows=1 width=732) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.50..8.56 rows=1 width=720) (never executed)

46. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.08..8.10 rows=1 width=683) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.66..6.76 rows=1 width=658) (never executed)

48. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.24..5.80 rows=1 width=41) (never executed)

  • Join Filter: ((replenap.article_id)::text = (replena.id)::text)
49. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..5.28 rows=1 width=115) (never executed)

50. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_articlepackage_id on wms_articlepackage replenap (cost=0.41..2.63 rows=1 width=41) (never executed)

  • Index Cond: ((id)::text = '0c9e2dc3-dec0-44e6-afab-e27ddf91a81f'::text)
51. 0.000 0.000 ↓ 0.0 0

Index Scan using i_articlepackage_article_id on wms_articlepackage stockap (cost=0.41..2.64 rows=1 width=78) (never executed)

  • Index Cond: ((article_id)::text = (replenap.article_id)::text)
  • Filter: (replenap.quantity = quantity)
52. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_wms_article_id on wms_article replena (cost=0.41..0.51 rows=1 width=37) (never executed)

  • Index Cond: (id = (stockap.article_id)::text)
  • Heap Fetches: 0
53. 0.000 0.000 ↓ 0.0 0

Index Scan using i_stock_articlepackage_id on wms_stock stock (cost=0.41..0.94 rows=2 width=654) (never executed)

  • Index Cond: ((articlepackage_id)::text = (stockap.id)::text)
54. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_wms_stockkeepable_id on wms_stockkeepable sk_1 (cost=0.42..1.34 rows=1 width=60) (never executed)

  • Index Cond: ((id)::text = (stock.stockkeepable_id)::text)
55. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_transportunit_id on wms_transportunit tu (cost=0.42..0.44 rows=1 width=37) (never executed)

  • Index Cond: (id = (sk_1.id)::text)
  • Heap Fetches: 0
56. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_wms_location_id on wms_location loc (cost=0.42..0.45 rows=1 width=12) (never executed)

  • Index Cond: (id = (sk_1.id)::text)
  • Heap Fetches: 0
57. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_carrier_id on wms_carrier car (cost=0.40..0.43 rows=1 width=36) (never executed)

  • Index Cond: (id = (sk_1.id)::text)
  • Heap Fetches: 0
58. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.67..40.21 rows=10 width=1,559) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.26..35.85 rows=10 width=1,625) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.84..31.24 rows=10 width=1,613) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..26.70 rows=10 width=1,576) (never executed)

62. 0.000 0.000 ↓ 0.0 0

WorkTable Scan on cte_recursive_stockkeepables rsk (cost=0.00..0.20 rows=10 width=1,606) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_wms_stockkeepable_id on wms_stockkeepable sk_2 (cost=0.42..2.64 rows=1 width=60) (never executed)

  • Index Cond: ((id)::text = (rsk.sk_parent_id)::text)
64. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_transportunit_id on wms_transportunit tu_1 (cost=0.42..0.44 rows=1 width=37) (never executed)

  • Index Cond: (id = (sk_2.id)::text)
  • Heap Fetches: 0
65. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_wms_location_id on wms_location loc_1 (cost=0.42..0.45 rows=1 width=12) (never executed)

  • Index Cond: (id = (sk_2.id)::text)
  • Heap Fetches: 0
66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_carrier_id on wms_carrier car_1 (cost=0.40..0.43 rows=1 width=36) (never executed)

  • Index Cond: (id = (sk_2.id)::text)
  • Heap Fetches: 0
67.          

CTE cte_recursive_transportunit

68. 0.000 0.000 ↓ 0.0 0

Recursive Union (cost=270.18..316,720.45 rows=32,911 width=165) (never executed)

69. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=270.18..1,097.97 rows=101 width=165) (never executed)

  • Group Key: sk_3.id, rsk_1.stock_id
70. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..269.67 rows=101 width=133) (never executed)

71. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte_recursive_stockkeepables rsk_1 (cost=0.00..2.02 rows=101 width=180) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_wms_stockkeepable_id on wms_stockkeepable sk_3 (cost=0.42..2.64 rows=1 width=43) (never executed)

  • Index Cond: ((id)::text = (rsk_1.transportunit_id)::text)
73.          

SubPlan (forHashAggregate)

74. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.18..8.19 rows=1 width=32) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.07..8.17 rows=1 width=8) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.66..7.04 rows=1 width=82) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..6.10 rows=1 width=156) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..5.28 rows=1 width=119) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Index Scan using i_insmove_srcsk_type on wms_instruction_movement movementins (cost=0.42..2.64 rows=1 width=37) (never executed)

  • Index Cond: ((sourcestockkeepable_id)::text = (sk_3.id)::text)
  • Filter: (((type)::text <> 'PUT'::text) AND ((controltype)::text <> 'MOVE_TO_LOCATION'::text))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using i_wms_olalloc_id on wms_olalloc allocation (cost=0.41..2.63 rows=1 width=82) (never executed)

  • Index Cond: ((instruction_id)::text = (movementins.id)::text)
81. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_olalloc_movement_id on wms_olalloc_movement movementallocation (cost=0.41..0.81 rows=1 width=37) (never executed)

  • Index Cond: (id = (allocation.id)::text)
  • Heap Fetches: 0
82. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_olalloc_stock_id on wms_olalloc_stock stockallocation (cost=0.41..0.93 rows=1 width=37) (never executed)

  • Index Cond: ((id)::text = (allocation.id)::text)
  • Filter: (stockreserved AND ((stock_id)::text <> (rsk_1.stock_id)::text))
83. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_wms_instruction_id on wms_instruction ins_1 (cost=0.41..1.12 rows=1 width=37) (never executed)

  • Index Cond: (id = (allocation.instruction_id)::text)
  • Heap Fetches: 0
84. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..31,496.43 rows=3,281 width=165) (never executed)

85. 0.000 0.000 ↓ 0.0 0

WorkTable Scan on cte_recursive_transportunit rtu (cost=0.00..20.20 rows=1,010 width=180) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Index Scan using i_stockkeepable_parent_id on wms_stockkeepable sk_4 (cost=0.42..4.54 rows=3 width=43) (never executed)

  • Index Cond: ((parent_id)::text = (rtu.tu_id)::text)
87.          

SubPlan (forNested Loop)

88. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.18..8.19 rows=1 width=32) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.07..8.17 rows=1 width=8) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.66..7.04 rows=1 width=82) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..6.10 rows=1 width=156) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..5.28 rows=1 width=119) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Index Scan using i_insmove_srcsk_type on wms_instruction_movement movementinstruction (cost=0.42..2.64 rows=1 width=37) (never executed)

  • Index Cond: ((sourcestockkeepable_id)::text = (sk_4.id)::text)
  • Filter: (((type)::text <> 'PUT'::text) AND ((controltype)::text <> 'MOVE_TO_LOCATION'::text))
94. 0.000 0.000 ↓ 0.0 0

Index Scan using i_wms_olalloc_id on wms_olalloc allocation_1 (cost=0.41..2.63 rows=1 width=82) (never executed)

  • Index Cond: ((instruction_id)::text = (movementinstruction.id)::text)
95. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_olalloc_movement_id on wms_olalloc_movement movementallocation_1 (cost=0.41..0.81 rows=1 width=37) (never executed)

  • Index Cond: (id = (allocation_1.id)::text)
  • Heap Fetches: 0
96. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_olalloc_stock_id on wms_olalloc_stock stockallocation_1 (cost=0.41..0.93 rows=1 width=37) (never executed)

  • Index Cond: ((id)::text = (allocation_1.id)::text)
  • Filter: (stockreserved AND ((stock_id)::text <> (rtu.stock_id)::text))
97. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_wms_instruction_id on wms_instruction instruction (cost=0.41..1.12 rows=1 width=37) (never executed)

  • Index Cond: (id = (allocation_1.instruction_id)::text)
  • Heap Fetches: 0
98.          

CTE cte_stock

99. 0.000 0.000 ↓ 0.0 0

Append (cost=171.90..216.03 rows=4 width=1,586) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_1 (cost=171.90..171.98 rows=1 width=1,527) (never executed)

101. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=171.90..171.97 rows=1 width=1,559) (never executed)

  • Group Key: rsk_2.transportunit_id, rsk_2.transportunit_type, rsk_2.parent_transportunit_type, loc_2.id, rsk_2.carrier_id, replensourcesubareas_1.sourcesubareas_id, rsk_2.stock_id, rsk_2.stock_blockreason, rsk_2.stock_quantity, rsk_2.stock_gendate, rsk_2.stock_expdate, rsk_2.stock_proddate, rsk_2.stock_lotcode, rsk_2.articlepackage_id, rsk_2.articlepackage_qty
102. 0.000 0.000 ↓ 0.0 0

Sort (cost=171.90..171.91 rows=1 width=1,523) (never executed)

  • Sort Key: rsk_2.transportunit_id, rsk_2.transportunit_type, rsk_2.parent_transportunit_type, loc_2.id, rsk_2.carrier_id, replensourcesubareas_1.sourcesubareas_id, rsk_2.stock_id, rsk_2.stock_blockreason, rsk_2.stock_quantity, rsk_2.stock_gendate, rsk_2.stock_expdate, rsk_2.stock_proddate, rsk_2.stock_lotcode, rsk_2.articlepackage_id, rsk_2.articlepackage_qty
103. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=3.72..171.89 rows=1 width=1,523) (never executed)

  • Filter: (movement_1.id IS NULL)
104. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.30..169.26 rows=1 width=1,523) (never executed)

  • Join Filter: ((rsk_2.location_id)::text = (loc_2.id)::text)
105. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.88..168.80 rows=1 width=1,600) (never executed)

106. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.45..8.46 rows=1 width=162) (never executed)

  • Hash Cond: (((rsa_2.replenconfig_id)::text = (replensourcesubareas_1.processconfigs_id)::text) AND (rsa_2.sequence = replensourcesubareas_1.esequence))
107. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte_source_subareas rsa_2 (cost=0.00..4.00 rows=200 width=658) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.58..1.58 rows=58 width=52) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Seq Scan on wms_processconf_wms_srcsubarea replensourcesubareas_1 (cost=0.00..1.58 rows=58 width=52) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..159.33 rows=101 width=1,545) (never executed)

111. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte_recursive_stockkeepables rsk_2 (cost=0.00..2.02 rows=101 width=1,516) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_subarea_location_id on wms_location_wms_subarea lsa (cost=0.43..1.55 rows=1 width=29) (never executed)

  • Index Cond: ((subareas_id = (rsa_2.id)::text) AND (locations_id = (rsk_2.location_id)::text))
  • Heap Fetches: 0
113. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_wms_location_id on wms_location loc_2 (cost=0.42..0.45 rows=1 width=25) (never executed)

  • Index Cond: ((id)::text = (lsa.locations_id)::text)
114. 0.000 0.000 ↓ 0.0 0

Index Scan using i_insmove_grouptu_type_ctltype on wms_instruction_movement movement_1 (cost=0.42..2.62 rows=1 width=74) (never executed)

  • Index Cond: (((grouptransportunit_id)::text = (rsk_2.transportunit_id)::text) AND ((type)::text = 'PUT'::text))
  • Filter: (((controltype)::text = 'MOVE_TO_LOCATION'::text) OR ((controltype)::text = 'STOCKMOVE_TO_LOCATION'::text))
115. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2 (cost=7.34..7.39 rows=1 width=1,539) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Group (cost=7.34..7.38 rows=1 width=1,597) (never executed)

  • Group Key: rsk_3.transportunit_id, rsk_3.transportunit_type, rsk_3.parent_transportunit_type, rsk_3.location_id, loc_3.id, rsk_3.carrier_id, rsk_3.stock_id, rsk_3.stock_blockreason, rsk_3.stock_quantity, rsk_3.stock_gendate, rsk_3.stock_expdate, rsk_3.stock_proddate, rsk_3.stock_lotcode, rsk_3.articlepackage_id, rsk_3.articlepackage_qty
117. 0.000 0.000 ↓ 0.0 0

Sort (cost=7.34..7.34 rows=1 width=1,541) (never executed)

  • Sort Key: rsk_3.transportunit_id, rsk_3.transportunit_type, rsk_3.parent_transportunit_type, loc_3.id, rsk_3.carrier_id, rsk_3.stock_id, rsk_3.stock_blockreason, rsk_3.stock_quantity, rsk_3.stock_gendate, rsk_3.stock_expdate, rsk_3.stock_proddate, rsk_3.stock_lotcode, rsk_3.articlepackage_id, rsk_3.articlepackage_qty
118. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..7.33 rows=1 width=1,541) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..4.67 rows=1 width=1,541) (never executed)

120. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte_recursive_stockkeepables rsk_3 (cost=0.00..2.02 rows=1 width=1,516) (never executed)

  • Filter: (carrier_id IS NULL)