explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aynN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather Motion 18:1 (slice21; segments: 18) (cost=0.00..16,278.33 rows=23 width=86) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..16,278.32 rows=2 width=86) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 21:0) (cost=0.00..0.00 rows=1 width=1) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..0.00 rows=1 width=1) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=1 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=1 width=1) (actual rows= loops=)

  • One-Time Filter: (gp_execution_segment() = 1)
7. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=1 width=1) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=1 width=1) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..16,278.32 rows=2 width=86) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 21:1) (cost=0.00..431.00 rows=1 width=1) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..431.00 rows=1 width=1) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 21:0) (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..15,847.32 rows=2 width=86) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 21:2) (cost=0.00..431.00 rows=1 width=1) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..431.00 rows=1 width=1) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 21:0) (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Result (cost=0.00..15,416.32 rows=2 width=86) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..15,416.32 rows=2 width=278) (actual rows= loops=)

  • Hash Cond: (lpad(((logistics_outfit.customer_id)::character varying)::text, 9, '0'::text) = (reference30_contragents._code)::text)
21. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..14,985.32 rows=2 width=178) (actual rows= loops=)

  • Hash Cond: ((logistics_outfit.status_id)::integer = logistics_outfitstatuses.status_id)
22. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice19; segments: 18) (cost=0.00..14,554.31 rows=2 width=148) (actual rows= loops=)

  • Hash Key: (logistics_outfit.status_id)::integer
23. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..14,554.31 rows=2 width=148) (actual rows= loops=)

  • Join Filter: true
24. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice18; segments: 18) (cost=0.00..14,493.56 rows=1 width=128) (actual rows= loops=)

  • Hash Key: logistics_branchoffice_3.region_id
25. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..14,493.56 rows=1 width=128) (actual rows= loops=)

  • Hash Cond: (logistics_outfit.office_id = logistics_branchoffice_3.office_id)
26. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice17; segments: 18) (cost=0.00..13,630.64 rows=1 width=82) (actual rows= loops=)

  • Hash Key: logistics_outfit.office_id
27. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..13,630.64 rows=1 width=82) (actual rows= loops=)

  • Join Filter: true
28. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice16; segments: 18) (cost=0.00..13,612.64 rows=1 width=40) (actual rows= loops=)

  • Hash Key: logistics_outfit.poo_id
29. 0.000 0.000 ↓ 0.0

Result (cost=0.00..13,612.64 rows=1 width=40) (actual rows= loops=)

  • Filter: (((COALESCE(positions_changes.first_date, positions_changes.ddate)) = '2020-01-29'::date) OR (logistics_outfittransferinoffice.dt = '2020-01-29 00:00:00'::timestamp without time zone))
30. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..13,595.56 rows=259,665 width=40) (actual rows= loops=)

  • Hash Cond: ((logistics_outfit.outfit_id = logistics_torgdetail.outfit_id) AND (logistics_outfit.office_id = logistics_outfittransferinoffice.office_id))
31. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..7,759.75 rows=259,665 width=28) (actual rows= loops=)

  • Hash Cond: ((logistics_outfit.outfit_id)::bigint = positions_changes.outfit_id)
32. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=0.00..6,744.57 rows=259,665 width=24) (actual rows= loops=)

  • Hash Cond: (logistics_outfit.office_id = logistics_poo.office_id)
33. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..4,938.70 rows=259,894 width=27) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Partition Selector for logistics_outfit (dynamic scan id: 1) (cost=10.00..100.00 rows=6 width=4) (actual rows= loops=)

  • Partitions selected: 85 (out of 85)
35. 0.000 0.000 ↓ 0.0

Dynamic Seq Scan on logistics_outfit (dynamic scan id: 1) (cost=0.00..4,938.70 rows=259,894 width=27) (actual rows= loops=)

  • Filter: ((sm_id = 6) AND (NOT is_refund) AND (status_id <> ALL ('{1,20,18}'::integer[])))
36. 0.000 0.000 ↓ 0.0

Hash (cost=1,732.02..1,732.02 rows=16,054 width=4) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Broadcast Motion 18:18 (slice4; segments: 18) (cost=0.00..1,732.02 rows=16,054 width=4) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,731.75 rows=892 width=4) (actual rows= loops=)

  • Group Key: logistics_poo.office_id
39. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,731.65 rows=892 width=4) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..438.27 rows=439 width=4) (actual rows= loops=)

  • Group Key: logistics_poo.office_id
41. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice2; segments: 18) (cost=0.00..438.21 rows=440 width=4) (actual rows= loops=)

  • Hash Key: logistics_poo.office_id
42. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..438.21 rows=440 width=4) (actual rows= loops=)

  • Join Filter: true
43. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Group Key: share1_ref4.poo_id
44. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Sort Key: share1_ref4.poo_id
45. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice1; segments: 18) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Hash Key: share1_ref4.poo_id
46. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 1:1) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Index Scan using stage_erp_logistics_poo_poo_id_idx on logistics_poo (cost=0.00..7.20 rows=440 width=4) (actual rows= loops=)

  • Index Cond: (poo_id = share1_ref4.poo_id)
  • Filter: (NOT (office_id IS NULL))
48. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,293.38 rows=454 width=4) (actual rows= loops=)

  • Group Key: logistics_branchoffice.office_id
49. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,293.32 rows=454 width=4) (actual rows= loops=)

  • Hash Cond: (logistics_branchoffice.office_id = logistics_branch_office.office_id)
50. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=0.00..862.23 rows=454 width=4) (actual rows= loops=)

  • Hash Cond: (logistics_branchoffice.region_id = share2_ref4.region_id)
51. 0.000 0.000 ↓ 0.0

Seq Scan on logistics_branchoffice (cost=0.00..431.14 rows=454 width=8) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=4) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Broadcast Motion 18:18 (slice3; segments: 18) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 3:2) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=4) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Seq Scan on logistics_branch_office (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Hash (cost=940.81..940.81 rows=1 width=12) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Broadcast Motion 18:18 (slice5; segments: 18) (cost=0.00..940.81 rows=1 width=12) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Result (cost=0.00..940.81 rows=1 width=12) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Result (cost=0.00..940.81 rows=1 width=12) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..940.81 rows=1 width=16) (actual rows= loops=)

  • Group Key: positions_changes.rid, positions_changes.outfit_id, positions_changes.first_date, positions_changes.ddate
62. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..940.81 rows=1 width=24) (actual rows= loops=)

  • Sort Key: positions_changes.rid, positions_changes.outfit_id, positions_changes.first_date, positions_changes.ddate
63. 0.000 0.000 ↓ 0.0

Append (cost=0.00..940.81 rows=1 width=24) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..490.78 rows=277,280 width=24) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Partition Selector for positions_changes (dynamic scan id: 2) (cost=10.00..100.00 rows=6 width=4) (actual rows= loops=)

  • Partitions selected: 16 (out of 16)
66. 0.000 0.000 ↓ 0.0

Dynamic Seq Scan on positions_changes (dynamic scan id: 2) (cost=0.00..490.78 rows=277,280 width=24) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.00 rows=1 width=24) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..431.00 rows=1 width=20) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Partition Selector for hist_cc_positions (dynamic scan id: 3) (cost=10.00..100.00 rows=6 width=4) (actual rows= loops=)

  • Partitions selected: 44 (out of 44)
70. 0.000 0.000 ↓ 0.0

Dynamic Seq Scan on hist_cc_positions (dynamic scan id: 3) (cost=0.00..431.00 rows=1 width=20) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Hash (cost=5,704.76..5,704.76 rows=1 width=20) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice15; segments: 18) (cost=0.00..5,704.76 rows=1 width=20) (actual rows= loops=)

  • Hash Key: logistics_torgdetail.outfit_id
73. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..5,704.76 rows=1 width=20) (actual rows= loops=)

  • Hash Cond: (logistics_poo_1.office_id = logistics_outfittransferinoffice.office_id)
74. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,731.75 rows=892 width=4) (actual rows= loops=)

  • Group Key: logistics_poo_1.office_id
75. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,731.65 rows=892 width=4) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..438.27 rows=439 width=4) (actual rows= loops=)

  • Group Key: logistics_poo_1.office_id
77. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice7; segments: 18) (cost=0.00..438.21 rows=440 width=4) (actual rows= loops=)

  • Hash Key: logistics_poo_1.office_id
78. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..438.21 rows=440 width=4) (actual rows= loops=)

  • Join Filter: true
79. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Group Key: share1_ref3.poo_id
80. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Sort Key: share1_ref3.poo_id
81. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice6; segments: 18) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Hash Key: share1_ref3.poo_id
82. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 6:1) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Index Scan using stage_erp_logistics_poo_poo_id_idx on logistics_poo logistics_poo_1 (cost=0.00..7.20 rows=440 width=4) (actual rows= loops=)

  • Index Cond: (poo_id = share1_ref3.poo_id)
  • Filter: (NOT (office_id IS NULL))
84. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,293.38 rows=454 width=4) (actual rows= loops=)

  • Group Key: logistics_branchoffice_1.office_id
85. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,293.32 rows=454 width=4) (actual rows= loops=)

  • Hash Cond: (logistics_branchoffice_1.office_id = logistics_branch_office_1.office_id)
86. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=0.00..862.23 rows=454 width=4) (actual rows= loops=)

  • Hash Cond: (logistics_branchoffice_1.region_id = share2_ref3.region_id)
87. 0.000 0.000 ↓ 0.0

Seq Scan on logistics_branchoffice logistics_branchoffice_1 (cost=0.00..431.14 rows=454 width=8) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=4) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Broadcast Motion 18:18 (slice8; segments: 18) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 8:2) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=4) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Seq Scan on logistics_branch_office logistics_branch_office_1 (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Hash (cost=3,972.85..3,972.85 rows=1 width=20) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Broadcast Motion 18:18 (slice14; segments: 18) (cost=0.00..3,972.85 rows=1 width=20) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,972.85 rows=1 width=20) (actual rows= loops=)

  • Hash Cond: (logistics_outfittransferinoffice.transfer_id = logistics_torgdetail.transfer_box_id)
96. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..732.53 rows=688,154 width=16) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Partition Selector for logistics_outfittransferinoffice (dynamic scan id: 4) (cost=10.00..100.00 rows=6 width=4) (actual rows= loops=)

  • Partitions selected: 23 (out of 23)
98. 0.000 0.000 ↓ 0.0

Dynamic Seq Scan on logistics_outfittransferinoffice (dynamic scan id: 4) (cost=0.00..732.53 rows=688,154 width=16) (actual rows= loops=)

  • Filter: (dt >= '2020-01-29 00:00:00'::timestamp without time zone)
99. 0.000 0.000 ↓ 0.0

Hash (cost=3,114.01..3,114.01 rows=1 width=8) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,114.01 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: (logistics_outfittransferinoffice_1.transfer_id = logistics_torgdetail.transfer_box_id)
101. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..2,683.00 rows=56 width=4) (actual rows= loops=)

  • Group Key: logistics_outfittransferinoffice_1.transfer_id
102. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=0.00..2,600.19 rows=687,549 width=4) (actual rows= loops=)

  • Hash Cond: (logistics_outfittransferinoffice_1.office_id = logistics_poo_2.office_id)
103. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..732.53 rows=688,154 width=16) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Partition Selector for logistics_outfittransferinoffice (dynamic scan id: 6) (cost=10.00..100.00 rows=6 width=4) (actual rows= loops=)

  • Partitions selected: 23 (out of 23)
105. 0.000 0.000 ↓ 0.0

Dynamic Seq Scan on logistics_outfittransferinoffice logistics_outfittransferinoffice_1 (dynamic scan id: 6) (cost=0.00..732.53 rows=688,154 width=16) (actual rows= loops=)

  • Filter: (dt >= '2020-01-29 00:00:00'::timestamp without time zone)
106. 0.000 0.000 ↓ 0.0

Hash (cost=1,732.02..1,732.02 rows=16,054 width=4) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Broadcast Motion 18:18 (slice12; segments: 18) (cost=0.00..1,732.02 rows=16,054 width=4) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,731.75 rows=892 width=4) (actual rows= loops=)

  • Group Key: logistics_poo_2.office_id
109. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,731.65 rows=892 width=4) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..438.27 rows=439 width=4) (actual rows= loops=)

  • Group Key: logistics_poo_2.office_id
111. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice10; segments: 18) (cost=0.00..438.21 rows=440 width=4) (actual rows= loops=)

  • Hash Key: logistics_poo_2.office_id
112. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..438.21 rows=440 width=4) (actual rows= loops=)

  • Join Filter: true
113. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Group Key: share1_ref2.poo_id
114. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Sort Key: share1_ref2.poo_id
115. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice9; segments: 18) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Hash Key: share1_ref2.poo_id
116. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 9:1) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Index Scan using stage_erp_logistics_poo_poo_id_idx on logistics_poo logistics_poo_2 (cost=0.00..7.20 rows=440 width=4) (actual rows= loops=)

  • Index Cond: (poo_id = share1_ref2.poo_id)
  • Filter: (NOT (office_id IS NULL))
118. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,293.38 rows=454 width=4) (actual rows= loops=)

  • Group Key: logistics_branchoffice_2.office_id
119. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,293.32 rows=454 width=4) (actual rows= loops=)

  • Hash Cond: (logistics_branchoffice_2.office_id = logistics_branch_office_2.office_id)
120. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=0.00..862.23 rows=454 width=4) (actual rows= loops=)

  • Hash Cond: (logistics_branchoffice_2.region_id = share2_ref2.region_id)
121. 0.000 0.000 ↓ 0.0

Seq Scan on logistics_branchoffice logistics_branchoffice_2 (cost=0.00..431.14 rows=454 width=8) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=4) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Broadcast Motion 18:18 (slice11; segments: 18) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 11:2) (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=4) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Seq Scan on logistics_branch_office logistics_branch_office_2 (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=8) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Redistribute Motion 18:18 (slice13; segments: 18) (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

  • Hash Key: logistics_torgdetail.transfer_box_id
129. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

  • Group Key: logistics_torgdetail.transfer_box_id, logistics_torgdetail.outfit_id
130. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

  • Sort Key: logistics_torgdetail.transfer_box_id, logistics_torgdetail.outfit_id
131. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

Partition Selector for logistics_torgdetail (dynamic scan id: 5) (cost=10.00..100.00 rows=6 width=4) (actual rows= loops=)

  • Partitions selected: 64 (out of 64)
133. 0.000 0.000 ↓ 0.0

Dynamic Seq Scan on logistics_torgdetail (dynamic scan id: 5) (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Index Scan using stage_erp_logistics_poo_poo_id_idx on logistics_poo logistics_poo_3 (cost=0.00..18.00 rows=1 width=42) (actual rows= loops=)

  • Index Cond: (poo_id = logistics_outfit.poo_id)
135. 0.000 0.000 ↓ 0.0

Hash (cost=862.35..862.35 rows=454 width=50) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..862.35 rows=454 width=50) (actual rows= loops=)

  • Hash Cond: (logistics_branchoffice_3.office_id = logistics_branch_office_3.office_id)
137. 0.000 0.000 ↓ 0.0

Seq Scan on logistics_branchoffice logistics_branchoffice_3 (cost=0.00..431.14 rows=454 width=50) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=4) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Seq Scan on logistics_branch_office logistics_branch_office_3 (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Index Scan using stage_erp_logistics_region_region_id_idx on logistics_region (cost=0.00..60.76 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (region_id = logistics_branchoffice_3.region_id)
141. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=2 width=34) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Seq Scan on logistics_outfitstatuses (cost=0.00..431.00 rows=2 width=34) (actual rows= loops=)

  • Filter: ((status_id < 1) OR ((status_id > 1) AND (status_id < 18)) OR ((status_id > 18) AND (status_id < 20)) OR (status_id > 20))
143. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=108) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Broadcast Motion 18:18 (slice20; segments: 18) (cost=0.00..431.00 rows=1 width=108) (actual rows= loops=)

  • -> Seq Scan on reference30_contragents (cost=0.00..431.00 rows=1 width=108)Optimizer: Pivotal Optimizer (GPORCA) version 3.86.0