explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7yk : Optimization for: plan #Mc88

Settings

Optimization path:

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

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

2. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..13,296.15 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=8) (actual rows= loops=)

  • One-Time Filter: (gp_execution_segment() = 17)
6. 0.000 0.000 ↓ 0.0

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

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..13,296.14 rows=2 width=86) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

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

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

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

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

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

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

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

  • Join Filter: true
13. 0.000 0.000 ↓ 0.0

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

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

Nested Loop Left Join (cost=0.00..12,373.38 rows=1 width=128) (actual rows= loops=)

  • Join Filter: true
15. 0.000 0.000 ↓ 0.0

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

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

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

  • Join Filter: true
17. 0.000 0.000 ↓ 0.0

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

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

Result (cost=0.00..12,319.38 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))
19. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..12,302.30 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))
20. 0.000 0.000 ↓ 0.0

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

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

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

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

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

23. 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)
24. 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[])))
25. 0.000 0.000 ↓ 0.0

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

26. 0.000 0.000 ↓ 0.0

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

27. 0.000 0.000 ↓ 0.0

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

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

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

29. 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
30. 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
31. 0.000 0.000 ↓ 0.0

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

  • Join Filter: true
32. 0.000 0.000 ↓ 0.0

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

  • Group Key: share0_ref6.poo_id
33. 0.000 0.000 ↓ 0.0

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

  • Sort Key: share0_ref6.poo_id
34. 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: share0_ref6.poo_id
35. 0.000 0.000 ↓ 0.0

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

36. 0.000 0.000 ↓ 0.0

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

37. 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 = share0_ref6.poo_id)
  • Filter: (NOT (office_id IS NULL))
38. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..862.29 rows=454 width=4) (actual rows= loops=)

  • Group Key: logistics_branchoffice.office_id
39. 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 = share0_ref7.region_id)
40. 0.000 0.000 ↓ 0.0

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

41. 0.000 0.000 ↓ 0.0

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

42. 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=)

43. 0.000 0.000 ↓ 0.0

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

44. 0.000 0.000 ↓ 0.0

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

45. 0.000 0.000 ↓ 0.0

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

46. 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=)

47. 0.000 0.000 ↓ 0.0

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

48. 0.000 0.000 ↓ 0.0

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

49. 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
50. 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
51. 0.000 0.000 ↓ 0.0

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

52. 0.000 0.000 ↓ 0.0

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

53. 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)
54. 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=)

55. 0.000 0.000 ↓ 0.0

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

56. 0.000 0.000 ↓ 0.0

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

57. 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)
58. 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=)

59. 0.000 0.000 ↓ 0.0

Hash (cost=4,842.59..4,842.59 rows=1 width=20) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

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

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

Hash Join (cost=0.00..4,842.59 rows=1 width=20) (actual rows= loops=)

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

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

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

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

64. 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
65. 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
66. 0.000 0.000 ↓ 0.0

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

  • Join Filter: true
67. 0.000 0.000 ↓ 0.0

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

  • Group Key: share0_ref4.poo_id
68. 0.000 0.000 ↓ 0.0

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

  • Sort Key: share0_ref4.poo_id
69. 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: share0_ref4.poo_id
70. 0.000 0.000 ↓ 0.0

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

71. 0.000 0.000 ↓ 0.0

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

72. 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 = share0_ref4.poo_id)
  • Filter: (NOT (office_id IS NULL))
73. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..862.29 rows=454 width=4) (actual rows= loops=)

  • Group Key: logistics_branchoffice_1.office_id
74. 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 = share0_ref5.region_id)
75. 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=)

76. 0.000 0.000 ↓ 0.0

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

77. 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=)

78. 0.000 0.000 ↓ 0.0

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

79. 0.000 0.000 ↓ 0.0

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

80. 0.000 0.000 ↓ 0.0

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

81. 0.000 0.000 ↓ 0.0

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

82. 0.000 0.000 ↓ 0.0

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

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

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

84. 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)
85. 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)
86. 0.000 0.000 ↓ 0.0

Hash (cost=2,682.93..2,682.93 rows=1 width=8) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,682.93 rows=1 width=8) (actual rows= loops=)

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

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

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

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

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

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

91. 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)
92. 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)
93. 0.000 0.000 ↓ 0.0

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

94. 0.000 0.000 ↓ 0.0

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

95. 0.000 0.000 ↓ 0.0

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

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

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

97. 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
98. 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
99. 0.000 0.000 ↓ 0.0

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

  • Join Filter: true
100. 0.000 0.000 ↓ 0.0

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

  • Group Key: share0_ref2.poo_id
101. 0.000 0.000 ↓ 0.0

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

  • Sort Key: share0_ref2.poo_id
102. 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: share0_ref2.poo_id
103. 0.000 0.000 ↓ 0.0

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

104. 0.000 0.000 ↓ 0.0

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

105. 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 = share0_ref2.poo_id)
  • Filter: (NOT (office_id IS NULL))
106. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..862.29 rows=454 width=4) (actual rows= loops=)

  • Group Key: logistics_branchoffice_2.office_id
107. 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 = share0_ref3.region_id)
108. 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=)

109. 0.000 0.000 ↓ 0.0

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

110. 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=)

111. 0.000 0.000 ↓ 0.0

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

112. 0.000 0.000 ↓ 0.0

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

113. 0.000 0.000 ↓ 0.0

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

114. 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
115. 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
116. 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
117. 0.000 0.000 ↓ 0.0

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

118. 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)
119. 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=)

120. 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)
121. 0.000 0.000 ↓ 0.0

Index Scan using stage_erp_logistics_branchoffice_office_id_idx on logistics_branchoffice logistics_branchoffice_3 (cost=0.00..36.00 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (office_id = logistics_outfit.office_id)
122. 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)
123. 0.000 0.000 ↓ 0.0

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

124. 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))
125. 0.000 0.000 ↓ 0.0

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

126. 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