explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bDau : EXPLAIN ANALYZE SELECT * FROM change_notification_pending_changes_on_live_entities UNION SELECT * FROM change_notification_pending_changes_on_reactivated_entities ORDER BY rcpt_id,article_id;

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,896.215 ↓ 0.0 0 1

Unique (cost=15,422,924.19..15,801,222.60 rows=50,439,788 width=12) (actual time=2,896.215..2,896.215 rows=0 loops=1)

  • Execution Time: 2898.212 ms(1172 Zeilen)
2. 0.002 2,896.215 ↓ 0.0 0 1

Sort (cost=15,422,924.19..15,549,023.66 rows=50,439,788 width=12) (actual time=2,896.215..2,896.215 rows=0 loops=1)

  • Sort Key: cns.rcpt_id, cns.article_id
  • Sort Method: quicksort Memory: 25kB
3. 0.001 2,896.213 ↓ 0.0 0 1

Append (cost=103,111.89..7,245,619.86 rows=50,439,788 width=12) (actual time=2,896.213..2,896.213 rows=0 loops=1)

4. 4.088 124.649 ↓ 0.0 0 1

Hash Join (cost=103,111.89..4,228,541.43 rows=50,005,031 width=12) (actual time=124.649..124.649 rows=0 loops=1)

  • Hash Cond: (l1.article_id = r.article_id)
  • Join Filter: (l1.total_pub_dt > cns.last_seen_dt)
  • Rows Removed by Join Filter: 30080
5. 0.143 46.466 ↑ 12,551.3 3,008 1

Append (cost=86,027.15..1,675,567.74 rows=37,754,302 width=16) (actual time=23.020..46.466 rows=3,008 loops=1)

6.          

CTE lnot1

7. 0.035 16.992 ↑ 4.8 550 1

Subquery Scan on article_live_items2 (cost=5,980.21..6,065.62 rows=2,662 width=16) (actual time=16.556..16.992 rows=550 loops=1)

8. 0.405 16.957 ↑ 4.8 550 1

Merge Join (cost=5,980.21..6,039.00 rows=2,662 width=767) (actual time=16.555..16.957 rows=550 loops=1)

  • Merge Cond: (base_p_14.packaging_id = tmp_pkg_li_2.packaging_id)
9.          

CTE tmp_d_li1

10. 0.005 0.042 ↑ 1.4 22 1

Hash Join (cost=3.89..8.74 rows=31 width=12) (actual time=0.029..0.042 rows=22 loops=1)

  • Hash Cond: (e_8.live_distributor_base_prop_id = base_p_8.distributor_base_prop_id)
11. 0.009 0.026 ↑ 1.4 22 1

Hash Join (cost=1.70..6.38 rows=31 width=28) (actual time=0.015..0.026 rows=22 loops=1)

  • Hash Cond: (label_p_8.distributor_label_prop_id = e_8.live_distributor_label_prop_id)
12. 0.007 0.007 ↑ 1.0 53 1

Seq Scan on distributor_label_props label_p_8 (cost=0.00..4.53 rows=53 width=8) (actual time=0.002..0.007 rows=53 loops=1)

13. 0.004 0.010 ↑ 1.4 22 1

Hash (cost=1.31..1.31 rows=31 width=36) (actual time=0.009..0.010 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.006 0.006 ↑ 1.0 31 1

Seq Scan on distributors e_8 (cost=0.00..1.31 rows=31 width=36) (actual time=0.003..0.006 rows=31 loops=1)

15. 0.005 0.011 ↑ 1.0 53 1

Hash (cost=1.53..1.53 rows=53 width=8) (actual time=0.011..0.011 rows=53 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
16. 0.006 0.006 ↑ 1.0 53 1

Seq Scan on distributor_base_props base_p_8 (cost=0.00..1.53 rows=53 width=8) (actual time=0.003..0.006 rows=53 loops=1)

17.          

CTE tmp_p_li

18. 0.057 3.490 ↑ 1.5 895 1

Subquery Scan on product_live_items_1 (cost=773.94..1,265.42 rows=1,310 width=12) (actual time=2.385..3.490 rows=895 loops=1)

19. 0.368 3.433 ↑ 1.5 895 1

Hash Join (cost=773.94..1,252.32 rows=1,310 width=828) (actual time=2.384..3.433 rows=895 loops=1)

  • Hash Cond: (e_10.live_product_econtent_prop_id = econtent_p_1.product_econtent_prop_id)
20.          

CTE tmp_li1

21. 0.054 0.280 ↑ 1.4 188 1

Hash Join (cost=45.19..82.95 rows=270 width=12) (actual time=0.182..0.280 rows=188 loops=1)

  • Hash Cond: (label_p_9.brand_label_prop_id = e_9.live_brand_label_prop_id)
22. 0.050 0.050 ↓ 1.0 462 1

Seq Scan on brand_label_props label_p_9 (cost=0.00..33.54 rows=454 width=8) (actual time=0.003..0.050 rows=462 loops=1)

23. 0.019 0.176 ↑ 1.4 188 1

Hash (cost=41.82..41.82 rows=270 width=28) (actual time=0.176..0.176 rows=188 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
24. 0.046 0.157 ↑ 1.4 188 1

Hash Join (cost=10.07..41.82 rows=270 width=28) (actual time=0.064..0.157 rows=188 loops=1)

  • Hash Cond: (base_p_9.brand_base_prop_id = e_9.live_brand_base_prop_id)
25. 0.054 0.054 ↓ 1.0 462 1

Seq Scan on brand_base_props base_p_9 (cost=0.00..30.54 rows=454 width=8) (actual time=0.003..0.054 rows=462 loops=1)

26. 0.022 0.057 ↑ 1.4 188 1

Hash (cost=6.70..6.70 rows=270 width=36) (actual time=0.057..0.057 rows=188 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
27. 0.035 0.035 ↓ 1.0 274 1

Seq Scan on brands e_9 (cost=0.00..6.70 rows=270 width=36) (actual time=0.003..0.035 rows=274 loops=1)

28. 0.149 2.653 ↑ 1.5 895 1

Hash Join (cost=424.20..892.59 rows=1,310 width=52) (actual time=1.967..2.653 rows=895 loops=1)

  • Hash Cond: (e_10.live_product_label_prop_id = label_p_10.product_label_prop_id)
29. 0.261 2.129 ↑ 1.5 895 1

Hash Join (cost=307.62..772.57 rows=1,310 width=60) (actual time=1.588..2.129 rows=895 loops=1)

  • Hash Cond: (sr_p_3.product_sr_prop_id = e_10.live_product_sr_prop_id)
30. 0.287 0.287 ↑ 1.0 2,283 1

Seq Scan on product_sr_props sr_p_3 (cost=0.00..446.83 rows=2,283 width=8) (actual time=0.002..0.287 rows=2,283 loops=1)

31. 0.107 1.581 ↑ 1.5 895 1

Hash (cost=291.24..291.24 rows=1,310 width=68) (actual time=1.581..1.581 rows=895 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 107kB
32. 0.135 1.474 ↑ 1.5 895 1

Hash Join (cost=254.52..291.24 rows=1,310 width=68) (actual time=1.216..1.474 rows=895 loops=1)

  • Hash Cond: (tmp_li1_1.brand_id = base_p_10.brand_id)
33. 0.308 0.308 ↑ 1.4 188 1

CTE Scan on tmp_li1 tmp_li1_1 (cost=0.00..5.40 rows=270 width=12) (actual time=0.182..0.308 rows=188 loops=1)

34. 0.115 1.031 ↑ 1.4 922 1

Hash (cost=238.02..238.02 rows=1,320 width=64) (actual time=1.031..1.031 rows=922 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 107kB
35. 0.249 0.916 ↑ 1.4 922 1

Hash Join (cost=83.70..238.02 rows=1,320 width=64) (actual time=0.383..0.916 rows=922 loops=1)

  • Hash Cond: (base_p_10.product_base_prop_id = e_10.live_product_base_prop_id)
36. 0.290 0.290 ↑ 1.0 2,242 1

Seq Scan on product_base_props base_p_10 (cost=0.00..148.42 rows=2,242 width=12) (actual time=0.003..0.290 rows=2,242 loops=1)

37. 0.125 0.377 ↑ 1.4 922 1

Hash (cost=67.20..67.20 rows=1,320 width=68) (actual time=0.377..0.377 rows=922 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 110kB
38. 0.252 0.252 ↑ 1.0 1,320 1

Seq Scan on products e_10 (cost=0.00..67.20 rows=1,320 width=68) (actual time=0.002..0.252 rows=1,320 loops=1)

39. 0.159 0.375 ↑ 1.0 2,248 1

Hash (cost=88.48..88.48 rows=2,248 width=8) (actual time=0.375..0.375 rows=2,248 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 120kB
40. 0.216 0.216 ↑ 1.0 2,248 1

Seq Scan on product_label_props label_p_10 (cost=0.00..88.48 rows=2,248 width=8) (actual time=0.003..0.216 rows=2,248 loops=1)

41. 0.160 0.412 ↑ 1.0 2,242 1

Hash (cost=238.77..238.77 rows=2,242 width=8) (actual time=0.412..0.412 rows=2,242 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 120kB
42. 0.252 0.252 ↑ 1.0 2,242 1

Index Only Scan using product_econtent_props_pkey on product_econtent_props econtent_p_1 (cost=0.28..238.77 rows=2,242 width=8) (actual time=0.005..0.252 rows=2,242 loops=1)

  • Heap Fetches: 610
43.          

CTE tmp_pkg_li

44. 0.147 4.680 ↑ 3.0 986 1

Hash Join (cost=1,211.40..1,367.30 rows=2,935 width=12) (actual time=2.438..4.680 rows=986 loops=1)

  • Hash Cond: (e_13.live_packaging_tech_prop_id = tech_p_7.packaging_tech_prop_id)
45. 0.145 4.227 ↑ 3.0 986 1

Hash Join (cost=1,144.11..1,292.29 rows=2,935 width=20) (actual time=2.128..4.227 rows=986 loops=1)

  • Hash Cond: (e_13.live_packaging_label_prop_id = label_p_13.packaging_label_prop_id)
46. 0.163 3.714 ↑ 3.0 986 1

Hash Join (cost=973.81..1,114.28 rows=2,935 width=28) (actual time=1.756..3.714 rows=986 loops=1)

  • Hash Cond: (e_13.live_packaging_base_prop_id = base_p_13.packaging_base_prop_id)
47. 0.186 3.222 ↑ 2.6 1,116 1

Hash Right Join (cost=845.52..978.27 rows=2,935 width=36) (actual time=1.423..3.222 rows=1,116 loops=1)

  • Hash Cond: (l1_5.packaging_id = e_13.packaging_id)
48. 0.054 2.784 ↑ 3.0 986 1

Append (cost=779.41..875.07 rows=2,935 width=16) (actual time=1.167..2.784 rows=986 loops=1)

49.          

CTE lnot1

50. 0.006 0.812 ↑ 1.1 156 1

Nested Loop (cost=163.36..294.79 rows=166 width=16) (actual time=0.450..0.812 rows=156 loops=1)

51. 0.124 0.650 ↑ 1.1 156 1

Hash Join (cost=163.08..213.46 rows=166 width=40) (actual time=0.444..0.650 rows=156 loops=1)

  • Hash Cond: (tech_p_5.packaging_tech_prop_id = e_11.live_packaging_tech_prop_id)
52. 0.132 0.132 ↑ 1.0 2,102 1

Seq Scan on packaging_tech_props tech_p_5 (cost=0.00..41.02 rows=2,102 width=8) (actual time=0.002..0.132 rows=2,102 loops=1)

53. 0.019 0.394 ↑ 1.1 156 1

Hash (cost=161.01..161.01 rows=166 width=48) (actual time=0.394..0.394 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
54. 0.073 0.375 ↑ 1.1 156 1

Hash Join (cost=105.92..161.01 rows=166 width=48) (actual time=0.313..0.375 rows=156 loops=1)

  • Hash Cond: (e_11.live_packaging_base_prop_id = base_p_11.packaging_base_prop_id)
55. 0.152 0.152 ↑ 1.0 1,116 1

Seq Scan on packagings e_11 (cost=0.00..52.16 rows=1,116 width=52) (actual time=0.002..0.152 rows=1,116 loops=1)

56. 0.025 0.150 ↑ 1.0 312 1

Hash (cost=102.02..102.02 rows=312 width=12) (actual time=0.150..0.150 rows=312 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
57. 0.125 0.125 ↑ 1.0 312 1

Seq Scan on packaging_base_props base_p_11 (cost=0.00..102.02 rows=312 width=12) (actual time=0.005..0.125 rows=312 loops=1)

  • Filter: (based_on_packaging_id IS NOT NULL)
  • Rows Removed by Filter: 1790
58. 0.156 0.156 ↑ 1.0 1 156

Index Only Scan using packaging_label_props_pkey on packaging_label_props label_p_11 (cost=0.28..0.49 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=156)

  • Index Cond: (packaging_label_prop_id = e_11.live_packaging_label_prop_id)
  • Heap Fetches: 156
59.          

CTE l1

60. 0.247 1.522 ↑ 1.1 830 1

Hash Join (cost=251.86..414.53 rows=950 width=12) (actual time=1.165..1.522 rows=830 loops=1)

  • Hash Cond: (label_p_12.packaging_label_prop_id = e_12.live_packaging_label_prop_id)
61. 0.121 0.121 ↑ 1.0 2,102 1

Seq Scan on packaging_label_props label_p_12 (cost=0.00..144.02 rows=2,102 width=8) (actual time=0.001..0.121 rows=2,102 loops=1)

62. 0.088 1.154 ↑ 1.1 830 1

Hash (cost=239.98..239.98 rows=950 width=36) (actual time=1.154..1.154 rows=830 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 67kB
63. 0.129 1.066 ↑ 1.1 830 1

Hash Join (cost=190.50..239.98 rows=950 width=36) (actual time=0.587..1.066 rows=830 loops=1)

  • Hash Cond: (e_12.live_packaging_base_prop_id = base_p_12.packaging_base_prop_id)
64. 0.218 0.631 ↑ 1.1 986 1

Hash Join (cost=66.11..112.66 rows=1,116 width=44) (actual time=0.278..0.631 rows=986 loops=1)

  • Hash Cond: (tech_p_6.packaging_tech_prop_id = e_12.live_packaging_tech_prop_id)
65. 0.141 0.141 ↑ 1.0 2,102 1

Seq Scan on packaging_tech_props tech_p_6 (cost=0.00..41.02 rows=2,102 width=8) (actual time=0.002..0.141 rows=2,102 loops=1)

66. 0.117 0.272 ↑ 1.1 986 1

Hash (cost=52.16..52.16 rows=1,116 width=52) (actual time=0.272..0.272 rows=986 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 101kB
67. 0.155 0.155 ↑ 1.0 1,116 1

Seq Scan on packagings e_12 (cost=0.00..52.16 rows=1,116 width=52) (actual time=0.002..0.155 rows=1,116 loops=1)

68. 0.130 0.306 ↑ 1.0 1,790 1

Hash (cost=102.02..102.02 rows=1,790 width=8) (actual time=0.306..0.306 rows=1,790 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 86kB
69. 0.176 0.176 ↑ 1.0 1,790 1

Seq Scan on packaging_base_props base_p_12 (cost=0.00..102.02 rows=1,790 width=8) (actual time=0.002..0.176 rows=1,790 loops=1)

  • Filter: (based_on_packaging_id IS NULL)
  • Rows Removed by Filter: 312
70.          

CTE l2

71. 0.063 0.964 ↑ 7.2 110 1

Hash Join (cost=5.40..37.81 rows=788 width=12) (actual time=0.863..0.964 rows=110 loops=1)

  • Hash Cond: (l1_4.packaging_id = x_5.based_on_packaging_id)
72. 0.043 0.043 ↑ 1.1 830 1

CTE Scan on l1 l1_4 (cost=0.00..19.00 rows=950 width=12) (actual time=0.000..0.043 rows=830 loops=1)

73. 0.017 0.858 ↑ 1.1 156 1

Hash (cost=3.32..3.32 rows=166 width=16) (actual time=0.858..0.858 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
74. 0.841 0.841 ↑ 1.1 156 1

CTE Scan on lnot1 x_5 (cost=0.00..3.32 rows=166 width=16) (actual time=0.450..0.841 rows=156 loops=1)

75.          

CTE l3

76. 0.015 0.039 ↑ 15.2 43 1

Hash Join (cost=5.40..32.28 rows=654 width=12) (actual time=0.023..0.039 rows=43 loops=1)

  • Hash Cond: (l2_4.packaging_id = x_6.based_on_packaging_id)
77. 0.006 0.006 ↑ 7.2 110 1

CTE Scan on l2 l2_4 (cost=0.00..15.76 rows=788 width=12) (actual time=0.000..0.006 rows=110 loops=1)

78. 0.010 0.018 ↑ 1.1 156 1

Hash (cost=3.32..3.32 rows=166 width=16) (actual time=0.018..0.018 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
79. 0.008 0.008 ↑ 1.1 156 1

CTE Scan on lnot1 x_6 (cost=0.00..3.32 rows=166 width=16) (actual time=0.000..0.008 rows=156 loops=1)

80. 1.672 1.672 ↑ 1.1 830 1

CTE Scan on l1 l1_5 (cost=0.00..19.00 rows=950 width=16) (actual time=1.167..1.672 rows=830 loops=1)

81. 0.985 0.985 ↑ 7.2 110 1

CTE Scan on l2 l2_5 (cost=0.00..15.76 rows=788 width=16) (actual time=0.864..0.985 rows=110 loops=1)

82. 0.047 0.047 ↑ 15.2 43 1

CTE Scan on l3 l3_6 (cost=0.00..13.08 rows=654 width=16) (actual time=0.024..0.047 rows=43 loops=1)

83. 0.005 0.026 ↑ 181.0 3 1

Hash Join (cost=5.40..27.71 rows=543 width=16) (actual time=0.023..0.026 rows=3 loops=1)

  • Hash Cond: (l3_7.packaging_id = x_7.based_on_packaging_id)
84. 0.003 0.003 ↑ 15.2 43 1

CTE Scan on l3 l3_7 (cost=0.00..13.08 rows=654 width=12) (actual time=0.000..0.003 rows=43 loops=1)

85. 0.010 0.018 ↑ 1.1 156 1

Hash (cost=3.32..3.32 rows=166 width=16) (actual time=0.018..0.018 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
86. 0.008 0.008 ↑ 1.1 156 1

CTE Scan on lnot1 x_7 (cost=0.00..3.32 rows=166 width=16) (actual time=0.000..0.008 rows=156 loops=1)

87. 0.101 0.252 ↑ 1.0 1,116 1

Hash (cost=52.16..52.16 rows=1,116 width=28) (actual time=0.252..0.252 rows=1,116 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 83kB
88. 0.151 0.151 ↑ 1.0 1,116 1

Seq Scan on packagings e_13 (cost=0.00..52.16 rows=1,116 width=28) (actual time=0.002..0.151 rows=1,116 loops=1)

89. 0.150 0.329 ↑ 1.0 2,102 1

Hash (cost=102.02..102.02 rows=2,102 width=8) (actual time=0.329..0.329 rows=2,102 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 115kB
90. 0.179 0.179 ↑ 1.0 2,102 1

Seq Scan on packaging_base_props base_p_13 (cost=0.00..102.02 rows=2,102 width=8) (actual time=0.003..0.179 rows=2,102 loops=1)

91. 0.156 0.368 ↑ 1.0 2,102 1

Hash (cost=144.02..144.02 rows=2,102 width=8) (actual time=0.368..0.368 rows=2,102 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 115kB
92. 0.212 0.212 ↑ 1.0 2,102 1

Seq Scan on packaging_label_props label_p_13 (cost=0.00..144.02 rows=2,102 width=8) (actual time=0.003..0.212 rows=2,102 loops=1)

93. 0.149 0.306 ↑ 1.0 2,102 1

Hash (cost=41.02..41.02 rows=2,102 width=8) (actual time=0.306..0.306 rows=2,102 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 115kB
94. 0.157 0.157 ↑ 1.0 2,102 1

Seq Scan on packaging_tech_props tech_p_7 (cost=0.00..41.02 rows=2,102 width=8) (actual time=0.003..0.157 rows=2,102 loops=1)

95. 0.123 11.545 ↑ 1.5 550 1

Sort (cost=3,111.00..3,113.10 rows=837 width=84) (actual time=11.529..11.545 rows=550 loops=1)

  • Sort Key: base_p_14.packaging_id
  • Sort Method: quicksort Memory: 102kB
96. 0.111 11.422 ↑ 1.5 550 1

Hash Join (cost=1,369.01..3,070.37 rows=837 width=84) (actual time=9.667..11.422 rows=550 loops=1)

  • Hash Cond: (base_p_14.product_id = tmp_p_li_2.product_id)
97. 0.119 7.582 ↑ 1.1 553 1

Hash Join (cost=1,326.44..2,916.68 rows=618 width=80) (actual time=5.934..7.582 rows=553 loops=1)

  • Hash Cond: (legal_p_2.distributor_id = tmp_d_li1_2.distributor_id)
98. 0.091 7.413 ↑ 1.1 553 1

Nested Loop (cost=1,325.43..2,907.18 rows=618 width=76) (actual time=5.881..7.413 rows=553 loops=1)

99. 0.117 6.769 ↑ 1.1 553 1

Nested Loop (cost=1,325.15..1,995.90 rows=618 width=84) (actual time=5.876..6.769 rows=553 loops=1)

100. 0.500 6.099 ↑ 1.1 553 1

Hash Join (cost=1,324.87..1,537.46 rows=618 width=92) (actual time=5.870..6.099 rows=553 loops=1)

  • Hash Cond: (tech_p_8.article_tech_prop_id = e_14.live_article_tech_prop_id)
101. 0.582 0.582 ↑ 1.0 7,257 1

Seq Scan on article_tech_props tech_p_8 (cost=0.00..180.57 rows=7,257 width=8) (actual time=0.003..0.582 rows=7,257 loops=1)

102. 0.086 5.017 ↑ 1.1 553 1

Hash (cost=1,317.14..1,317.14 rows=618 width=100) (actual time=5.017..5.017 rows=553 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 82kB
103. 0.543 4.931 ↑ 1.1 553 1

Hash Join (cost=1,136.55..1,317.14 rows=618 width=100) (actual time=4.756..4.931 rows=553 loops=1)

  • Hash Cond: (wvd_p_2.article_wvd_prop_id = e_14.live_article_wvd_prop_id)
104. 0.371 0.371 ↑ 1.0 7,257 1

Seq Scan on article_wvd_props wvd_p_2 (cost=0.00..148.57 rows=7,257 width=8) (actual time=0.003..0.371 rows=7,257 loops=1)

105. 0.087 4.017 ↑ 1.1 553 1

Hash (cost=1,128.82..1,128.82 rows=618 width=108) (actual time=4.017..4.017 rows=553 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 86kB
106. 0.548 3.930 ↑ 1.1 553 1

Hash Join (cost=955.23..1,128.82 rows=618 width=108) (actual time=3.746..3.930 rows=553 loops=1)

  • Hash Cond: (legal_p_2.article_legal_prop_id = e_14.live_article_legal_prop_id)
107. 0.363 0.363 ↑ 1.0 7,257 1

Seq Scan on article_legal_props legal_p_2 (cost=0.00..141.57 rows=7,257 width=12) (actual time=0.003..0.363 rows=7,257 loops=1)

108. 0.087 3.019 ↑ 1.1 553 1

Hash (cost=947.50..947.50 rows=618 width=112) (actual time=3.019..3.019 rows=553 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 88kB
109. 0.487 2.932 ↑ 1.1 553 1

Hash Join (cost=774.91..947.50 rows=618 width=112) (actual time=2.745..2.932 rows=553 loops=1)

  • Hash Cond: (palettizing_p_2.article_palettizing_prop_id = e_14.live_article_palettizing_prop_id)
110. 0.494 0.494 ↑ 1.0 7,257 1

Seq Scan on article_palettizing_props palettizing_p_2 (cost=0.00..140.57 rows=7,257 width=8) (actual time=0.003..0.494 rows=7,257 loops=1)

111. 0.093 1.951 ↑ 1.1 553 1

Hash (cost=767.19..767.19 rows=618 width=120) (actual time=1.951..1.951 rows=553 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 93kB
112. 0.300 1.858 ↑ 1.1 553 1

Hash Join (cost=285.74..767.19 rows=618 width=120) (actual time=1.183..1.858 rows=553 loops=1)

  • Hash Cond: (e_14.live_article_base_prop_id = base_p_14.article_base_prop_id)
113. 1.309 1.309 ↑ 1.0 4,056 1

Seq Scan on articles e_14 (cost=0.00..470.80 rows=4,056 width=116) (actual time=0.003..1.309 rows=4,056 loops=1)

  • Filter: (NOT on_hold)
  • Rows Removed by Filter: 24
114. 0.096 0.249 ↑ 1.0 1,106 1

Hash (cost=271.91..271.91 rows=1,106 width=20) (actual time=0.249..0.249 rows=1,106 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 77kB
115. 0.124 0.153 ↑ 1.0 1,106 1

Bitmap Heap Scan on article_base_props base_p_14 (cost=40.85..271.91 rows=1,106 width=20) (actual time=0.034..0.153 rows=1,106 loops=1)

  • Recheck Cond: (based_on_article_id IS NOT NULL)
  • Heap Blocks: exact=19
116. 0.029 0.029 ↑ 1.0 1,106 1

Bitmap Index Scan on article_base_props_based_on_article_id_key (cost=0.00..40.58 rows=1,106 width=0) (actual time=0.029..0.029 rows=1,106 loops=1)

  • Index Cond: (based_on_article_id IS NOT NULL)
117. 0.553 0.553 ↑ 1.0 1 553

Index Only Scan using article_label_props_pkey on article_label_props label_p_14 (cost=0.28..0.74 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=553)

  • Index Cond: (article_label_prop_id = e_14.live_article_label_prop_id)
  • Heap Fetches: 553
118. 0.553 0.553 ↑ 1.0 1 553

Index Only Scan using article_sr_props_pkey on article_sr_props sr_p_4 (cost=0.28..1.47 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=553)

  • Index Cond: (article_sr_prop_id = e_14.live_article_sr_prop_id)
  • Heap Fetches: 553
119. 0.003 0.050 ↑ 1.4 22 1

Hash (cost=0.62..0.62 rows=31 width=12) (actual time=0.050..0.050 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
120. 0.047 0.047 ↑ 1.4 22 1

CTE Scan on tmp_d_li1 tmp_d_li1_2 (cost=0.00..0.62 rows=31 width=12) (actual time=0.030..0.047 rows=22 loops=1)

121. 0.080 3.729 ↑ 1.5 895 1

Hash (cost=26.20..26.20 rows=1,310 width=12) (actual time=3.729..3.729 rows=895 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 55kB
122. 3.649 3.649 ↑ 1.5 895 1

CTE Scan on tmp_p_li tmp_p_li_2 (cost=0.00..26.20 rows=1,310 width=12) (actual time=2.386..3.649 rows=895 loops=1)

123. 0.157 5.007 ↑ 2.2 1,362 1

Sort (cost=227.74..235.08 rows=2,935 width=12) (actual time=4.967..5.007 rows=1,362 loops=1)

  • Sort Key: tmp_pkg_li_2.packaging_id
  • Sort Method: quicksort Memory: 71kB
124. 4.850 4.850 ↑ 3.0 986 1

CTE Scan on tmp_pkg_li tmp_pkg_li_2 (cost=0.00..58.70 rows=2,935 width=12) (actual time=2.439..4.850 rows=986 loops=1)

125.          

CTE l1

126. 0.157 27.428 ↑ 6.0 2,458 1

Subquery Scan on article_live_items2_1 (cost=6,880.57..7,566.31 rows=14,809 width=12) (actual time=23.018..27.428 rows=2,458 loops=1)

127. 1.552 27.271 ↑ 6.0 2,458 1

Hash Join (cost=6,880.57..7,418.22 rows=14,809 width=767) (actual time=23.018..27.271 rows=2,458 loops=1)

  • Hash Cond: (tmp_pkg_li_3.packaging_id = base_p_21.packaging_id)
128.          

CTE tmp_d_li1

129. 0.006 0.043 ↑ 1.4 22 1

Hash Join (cost=3.89..8.74 rows=31 width=12) (actual time=0.029..0.043 rows=22 loops=1)

  • Hash Cond: (e_15.live_distributor_base_prop_id = base_p_15.distributor_base_prop_id)
130. 0.008 0.026 ↑ 1.4 22 1

Hash Join (cost=1.70..6.38 rows=31 width=28) (actual time=0.016..0.026 rows=22 loops=1)

  • Hash Cond: (label_p_15.distributor_label_prop_id = e_15.live_distributor_label_prop_id)
131. 0.008 0.008 ↑ 1.0 53 1

Seq Scan on distributor_label_props label_p_15 (cost=0.00..4.53 rows=53 width=8) (actual time=0.003..0.008 rows=53 loops=1)

132. 0.003 0.010 ↑ 1.4 22 1

Hash (cost=1.31..1.31 rows=31 width=36) (actual time=0.010..0.010 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
133. 0.007 0.007 ↑ 1.0 31 1

Seq Scan on distributors e_15 (cost=0.00..1.31 rows=31 width=36) (actual time=0.003..0.007 rows=31 loops=1)

134. 0.004 0.011 ↑ 1.0 53 1

Hash (cost=1.53..1.53 rows=53 width=8) (actual time=0.011..0.011 rows=53 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
135. 0.007 0.007 ↑ 1.0 53 1

Seq Scan on distributor_base_props base_p_15 (cost=0.00..1.53 rows=53 width=8) (actual time=0.003..0.007 rows=53 loops=1)

136.          

CTE tmp_p_li

137. 0.061 3.836 ↑ 1.5 895 1

Subquery Scan on product_live_items_2 (cost=773.94..1,265.42 rows=1,310 width=12) (actual time=2.413..3.836 rows=895 loops=1)

138. 0.408 3.775 ↑ 1.5 895 1

Hash Join (cost=773.94..1,252.32 rows=1,310 width=828) (actual time=2.413..3.775 rows=895 loops=1)

  • Hash Cond: (e_17.live_product_econtent_prop_id = econtent_p_2.product_econtent_prop_id)
139.          

CTE tmp_li1

140. 0.054 0.280 ↑ 1.4 188 1

Hash Join (cost=45.19..82.95 rows=270 width=12) (actual time=0.181..0.280 rows=188 loops=1)

  • Hash Cond: (label_p_16.brand_label_prop_id = e_16.live_brand_label_prop_id)
141. 0.051 0.051 ↓ 1.0 462 1

Seq Scan on brand_label_props label_p_16 (cost=0.00..33.54 rows=454 width=8) (actual time=0.002..0.051 rows=462 loops=1)

142. 0.018 0.175 ↑ 1.4 188 1

Hash (cost=41.82..41.82 rows=270 width=28) (actual time=0.175..0.175 rows=188 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
143. 0.047 0.157 ↑ 1.4 188 1

Hash Join (cost=10.07..41.82 rows=270 width=28) (actual time=0.063..0.157 rows=188 loops=1)

  • Hash Cond: (base_p_16.brand_base_prop_id = e_16.live_brand_base_prop_id)
144. 0.054 0.054 ↓ 1.0 462 1

Seq Scan on brand_base_props base_p_16 (cost=0.00..30.54 rows=454 width=8) (actual time=0.003..0.054 rows=462 loops=1)

145. 0.021 0.056 ↑ 1.4 188 1

Hash (cost=6.70..6.70 rows=270 width=36) (actual time=0.056..0.056 rows=188 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
146. 0.035 0.035 ↓ 1.0 274 1

Seq Scan on brands e_16 (cost=0.00..6.70 rows=270 width=36) (actual time=0.004..0.035 rows=274 loops=1)

147. 0.203 2.950 ↑ 1.5 895 1

Hash Join (cost=424.20..892.59 rows=1,310 width=52) (actual time=1.990..2.950 rows=895 loops=1)

  • Hash Cond: (e_17.live_product_label_prop_id = label_p_17.product_label_prop_id)
148. 0.297 2.365 ↑ 1.5 895 1

Hash Join (cost=307.62..772.57 rows=1,310 width=60) (actual time=1.604..2.365 rows=895 loops=1)

  • Hash Cond: (sr_p_5.product_sr_prop_id = e_17.live_product_sr_prop_id)
149. 0.471 0.471 ↑ 1.0 2,283 1

Seq Scan on product_sr_props sr_p_5 (cost=0.00..446.83 rows=2,283 width=8) (actual time=0.002..0.471 rows=2,283 loops=1)

150. 0.106 1.597 ↑ 1.5 895 1

Hash (cost=291.24..291.24 rows=1,310 width=68) (actual time=1.597..1.597 rows=895 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 107kB
151. 0.136 1.491 ↑ 1.5 895 1

Hash Join (cost=254.52..291.24 rows=1,310 width=68) (actual time=1.233..1.491 rows=895 loops=1)

  • Hash Cond: (tmp_li1_2.brand_id = base_p_17.brand_id)
152. 0.307 0.307 ↑ 1.4 188 1

CTE Scan on tmp_li1 tmp_li1_2 (cost=0.00..5.40 rows=270 width=12) (actual time=0.181..0.307 rows=188 loops=1)

153. 0.115 1.048 ↑ 1.4 922 1

Hash (cost=238.02..238.02 rows=1,320 width=64) (actual time=1.048..1.048 rows=922 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 107kB
154. 0.250 0.933 ↑ 1.4 922 1

Hash Join (cost=83.70..238.02 rows=1,320 width=64) (actual time=0.393..0.933 rows=922 loops=1)

  • Hash Cond: (base_p_17.product_base_prop_id = e_17.live_product_base_prop_id)
155. 0.297 0.297 ↑ 1.0 2,242 1

Seq Scan on product_base_props base_p_17 (cost=0.00..148.42 rows=2,242 width=12) (actual time=0.003..0.297 rows=2,242 loops=1)

156. 0.125 0.386 ↑ 1.4 922 1

Hash (cost=67.20..67.20 rows=1,320 width=68) (actual time=0.386..0.386 rows=922 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 110kB
157. 0.261 0.261 ↑ 1.0 1,320 1

Seq Scan on products e_17 (cost=0.00..67.20 rows=1,320 width=68) (actual time=0.002..0.261 rows=1,320 loops=1)

158. 0.163 0.382 ↑ 1.0 2,248 1

Hash (cost=88.48..88.48 rows=2,248 width=8) (actual time=0.382..0.382 rows=2,248 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 120kB
159. 0.219 0.219 ↑ 1.0 2,248 1

Seq Scan on product_label_props label_p_17 (cost=0.00..88.48 rows=2,248 width=8) (actual time=0.003..0.219 rows=2,248 loops=1)

160. 0.163 0.417 ↑ 1.0 2,242 1

Hash (cost=238.77..238.77 rows=2,242 width=8) (actual time=0.417..0.417 rows=2,242 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 120kB
161. 0.254 0.254 ↑ 1.0 2,242 1

Index Only Scan using product_econtent_props_pkey on product_econtent_props econtent_p_2 (cost=0.28..238.77 rows=2,242 width=8) (actual time=0.006..0.254 rows=2,242 loops=1)

  • Heap Fetches: 610
162.          

CTE tmp_pkg_li

163. 0.188 4.981 ↑ 3.0 986 1

Hash Join (cost=1,211.40..1,367.30 rows=2,935 width=12) (actual time=2.342..4.981 rows=986 loops=1)

  • Hash Cond: (e_20.live_packaging_tech_prop_id = tech_p_11.packaging_tech_prop_id)
164. 0.192 4.499 ↑ 3.0 986 1

Hash Join (cost=1,144.11..1,292.29 rows=2,935 width=20) (actual time=2.043..4.499 rows=986 loops=1)

  • Hash Cond: (e_20.live_packaging_label_prop_id = label_p_20.packaging_label_prop_id)
165. 0.211 3.982 ↑ 3.0 986 1

Hash Join (cost=973.81..1,114.28 rows=2,935 width=28) (actual time=1.714..3.982 rows=986 loops=1)

  • Hash Cond: (e_20.live_packaging_base_prop_id = base_p_20.packaging_base_prop_id)
166. 0.229 3.462 ↑ 2.6 1,116 1

Hash Right Join (cost=845.52..978.27 rows=2,935 width=36) (actual time=1.400..3.462 rows=1,116 loops=1)

  • Hash Cond: (l1_7.packaging_id = e_20.packaging_id)
167. 0.054 2.997 ↑ 3.0 986 1

Append (cost=779.41..875.07 rows=2,935 width=16) (actual time=1.161..2.997 rows=986 loops=1)

168.          

CTE lnot1

169. 0.010 0.905 ↑ 1.1 156 1

Nested Loop (cost=163.36..294.79 rows=166 width=16) (actual time=0.533..0.905 rows=156 loops=1)

170. 0.123 0.739 ↑ 1.1 156 1

Hash Join (cost=163.08..213.46 rows=166 width=40) (actual time=0.523..0.739 rows=156 loops=1)

  • Hash Cond: (tech_p_9.packaging_tech_prop_id = e_18.live_packaging_tech_prop_id)
171. 0.147 0.147 ↑ 1.0 2,102 1

Seq Scan on packaging_tech_props tech_p_9 (cost=0.00..41.02 rows=2,102 width=8) (actual time=0.004..0.147 rows=2,102 loops=1)

172. 0.018 0.469 ↑ 1.1 156 1

Hash (cost=161.01..161.01 rows=166 width=48) (actual time=0.469..0.469 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
173. 0.072 0.451 ↑ 1.1 156 1

Hash Join (cost=105.92..161.01 rows=166 width=48) (actual time=0.374..0.451 rows=156 loops=1)

  • Hash Cond: (e_18.live_packaging_base_prop_id = base_p_18.packaging_base_prop_id)
174. 0.186 0.186 ↑ 1.0 1,116 1

Seq Scan on packagings e_18 (cost=0.00..52.16 rows=1,116 width=52) (actual time=0.003..0.186 rows=1,116 loops=1)

175. 0.025 0.193 ↑ 1.0 312 1

Hash (cost=102.02..102.02 rows=312 width=12) (actual time=0.193..0.193 rows=312 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
176. 0.168 0.168 ↑ 1.0 312 1

Seq Scan on packaging_base_props base_p_18 (cost=0.00..102.02 rows=312 width=12) (actual time=0.007..0.168 rows=312 loops=1)

  • Filter: (based_on_packaging_id IS NOT NULL)
  • Rows Removed by Filter: 1790
177. 0.156 0.156 ↑ 1.0 1 156

Index Only Scan using packaging_label_props_pkey on packaging_label_props label_p_18 (cost=0.28..0.49 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=156)

  • Index Cond: (packaging_label_prop_id = e_18.live_packaging_label_prop_id)
  • Heap Fetches: 156
178.          

CTE l1

179. 0.333 1.642 ↑ 1.1 830 1

Hash Join (cost=251.86..414.53 rows=950 width=12) (actual time=1.159..1.642 rows=830 loops=1)

  • Hash Cond: (label_p_19.packaging_label_prop_id = e_19.live_packaging_label_prop_id)
180. 0.161 0.161 ↑ 1.0 2,102 1

Seq Scan on packaging_label_props label_p_19 (cost=0.00..144.02 rows=2,102 width=8) (actual time=0.001..0.161 rows=2,102 loops=1)

181. 0.087 1.148 ↑ 1.1 830 1

Hash (cost=239.98..239.98 rows=950 width=36) (actual time=1.148..1.148 rows=830 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 67kB
182. 0.129 1.061 ↑ 1.1 830 1

Hash Join (cost=190.50..239.98 rows=950 width=36) (actual time=0.584..1.061 rows=830 loops=1)

  • Hash Cond: (e_19.live_packaging_base_prop_id = base_p_19.packaging_base_prop_id)
183. 0.219 0.628 ↑ 1.1 986 1

Hash Join (cost=66.11..112.66 rows=1,116 width=44) (actual time=0.276..0.628 rows=986 loops=1)

  • Hash Cond: (tech_p_10.packaging_tech_prop_id = e_19.live_packaging_tech_prop_id)
184. 0.140 0.140 ↑ 1.0 2,102 1

Seq Scan on packaging_tech_props tech_p_10 (cost=0.00..41.02 rows=2,102 width=8) (actual time=0.002..0.140 rows=2,102 loops=1)

185. 0.117 0.269 ↑ 1.1 986 1

Hash (cost=52.16..52.16 rows=1,116 width=52) (actual time=0.269..0.269 rows=986 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 101kB
186. 0.152 0.152 ↑ 1.0 1,116 1

Seq Scan on packagings e_19 (cost=0.00..52.16 rows=1,116 width=52) (actual time=0.002..0.152 rows=1,116 loops=1)

187. 0.130 0.304 ↑ 1.0 1,790 1

Hash (cost=102.02..102.02 rows=1,790 width=8) (actual time=0.304..0.304 rows=1,790 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 86kB
188. 0.174 0.174 ↑ 1.0 1,790 1

Seq Scan on packaging_base_props base_p_19 (cost=0.00..102.02 rows=1,790 width=8) (actual time=0.002..0.174 rows=1,790 loops=1)

  • Filter: (based_on_packaging_id IS NULL)
  • Rows Removed by Filter: 312
189.          

CTE l2

190. 0.062 1.059 ↑ 7.2 110 1

Hash Join (cost=5.40..37.81 rows=788 width=12) (actual time=0.958..1.059 rows=110 loops=1)

  • Hash Cond: (l1_6.packaging_id = x_8.based_on_packaging_id)
191. 0.044 0.044 ↑ 1.1 830 1

CTE Scan on l1 l1_6 (cost=0.00..19.00 rows=950 width=12) (actual time=0.000..0.044 rows=830 loops=1)

192. 0.017 0.953 ↑ 1.1 156 1

Hash (cost=3.32..3.32 rows=166 width=16) (actual time=0.953..0.953 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
193. 0.936 0.936 ↑ 1.1 156 1

CTE Scan on lnot1 x_8 (cost=0.00..3.32 rows=166 width=16) (actual time=0.534..0.936 rows=156 loops=1)

194.          

CTE l3

195. 0.015 0.039 ↑ 15.2 43 1

Hash Join (cost=5.40..32.28 rows=654 width=12) (actual time=0.024..0.039 rows=43 loops=1)

  • Hash Cond: (l2_6.packaging_id = x_9.based_on_packaging_id)
196. 0.006 0.006 ↑ 7.2 110 1

CTE Scan on l2 l2_6 (cost=0.00..15.76 rows=788 width=12) (actual time=0.000..0.006 rows=110 loops=1)

197. 0.010 0.018 ↑ 1.1 156 1

Hash (cost=3.32..3.32 rows=166 width=16) (actual time=0.018..0.018 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
198. 0.008 0.008 ↑ 1.1 156 1

CTE Scan on lnot1 x_9 (cost=0.00..3.32 rows=166 width=16) (actual time=0.000..0.008 rows=156 loops=1)

199. 1.792 1.792 ↑ 1.1 830 1

CTE Scan on l1 l1_7 (cost=0.00..19.00 rows=950 width=16) (actual time=1.161..1.792 rows=830 loops=1)

200. 1.078 1.078 ↑ 7.2 110 1

CTE Scan on l2 l2_7 (cost=0.00..15.76 rows=788 width=16) (actual time=0.960..1.078 rows=110 loops=1)

201. 0.047 0.047 ↑ 15.2 43 1

CTE Scan on l3 l3_8 (cost=0.00..13.08 rows=654 width=16) (actual time=0.024..0.047 rows=43 loops=1)

202. 0.006 0.026 ↑ 181.0 3 1

Hash Join (cost=5.40..27.71 rows=543 width=16) (actual time=0.023..0.026 rows=3 loops=1)

  • Hash Cond: (l3_9.packaging_id = x_10.based_on_packaging_id)
203. 0.002 0.002 ↑ 15.2 43 1

CTE Scan on l3 l3_9 (cost=0.00..13.08 rows=654 width=12) (actual time=0.000..0.002 rows=43 loops=1)

204. 0.010 0.018 ↑ 1.1 156 1

Hash (cost=3.32..3.32 rows=166 width=16) (actual time=0.018..0.018 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
205. 0.008 0.008 ↑ 1.1 156 1

CTE Scan on lnot1 x_10 (cost=0.00..3.32 rows=166 width=16) (actual time=0.000..0.008 rows=156 loops=1)

206. 0.102 0.236 ↑ 1.0 1,116 1

Hash (cost=52.16..52.16 rows=1,116 width=28) (actual time=0.236..0.236 rows=1,116 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 83kB
207. 0.134 0.134 ↑ 1.0 1,116 1

Seq Scan on packagings e_20 (cost=0.00..52.16 rows=1,116 width=28) (actual time=0.002..0.134 rows=1,116 loops=1)

208. 0.150 0.309 ↑ 1.0 2,102 1

Hash (cost=102.02..102.02 rows=2,102 width=8) (actual time=0.309..0.309 rows=2,102 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 115kB
209. 0.159 0.159 ↑ 1.0 2,102 1

Seq Scan on packaging_base_props base_p_20 (cost=0.00..102.02 rows=2,102 width=8) (actual time=0.002..0.159 rows=2,102 loops=1)

210. 0.153 0.325 ↑ 1.0 2,102 1

Hash (cost=144.02..144.02 rows=2,102 width=8) (actual time=0.325..0.325 rows=2,102 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 115kB
211. 0.172 0.172 ↑ 1.0 2,102 1

Seq Scan on packaging_label_props label_p_20 (cost=0.00..144.02 rows=2,102 width=8) (actual time=0.002..0.172 rows=2,102 loops=1)

212. 0.149 0.294 ↑ 1.0 2,102 1

Hash (cost=41.02..41.02 rows=2,102 width=8) (actual time=0.294..0.294 rows=2,102 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 115kB
213. 0.145 0.145 ↑ 1.0 2,102 1

Seq Scan on packaging_tech_props tech_p_11 (cost=0.00..41.02 rows=2,102 width=8) (actual time=0.004..0.145 rows=2,102 loops=1)

214. 5.122 5.122 ↑ 3.0 986 1

CTE Scan on tmp_pkg_li tmp_pkg_li_3 (cost=0.00..58.70 rows=2,935 width=12) (actual time=2.343..5.122 rows=986 loops=1)

215. 0.350 20.597 ↑ 1.9 2,458 1

Hash (cost=4,180.90..4,180.90 rows=4,657 width=80) (actual time=20.597..20.597 rows=2,458 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 353kB
216. 0.438 20.247 ↑ 1.9 2,458 1

Hash Join (cost=3,816.48..4,180.90 rows=4,657 width=80) (actual time=18.050..20.247 rows=2,458 loops=1)

  • Hash Cond: (legal_p_3.distributor_id = tmp_d_li1_3.distributor_id)
217. 0.445 19.759 ↑ 1.9 2,458 1

Hash Join (cost=3,815.48..4,115.86 rows=4,657 width=76) (actual time=17.996..19.759 rows=2,458 loops=1)

  • Hash Cond: (tmp_p_li_3.product_id = base_p_21.product_id)
218. 3.973 3.973 ↑ 1.5 895 1

CTE Scan on tmp_p_li tmp_p_li_3 (cost=0.00..26.20 rows=1,310 width=12) (actual time=2.414..3.973 rows=895 loops=1)

219. 0.374 15.341 ↑ 1.3 2,608 1

Hash (cost=3,772.50..3,772.50 rows=3,438 width=72) (actual time=15.341..15.341 rows=2,608 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 308kB
220. 0.595 14.967 ↑ 1.3 2,608 1

Hash Join (cost=2,442.85..3,772.50 rows=3,438 width=72) (actual time=10.672..14.967 rows=2,608 loops=1)

  • Hash Cond: (e_21.live_article_palettizing_prop_id = palettizing_p_3.article_palettizing_prop_id)
221. 0.518 13.316 ↑ 1.3 2,608 1

Hash Join (cost=2,211.57..3,532.19 rows=3,438 width=80) (actual time=9.609..13.316 rows=2,608 loops=1)

  • Hash Cond: (e_21.live_article_tech_prop_id = tech_p_12.article_tech_prop_id)
222. 0.567 11.665 ↑ 1.3 2,608 1

Hash Join (cost=1,940.28..3,251.89 rows=3,438 width=88) (actual time=8.469..11.665 rows=2,608 loops=1)

  • Hash Cond: (e_21.live_article_wvd_prop_id = wvd_p_3.article_wvd_prop_id)
223. 0.545 10.043 ↑ 1.3 2,608 1

Hash Join (cost=1,701.00..3,003.58 rows=3,438 width=96) (actual time=7.408..10.043 rows=2,608 loops=1)

  • Hash Cond: (e_21.live_article_legal_prop_id = legal_p_3.article_legal_prop_id)
224. 1.001 8.336 ↑ 1.3 2,608 1

Hash Join (cost=1,468.72..2,762.27 rows=3,438 width=100) (actual time=6.239..8.336 rows=2,608 loops=1)

  • Hash Cond: (sr_p_6.article_sr_prop_id = e_21.live_article_sr_prop_id)
225. 1.182 1.182 ↑ 1.0 7,257 1

Seq Scan on article_sr_props sr_p_6 (cost=0.00..1,239.57 rows=7,257 width=8) (actual time=0.002..1.182 rows=7,257 loops=1)

226. 0.428 6.153 ↑ 1.3 2,608 1

Hash (cost=1,425.74..1,425.74 rows=3,438 width=108) (actual time=6.153..6.153 rows=2,608 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 399kB
227. 1.002 5.725 ↑ 1.3 2,608 1

Hash Join (cost=873.19..1,425.74 rows=3,438 width=108) (actual time=4.131..5.725 rows=2,608 loops=1)

  • Hash Cond: (label_p_21.article_label_prop_id = e_21.live_article_label_prop_id)
228. 0.655 0.655 ↑ 1.0 7,257 1

Seq Scan on article_label_props label_p_21 (cost=0.00..498.57 rows=7,257 width=8) (actual time=0.002..0.655 rows=7,257 loops=1)

229. 0.430 4.068 ↑ 1.3 2,608 1

Hash (cost=830.21..830.21 rows=3,438 width=116) (actual time=4.068..4.068 rows=2,608 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 420kB
230. 0.816 3.638 ↑ 1.3 2,608 1

Hash Join (cost=521.50..830.21 rows=3,438 width=116) (actual time=2.055..3.638 rows=2,608 loops=1)

  • Hash Cond: (base_p_21.article_base_prop_id = e_21.live_article_base_prop_id)
231. 0.856 0.856 ↑ 1.0 6,150 1

Seq Scan on article_base_props base_p_21 (cost=0.00..292.56 rows=6,150 width=16) (actual time=0.004..0.856 rows=6,150 loops=1)

  • Filter: (based_on_article_id IS NULL)
  • Rows Removed by Filter: 1106
232. 0.501 1.966 ↑ 1.3 3,161 1

Hash (cost=470.80..470.80 rows=4,056 width=116) (actual time=1.966..1.966 rows=3,161 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 502kB
233. 1.465 1.465 ↑ 1.0 4,056 1

Seq Scan on articles e_21 (cost=0.00..470.80 rows=4,056 width=116) (actual time=0.004..1.465 rows=4,056 loops=1)

  • Filter: (NOT on_hold)
  • Rows Removed by Filter: 24
234. 0.582 1.162 ↑ 1.0 7,257 1

Hash (cost=141.57..141.57 rows=7,257 width=12) (actual time=1.162..1.162 rows=7,257 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 376kB
235. 0.580 0.580 ↑ 1.0 7,257 1

Seq Scan on article_legal_props legal_p_3 (cost=0.00..141.57 rows=7,257 width=12) (actual time=0.004..0.580 rows=7,257 loops=1)

236. 0.521 1.055 ↑ 1.0 7,257 1

Hash (cost=148.57..148.57 rows=7,257 width=8) (actual time=1.055..1.055 rows=7,257 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 348kB
237. 0.534 0.534 ↑ 1.0 7,257 1

Seq Scan on article_wvd_props wvd_p_3 (cost=0.00..148.57 rows=7,257 width=8) (actual time=0.004..0.534 rows=7,257 loops=1)

238. 0.520 1.133 ↑ 1.0 7,257 1

Hash (cost=180.57..180.57 rows=7,257 width=8) (actual time=1.133..1.133 rows=7,257 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 348kB
239. 0.613 0.613 ↑ 1.0 7,257 1

Seq Scan on article_tech_props tech_p_12 (cost=0.00..180.57 rows=7,257 width=8) (actual time=0.003..0.613 rows=7,257 loops=1)

240. 0.516 1.056 ↑ 1.0 7,257 1

Hash (cost=140.57..140.57 rows=7,257 width=8) (actual time=1.056..1.056 rows=7,257 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 348kB
241. 0.540 0.540 ↑ 1.0 7,257 1

Seq Scan on article_palettizing_props palettizing_p_3 (cost=0.00..140.57 rows=7,257 width=8) (actual time=0.004..0.540 rows=7,257 loops=1)

242. 0.002 0.050 ↑ 1.4 22 1

Hash (cost=0.62..0.62 rows=31 width=12) (actual time=0.050..0.050 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
243. 0.048 0.048 ↑ 1.4 22 1

CTE Scan on tmp_d_li1 tmp_d_li1_3 (cost=0.00..0.62 rows=31 width=12) (actual time=0.030..0.048 rows=22 loops=1)

244.          

CTE l2

245. 0.186 17.945 ↑ 441.0 447 1

Merge Join (cost=1,526.70..4,989.40 rows=197,108 width=12) (actual time=17.805..17.945 rows=447 loops=1)

  • Merge Cond: (x_11.based_on_article_id = l1_8.article_id)
246. 0.077 17.171 ↑ 4.8 550 1

Sort (cost=204.69..211.34 rows=2,662 width=16) (actual time=17.154..17.171 rows=550 loops=1)

  • Sort Key: x_11.based_on_article_id
  • Sort Method: quicksort Memory: 67kB
247. 17.094 17.094 ↑ 4.8 550 1

CTE Scan on lnot1 x_11 (cost=0.00..53.24 rows=2,662 width=16) (actual time=16.557..17.094 rows=550 loops=1)

248. 0.394 0.588 ↑ 6.1 2,412 1

Sort (cost=1,322.01..1,359.04 rows=14,809 width=12) (actual time=0.510..0.588 rows=2,412 loops=1)

  • Sort Key: l1_8.article_id
  • Sort Method: quicksort Memory: 212kB
249. 0.194 0.194 ↑ 6.0 2,458 1

CTE Scan on l1 l1_8 (cost=0.00..296.18 rows=14,809 width=12) (actual time=0.001..0.194 rows=2,458 loops=1)

250.          

CTE l3

251. 0.059 0.258 ↑ 26,235.1 100 1

Merge Join (cost=21,481.14..67,405.82 rows=2,623,507 width=12) (actual time=0.206..0.258 rows=100 loops=1)

  • Merge Cond: (x_12.based_on_article_id = l2_8.article_id)
252. 0.068 0.095 ↑ 4.8 550 1

Sort (cost=204.69..211.34 rows=2,662 width=16) (actual time=0.080..0.095 rows=550 loops=1)

  • Sort Key: x_12.based_on_article_id
  • Sort Method: quicksort Memory: 67kB
253. 0.027 0.027 ↑ 4.8 550 1

CTE Scan on lnot1 x_12 (cost=0.00..53.24 rows=2,662 width=16) (actual time=0.000..0.027 rows=550 loops=1)

254. 0.068 0.104 ↑ 453.1 435 1

Sort (cost=21,276.46..21,769.23 rows=197,108 width=12) (actual time=0.091..0.104 rows=435 loops=1)

  • Sort Key: l2_8.article_id
  • Sort Method: quicksort Memory: 45kB
255. 0.036 0.036 ↑ 441.0 447 1

CTE Scan on l2 l2_8 (cost=0.00..3,942.16 rows=197,108 width=12) (actual time=0.000..0.036 rows=447 loops=1)

256. 27.862 27.862 ↑ 6.0 2,458 1

CTE Scan on l1 (cost=0.00..296.18 rows=14,809 width=16) (actual time=23.020..27.862 rows=2,458 loops=1)

257. 18.030 18.030 ↑ 441.0 447 1

CTE Scan on l2 (cost=0.00..3,942.16 rows=197,108 width=16) (actual time=17.806..18.030 rows=447 loops=1)

258. 0.278 0.278 ↑ 26,235.1 100 1

CTE Scan on l3 (cost=0.00..52,470.14 rows=2,623,507 width=16) (actual time=0.207..0.278 rows=100 loops=1)

259. 0.032 0.153 ↑ 11,639,626.0 3 1

Merge Join (cost=377,219.38..994,871.82 rows=34,918,878 width=16) (actual time=0.148..0.153 rows=3 loops=1)

  • Merge Cond: (x.based_on_article_id = l3_1.article_id)
260. 0.067 0.095 ↑ 4.8 550 1

Sort (cost=204.69..211.34 rows=2,662 width=16) (actual time=0.079..0.095 rows=550 loops=1)

  • Sort Key: x.based_on_article_id
  • Sort Method: quicksort Memory: 67kB
261. 0.028 0.028 ↑ 4.8 550 1

CTE Scan on lnot1 x (cost=0.00..53.24 rows=2,662 width=16) (actual time=0.000..0.028 rows=550 loops=1)

262. 0.004 0.026 ↑ 45,232.9 58 1

Materialize (cost=377,014.69..390,132.23 rows=2,623,507 width=12) (actual time=0.021..0.026 rows=58 loops=1)

263. 0.014 0.022 ↑ 46,026.4 57 1

Sort (cost=377,014.69..383,573.46 rows=2,623,507 width=12) (actual time=0.020..0.022 rows=57 loops=1)

  • Sort Key: l3_1.article_id
  • Sort Method: quicksort Memory: 29kB
264. 0.008 0.008 ↑ 26,235.1 100 1

CTE Scan on l3 l3_1 (cost=0.00..52,470.14 rows=2,623,507 width=12) (actual time=0.000..0.008 rows=100 loops=1)

265. 3.299 74.095 ↑ 2.3 30,080 1

Hash (cost=16,222.10..16,222.10 rows=69,011 width=24) (actual time=74.095..74.095 rows=30,080 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 2787kB
266. 7.122 70.796 ↑ 2.3 30,080 1

Hash Join (cost=7,901.59..16,222.10 rows=69,011 width=24) (actual time=46.296..70.796 rows=30,080 loops=1)

  • Hash Cond: (cns.article_id = r.article_id)
267. 3.355 36.749 ↓ 1.1 75,760 1

Append (cost=79.22..7,450.83 rows=69,011 width=20) (actual time=19.351..36.749 rows=75,760 loops=1)

268. 0.000 0.003 ↓ 0.0 0 1

Hash Join (cost=79.22..107.53 rows=1,450 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Hash Cond: (cns.rcpt_id = cnr.rcpt_id)
269. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on change_notification_subscriptions cns (cost=0.00..24.50 rows=1,450 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (confirmed_dt IS NOT NULL)
270. 0.000 0.000 ↓ 0.0 0

Hash (cost=53.54..53.54 rows=2,054 width=8) (never executed)

271. 0.000 0.000 ↓ 0.0 0

Seq Scan on change_notification_rcpts cnr (cost=0.00..53.54 rows=2,054 width=8) (never executed)

  • Filter: ((confirmed_dt IS NOT NULL) AND ((NOT subscribe_to_all_enabled) OR (subscribe_to_all_confirmed_dt IS NULL)))
272. 4.981 33.391 ↓ 1.1 75,760 1

Nested Loop (cost=4,227.76..6,308.13 rows=67,561 width=20) (actual time=19.348..33.391 rows=75,760 loops=1)

273. 0.190 0.190 ↓ 10.0 10 1

Seq Scan on change_notification_rcpts cnr_1 (cost=0.00..53.54 rows=1 width=16) (actual time=0.182..0.190 rows=10 loops=1)

  • Filter: ((confirmed_dt IS NOT NULL) AND subscribe_to_all_enabled AND (subscribe_to_all_confirmed_dt IS NOT NULL))
  • Rows Removed by Filter: 2044
274. 15.672 28.220 ↑ 8.9 7,576 10

HashAggregate (cost=4,227.76..4,903.37 rows=67,561 width=4) (actual time=1.917..2.822 rows=7,576 loops=10)

  • Group Key: articles.article_id
275. 2.976 12.548 ↓ 1.0 67,767 1

Append (cost=0.28..4,058.86 rows=67,561 width=4) (actual time=0.010..12.548 rows=67,767 loops=1)

276. 0.352 0.352 ↑ 1.0 4,080 1

Index Only Scan using articles_pkey on articles (cost=0.28..277.48 rows=4,080 width=4) (actual time=0.010..0.352 rows=4,080 loops=1)

  • Heap Fetches: 0
277. 9.220 9.220 ↓ 1.0 63,687 1

Seq Scan on entity_history (cost=0.00..2,767.96 rows=63,481 width=4) (actual time=0.053..9.220 rows=63,687 loops=1)

  • Filter: (entity_name = 'article'::text)
  • Rows Removed by Filter: 15750
278. 0.352 26.925 ↑ 5.8 3,008 1

Hash (cost=7,605.27..7,605.27 rows=17,368 width=4) (actual time=26.925..26.925 rows=3,008 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 362kB
279. 0.188 26.573 ↑ 5.8 3,008 1

Subquery Scan on r (cost=6,942.40..7,605.27 rows=17,368 width=4) (actual time=22.230..26.573 rows=3,008 loops=1)

280. 1.565 26.385 ↑ 5.8 3,008 1

Hash Join (cost=6,942.40..7,431.59 rows=17,368 width=767) (actual time=22.230..26.385 rows=3,008 loops=1)

  • Hash Cond: (tmp_pkg_li.packaging_id = base_p.packaging_id)
281.          

CTE tmp_d_li1

282. 0.005 0.043 ↑ 1.4 22 1

Hash Join (cost=3.89..8.74 rows=31 width=12) (actual time=0.029..0.043 rows=22 loops=1)

  • Hash Cond: (e_2.live_distributor_base_prop_id = base_p_2.distributor_base_prop_id)
283. 0.010 0.026 ↑ 1.4 22 1

Hash Join (cost=1.70..6.38 rows=31 width=28) (actual time=0.015..0.026 rows=22 loops=1)

  • Hash Cond: (label_p_2.distributor_label_prop_id = e_2.live_distributor_label_prop_id)
284. 0.007 0.007 ↑ 1.0 53 1

Seq Scan on distributor_label_props label_p_2 (cost=0.00..4.53 rows=53 width=8) (actual time=0.003..0.007 rows=53 loops=1)

285. 0.003 0.009 ↑ 1.4 22 1

Hash (cost=1.31..1.31 rows=31 width=36) (actual time=0.009..0.009 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
286. 0.006 0.006 ↑ 1.0 31 1

Seq Scan on distributors e_2 (cost=0.00..1.31 rows=31 width=36) (actual time=0.003..0.006 rows=31 loops=1)

287. 0.005 0.012 ↑ 1.0 53 1

Hash (cost=1.53..1.53 rows=53 width=8) (actual time=0.011..0.012 rows=53 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
288. 0.007 0.007 ↑ 1.0 53 1

Seq Scan on distributor_base_props base_p_2 (cost=0.00..1.53 rows=53 width=8) (actual time=0.004..0.007 rows=53 loops=1)

289.          

CTE tmp_p_li

290. 0.061 3.839 ↑ 1.5 895 1

Subquery Scan on product_live_items (cost=773.94..1,265.42 rows=1,310 width=12) (actual time=2.441..3.839 rows=895 loops=1)

291. 0.419 3.778 ↑ 1.5 895 1

Hash Join (cost=773.94..1,252.32 rows=1,310 width=828) (actual time=2.441..3.778 rows=895 loops=1)

  • Hash Cond: (e_4.live_product_econtent_prop_id = econtent_p.product_econtent_prop_id)
292.          

CTE tmp_li1

293. 0.054 0.285 ↑ 1.4 188 1

Hash Join (cost=45.19..82.95 rows=270 width=12) (actual time=0.185..0.285 rows=188 loops=1)

  • Hash Cond: (label_p_3.brand_label_prop_id = e_3.live_brand_label_prop_id)
294. 0.052 0.052 ↓ 1.0 462 1

Seq Scan on brand_label_props label_p_3 (cost=0.00..33.54 rows=454 width=8) (actual time=0.003..0.052 rows=462 loops=1)

295. 0.019 0.179 ↑ 1.4 188 1

Hash (cost=41.82..41.82 rows=270 width=28) (actual time=0.179..0.179 rows=188 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
296. 0.046 0.160 ↑ 1.4 188 1

Hash Join (cost=10.07..41.82 rows=270 width=28) (actual time=0.064..0.160 rows=188 loops=1)

  • Hash Cond: (base_p_3.brand_base_prop_id = e_3.live_brand_base_prop_id)
297. 0.057 0.057 ↓ 1.0 462 1

Seq Scan on brand_base_props base_p_3 (cost=0.00..30.54 rows=454 width=8) (actual time=0.003..0.057 rows=462 loops=1)

298. 0.021 0.057 ↑ 1.4 188 1

Hash (cost=6.70..6.70 rows=270 width=36) (actual time=0.057..0.057 rows=188 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
299. 0.036 0.036 ↓ 1.0 274 1

Seq Scan on brands e_3 (cost=0.00..6.70 rows=270 width=36) (actual time=0.003..0.036 rows=274 loops=1)

300. 0.175 2.933 ↑ 1.5 895 1

Hash Join (cost=424.20..892.59 rows=1,310 width=52) (actual time=2.009..2.933 rows=895 loops=1)

  • Hash Cond: (e_4.live_product_label_prop_id = label_p_4.product_label_prop_id)
301. 0.289 2.376 ↑ 1.5 895 1

Hash Join (cost=307.62..772.57 rows=1,310 width=60) (actual time=1.623..2.376 rows=895 loops=1)

  • Hash Cond: (sr_p_2.product_sr_prop_id = e_4.live_product_sr_prop_id)
302. 0.472 0.472 ↑ 1.0 2,283 1

Seq Scan on product_sr_props sr_p_2 (cost=0.00..446.83 rows=2,283 width=8) (actual time=0.003..0.472 rows=2,283 loops=1)

303. 0.106 1.615 ↑ 1.5 895 1

Hash (cost=291.24..291.24 rows=1,310 width=68) (actual time=1.615..1.615 rows=895 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 107kB
304. 0.134 1.509 ↑ 1.5 895 1

Hash Join (cost=254.52..291.24 rows=1,310 width=68) (actual time=1.251..1.509 rows=895 loops=1)

  • Hash Cond: (tmp_li1.brand_id = base_p_4.brand_id)
305. 0.313 0.313 ↑ 1.4 188 1

CTE Scan on tmp_li1 (cost=0.00..5.40 rows=270 width=12) (actual time=0.185..0.313 rows=188 loops=1)

306. 0.116 1.062 ↑ 1.4 922 1

Hash (cost=238.02..238.02 rows=1,320 width=64) (actual time=1.062..1.062 rows=922 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 107kB
307. 0.250 0.946 ↑ 1.4 922 1

Hash Join (cost=83.70..238.02 rows=1,320 width=64) (actual time=0.401..0.946 rows=922 loops=1)

  • Hash Cond: (base_p_4.product_base_prop_id = e_4.live_product_base_prop_id)
308. 0.302 0.302 ↑ 1.0 2,242 1

Seq Scan on product_base_props base_p_4 (cost=0.00..148.42 rows=2,242 width=12) (actual time=0.003..0.302 rows=2,242 loops=1)

309. 0.126 0.394 ↑ 1.4 922 1

Hash (cost=67.20..67.20 rows=1,320 width=68) (actual time=0.394..0.394 rows=922 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 110kB
310. 0.268 0.268 ↑ 1.0 1,320 1

Seq Scan on products e_4 (cost=0.00..67.20 rows=1,320 width=68) (actual time=0.002..0.268 rows=1,320 loops=1)

311. 0.159 0.382 ↑ 1.0 2,248 1

Hash (cost=88.48..88.48 rows=2,248 width=8) (actual time=0.382..0.382 rows=2,248 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 120kB
312. 0.223 0.223 ↑ 1.0 2,248 1

Seq Scan on product_label_props label_p_4 (cost=0.00..88.48 rows=2,248 width=8) (actual time=0.004..0.223 rows=2,248 loops=1)

313. 0.165 0.426 ↑ 1.0 2,242 1

Hash (cost=238.77..238.77 rows=2,242 width=8) (actual time=0.426..0.426 rows=2,242 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 120kB
314. 0.261 0.261 ↑ 1.0 2,242 1

Index Only Scan using product_econtent_props_pkey on product_econtent_props econtent_p (cost=0.28..238.77 rows=2,242 width=8) (actual time=0.007..0.261 rows=2,242 loops=1)

  • Heap Fetches: 610
315.          

CTE tmp_pkg_li

316. 0.173 5.045 ↑ 3.0 986 1

Hash Join (cost=1,211.40..1,367.30 rows=2,935 width=12) (actual time=2.522..5.045 rows=986 loops=1)

  • Hash Cond: (e_7.live_packaging_tech_prop_id = tech_p_4.packaging_tech_prop_id)
317. 0.179 4.565 ↑ 3.0 986 1

Hash Join (cost=1,144.11..1,292.29 rows=2,935 width=20) (actual time=2.210..4.565 rows=986 loops=1)

  • Hash Cond: (e_7.live_packaging_label_prop_id = label_p_7.packaging_label_prop_id)
318. 0.192 3.997 ↑ 3.0 986 1

Hash Join (cost=973.81..1,114.28 rows=2,935 width=28) (actual time=1.818..3.997 rows=986 loops=1)

  • Hash Cond: (e_7.live_packaging_base_prop_id = base_p_7.packaging_base_prop_id)
319. 0.210 3.452 ↑ 2.6 1,116 1

Hash Right Join (cost=845.52..978.27 rows=2,935 width=36) (actual time=1.460..3.452 rows=1,116 loops=1)

  • Hash Cond: (l1_3.packaging_id = e_7.packaging_id)
320. 0.054 2.965 ↑ 3.0 986 1

Append (cost=779.41..875.07 rows=2,935 width=16) (actual time=1.180..2.965 rows=986 loops=1)

321.          

CTE lnot1

322. 0.013 0.866 ↑ 1.1 156 1

Nested Loop (cost=163.36..294.79 rows=166 width=16) (actual time=0.500..0.866 rows=156 loops=1)

323. 0.122 0.697 ↑ 1.1 156 1

Hash Join (cost=163.08..213.46 rows=166 width=40) (actual time=0.489..0.697 rows=156 loops=1)

  • Hash Cond: (tech_p_2.packaging_tech_prop_id = e_5.live_packaging_tech_prop_id)
324. 0.137 0.137 ↑ 1.0 2,102 1

Seq Scan on packaging_tech_props tech_p_2 (cost=0.00..41.02 rows=2,102 width=8) (actual time=0.003..0.137 rows=2,102 loops=1)

325. 0.019 0.438 ↑ 1.1 156 1

Hash (cost=161.01..161.01 rows=166 width=48) (actual time=0.437..0.438 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
326. 0.073 0.419 ↑ 1.1 156 1

Hash Join (cost=105.92..161.01 rows=166 width=48) (actual time=0.350..0.419 rows=156 loops=1)

  • Hash Cond: (e_5.live_packaging_base_prop_id = base_p_5.packaging_base_prop_id)
327. 0.169 0.169 ↑ 1.0 1,116 1

Seq Scan on packagings e_5 (cost=0.00..52.16 rows=1,116 width=52) (actual time=0.002..0.169 rows=1,116 loops=1)

328. 0.026 0.177 ↑ 1.0 312 1

Hash (cost=102.02..102.02 rows=312 width=12) (actual time=0.177..0.177 rows=312 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
329. 0.151 0.151 ↑ 1.0 312 1

Seq Scan on packaging_base_props base_p_5 (cost=0.00..102.02 rows=312 width=12) (actual time=0.007..0.151 rows=312 loops=1)

  • Filter: (based_on_packaging_id IS NOT NULL)
  • Rows Removed by Filter: 1790
330. 0.156 0.156 ↑ 1.0 1 156

Index Only Scan using packaging_label_props_pkey on packaging_label_props label_p_5 (cost=0.28..0.49 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=156)

  • Index Cond: (packaging_label_prop_id = e_5.live_packaging_label_prop_id)
  • Heap Fetches: 156
331.          

CTE l1

332. 0.326 1.648 ↑ 1.1 830 1

Hash Join (cost=251.86..414.53 rows=950 width=12) (actual time=1.178..1.648 rows=830 loops=1)

  • Hash Cond: (label_p_6.packaging_label_prop_id = e_6.live_packaging_label_prop_id)
333. 0.156 0.156 ↑ 1.0 2,102 1

Seq Scan on packaging_label_props label_p_6 (cost=0.00..144.02 rows=2,102 width=8) (actual time=0.001..0.156 rows=2,102 loops=1)

334. 0.088 1.166 ↑ 1.1 830 1

Hash (cost=239.98..239.98 rows=950 width=36) (actual time=1.166..1.166 rows=830 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 67kB
335. 0.128 1.078 ↑ 1.1 830 1

Hash Join (cost=190.50..239.98 rows=950 width=36) (actual time=0.602..1.078 rows=830 loops=1)

  • Hash Cond: (e_6.live_packaging_base_prop_id = base_p_6.packaging_base_prop_id)
336. 0.219 0.629 ↑ 1.1 986 1

Hash Join (cost=66.11..112.66 rows=1,116 width=44) (actual time=0.277..0.629 rows=986 loops=1)

  • Hash Cond: (tech_p_3.packaging_tech_prop_id = e_6.live_packaging_tech_prop_id)
337. 0.139 0.139 ↑ 1.0 2,102 1

Seq Scan on packaging_tech_props tech_p_3 (cost=0.00..41.02 rows=2,102 width=8) (actual time=0.002..0.139 rows=2,102 loops=1)

338. 0.121 0.271 ↑ 1.1 986 1

Hash (cost=52.16..52.16 rows=1,116 width=52) (actual time=0.271..0.271 rows=986 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 101kB
339. 0.150 0.150 ↑ 1.0 1,116 1

Seq Scan on packagings e_6 (cost=0.00..52.16 rows=1,116 width=52) (actual time=0.002..0.150 rows=1,116 loops=1)

340. 0.136 0.321 ↑ 1.0 1,790 1

Hash (cost=102.02..102.02 rows=1,790 width=8) (actual time=0.321..0.321 rows=1,790 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 86kB
341. 0.185 0.185 ↑ 1.0 1,790 1

Seq Scan on packaging_base_props base_p_6 (cost=0.00..102.02 rows=1,790 width=8) (actual time=0.002..0.185 rows=1,790 loops=1)

  • Filter: (based_on_packaging_id IS NULL)
  • Rows Removed by Filter: 312
342.          

CTE l2

343. 0.065 1.023 ↑ 7.2 110 1

Hash Join (cost=5.40..37.81 rows=788 width=12) (actual time=0.918..1.023 rows=110 loops=1)

  • Hash Cond: (l1_2.packaging_id = x_2.based_on_packaging_id)
344. 0.045 0.045 ↑ 1.1 830 1

CTE Scan on l1 l1_2 (cost=0.00..19.00 rows=950 width=12) (actual time=0.000..0.045 rows=830 loops=1)

345. 0.017 0.913 ↑ 1.1 156 1

Hash (cost=3.32..3.32 rows=166 width=16) (actual time=0.913..0.913 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
346. 0.896 0.896 ↑ 1.1 156 1

CTE Scan on lnot1 x_2 (cost=0.00..3.32 rows=166 width=16) (actual time=0.501..0.896 rows=156 loops=1)

347.          

CTE l3

348. 0.016 0.040 ↑ 15.2 43 1

Hash Join (cost=5.40..32.28 rows=654 width=12) (actual time=0.024..0.040 rows=43 loops=1)

  • Hash Cond: (l2_2.packaging_id = x_3.based_on_packaging_id)
349. 0.006 0.006 ↑ 7.2 110 1

CTE Scan on l2 l2_2 (cost=0.00..15.76 rows=788 width=12) (actual time=0.000..0.006 rows=110 loops=1)

350. 0.010 0.018 ↑ 1.1 156 1

Hash (cost=3.32..3.32 rows=166 width=16) (actual time=0.018..0.018 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
351. 0.008 0.008 ↑ 1.1 156 1

CTE Scan on lnot1 x_3 (cost=0.00..3.32 rows=166 width=16) (actual time=0.000..0.008 rows=156 loops=1)

352. 1.794 1.794 ↑ 1.1 830 1

CTE Scan on l1 l1_3 (cost=0.00..19.00 rows=950 width=16) (actual time=1.180..1.794 rows=830 loops=1)

353. 1.043 1.043 ↑ 7.2 110 1

CTE Scan on l2 l2_3 (cost=0.00..15.76 rows=788 width=16) (actual time=0.919..1.043 rows=110 loops=1)

354. 0.048 0.048 ↑ 15.2 43 1

CTE Scan on l3 l3_4 (cost=0.00..13.08 rows=654 width=16) (actual time=0.025..0.048 rows=43 loops=1)

355. 0.005 0.026 ↑ 181.0 3 1

Hash Join (cost=5.40..27.71 rows=543 width=16) (actual time=0.023..0.026 rows=3 loops=1)

  • Hash Cond: (l3_5.packaging_id = x_4.based_on_packaging_id)
356. 0.003 0.003 ↑ 15.2 43 1

CTE Scan on l3 l3_5 (cost=0.00..13.08 rows=654 width=12) (actual time=0.000..0.003 rows=43 loops=1)

357. 0.010 0.018 ↑ 1.1 156 1

Hash (cost=3.32..3.32 rows=166 width=16) (actual time=0.018..0.018 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
358. 0.008 0.008 ↑ 1.1 156 1

CTE Scan on lnot1 x_4 (cost=0.00..3.32 rows=166 width=16) (actual time=0.000..0.008 rows=156 loops=1)

359. 0.103 0.277 ↑ 1.0 1,116 1

Hash (cost=52.16..52.16 rows=1,116 width=28) (actual time=0.277..0.277 rows=1,116 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 83kB
360. 0.174 0.174 ↑ 1.0 1,116 1

Seq Scan on packagings e_7 (cost=0.00..52.16 rows=1,116 width=28) (actual time=0.003..0.174 rows=1,116 loops=1)

361. 0.149 0.353 ↑ 1.0 2,102 1

Hash (cost=102.02..102.02 rows=2,102 width=8) (actual time=0.353..0.353 rows=2,102 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 115kB
362. 0.204 0.204 ↑ 1.0 2,102 1

Seq Scan on packaging_base_props base_p_7 (cost=0.00..102.02 rows=2,102 width=8) (actual time=0.004..0.204 rows=2,102 loops=1)

363. 0.151 0.389 ↑ 1.0 2,102 1

Hash (cost=144.02..144.02 rows=2,102 width=8) (actual time=0.389..0.389 rows=2,102 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 115kB
364. 0.238 0.238 ↑ 1.0 2,102 1

Seq Scan on packaging_label_props label_p_7 (cost=0.00..144.02 rows=2,102 width=8) (actual time=0.003..0.238 rows=2,102 loops=1)

365. 0.150 0.307 ↑ 1.0 2,102 1

Hash (cost=41.02..41.02 rows=2,102 width=8) (actual time=0.307..0.307 rows=2,102 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 115kB
366. 0.157 0.157 ↑ 1.0 2,102 1

Seq Scan on packaging_tech_props tech_p_4 (cost=0.00..41.02 rows=2,102 width=8) (actual time=0.005..0.157 rows=2,102 loops=1)

367. 5.184 5.184 ↑ 3.0 986 1

CTE Scan on tmp_pkg_li (cost=0.00..58.70 rows=2,935 width=4) (actual time=2.523..5.184 rows=986 loops=1)

368. 0.266 19.636 ↑ 1.8 3,008 1

Hash (cost=4,232.67..4,232.67 rows=5,462 width=8) (actual time=19.636..19.636 rows=3,008 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 182kB
369. 0.401 19.370 ↑ 1.8 3,008 1

Hash Join (cost=3,849.13..4,232.67 rows=5,462 width=8) (actual time=17.322..19.370 rows=3,008 loops=1)

  • Hash Cond: (legal_p.distributor_id = tmp_d_li1.distributor_id)
370. 0.355 18.919 ↑ 1.8 3,008 1

Hash Join (cost=3,848.12..4,156.56 rows=5,462 width=12) (actual time=17.269..18.919 rows=3,008 loops=1)

  • Hash Cond: (tmp_p_li.product_id = base_p.product_id)
371. 3.972 3.972 ↑ 1.5 895 1

CTE Scan on tmp_p_li (cost=0.00..26.20 rows=1,310 width=4) (actual time=2.442..3.972 rows=895 loops=1)

372. 0.303 14.592 ↑ 1.3 3,161 1

Hash (cost=3,797.72..3,797.72 rows=4,032 width=16) (actual time=14.592..14.592 rows=3,161 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 181kB
373. 0.546 14.289 ↑ 1.3 3,161 1

Hash Join (cost=2,446.62..3,797.72 rows=4,032 width=16) (actual time=9.632..14.289 rows=3,161 loops=1)

  • Hash Cond: (e.live_article_palettizing_prop_id = palettizing_p.article_palettizing_prop_id)
374. 0.559 12.690 ↑ 1.3 3,161 1

Hash Join (cost=2,215.34..3,555.86 rows=4,032 width=24) (actual time=8.573..12.690 rows=3,161 loops=1)

  • Hash Cond: (e.live_article_tech_prop_id = tech_p.article_tech_prop_id)
375. 0.511 10.996 ↑ 1.3 3,161 1

Hash Join (cost=1,944.06..3,273.99 rows=4,032 width=32) (actual time=7.431..10.996 rows=3,161 loops=1)

  • Hash Cond: (e.live_article_wvd_prop_id = wvd_p.article_wvd_prop_id)
376. 0.516 9.416 ↑ 1.3 3,161 1

Hash Join (cost=1,704.77..3,024.12 rows=4,032 width=40) (actual time=6.356..9.416 rows=3,161 loops=1)

  • Hash Cond: (e.live_article_legal_prop_id = legal_p.article_legal_prop_id)
377. 0.553 7.732 ↑ 1.3 3,161 1

Hash Join (cost=1,472.49..2,781.26 rows=4,032 width=44) (actual time=5.182..7.732 rows=3,161 loops=1)

  • Hash Cond: (e.live_article_base_prop_id = base_p.article_base_prop_id)
378. 0.914 5.759 ↑ 1.3 3,162 1

Hash Join (cost=1,089.23..2,387.41 rows=4,032 width=44) (actual time=3.756..5.759 rows=3,162 loops=1)

  • Hash Cond: (sr_p.article_sr_prop_id = e.live_article_sr_prop_id)
379. 1.175 1.175 ↑ 1.0 7,257 1

Seq Scan on article_sr_props sr_p (cost=0.00..1,239.57 rows=7,257 width=8) (actual time=0.002..1.175 rows=7,257 loops=1)

380. 0.368 3.670 ↑ 1.3 3,162 1

Hash (cost=1,038.83..1,038.83 rows=4,032 width=52) (actual time=3.670..3.670 rows=3,162 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 304kB
381. 0.893 3.302 ↑ 1.3 3,162 1

Hash Join (cost=521.20..1,038.83 rows=4,032 width=52) (actual time=1.811..3.302 rows=3,162 loops=1)

  • Hash Cond: (label_p.article_label_prop_id = e.live_article_label_prop_id)
382. 0.661 0.661 ↑ 1.0 7,257 1

Seq Scan on article_label_props label_p (cost=0.00..498.57 rows=7,257 width=8) (actual time=0.002..0.661 rows=7,257 loops=1)

383. 0.407 1.748 ↑ 1.3 3,162 1

Hash (cost=470.80..470.80 rows=4,032 width=60) (actual time=1.748..1.748 rows=3,162 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 329kB
384. 1.341 1.341 ↓ 1.0 4,056 1

Seq Scan on articles e (cost=0.00..470.80 rows=4,032 width=60) (actual time=0.003..1.341 rows=4,056 loops=1)

  • Filter: ((NOT on_hold) AND (NOT on_hold))
  • Rows Removed by Filter: 24
385. 0.602 1.420 ↑ 1.0 7,256 1

Hash (cost=292.56..292.56 rows=7,256 width=16) (actual time=1.420..1.420 rows=7,256 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 405kB
386. 0.818 0.818 ↑ 1.0 7,256 1

Seq Scan on article_base_props base_p (cost=0.00..292.56 rows=7,256 width=16) (actual time=0.003..0.818 rows=7,256 loops=1)

387. 0.585 1.168 ↑ 1.0 7,257 1

Hash (cost=141.57..141.57 rows=7,257 width=12) (actual time=1.168..1.168 rows=7,257 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 376kB
388. 0.583 0.583 ↑ 1.0 7,257 1

Seq Scan on article_legal_props legal_p (cost=0.00..141.57 rows=7,257 width=12) (actual time=0.004..0.583 rows=7,257 loops=1)

389. 0.532 1.069 ↑ 1.0 7,257 1

Hash (cost=148.57..148.57 rows=7,257 width=8) (actual time=1.069..1.069 rows=7,257 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 348kB
390. 0.537 0.537 ↑ 1.0 7,257 1

Seq Scan on article_wvd_props wvd_p (cost=0.00..148.57 rows=7,257 width=8) (actual time=0.003..0.537 rows=7,257 loops=1)

391. 0.519 1.135 ↑ 1.0 7,257 1

Hash (cost=180.57..180.57 rows=7,257 width=8) (actual time=1.135..1.135 rows=7,257 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 348kB
392. 0.616 0.616 ↑ 1.0 7,257 1

Seq Scan on article_tech_props tech_p (cost=0.00..180.57 rows=7,257 width=8) (actual time=0.003..0.616 rows=7,257 loops=1)

393. 0.514 1.053 ↑ 1.0 7,257 1

Hash (cost=140.57..140.57 rows=7,257 width=8) (actual time=1.053..1.053 rows=7,257 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 348kB
394. 0.539 0.539 ↑ 1.0 7,257 1

Seq Scan on article_palettizing_props palettizing_p (cost=0.00..140.57 rows=7,257 width=8) (actual time=0.004..0.539 rows=7,257 loops=1)

395. 0.003 0.050 ↑ 1.4 22 1

Hash (cost=0.62..0.62 rows=31 width=4) (actual time=0.050..0.050 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
396. 0.047 0.047 ↑ 1.4 22 1

CTE Scan on tmp_d_li1 (cost=0.00..0.62 rows=31 width=4) (actual time=0.030..0.047 rows=22 loops=1)

397. 0.002 2,771.563 ↓ 0.0 0 1

Sort (cost=2,255,047.15..2,256,134.04 rows=434,757 width=12) (actual time=2,771.563..2,771.563 rows=0 loops=1)

  • Sort Key: get_change_notification_pending_changes_on_reactivated_entities.rcpt_id, get_change_notification_pending_changes_on_reactivated_entities.article_id
  • Sort Method: quicksort Memory: 25kB
398. 0.002 2,771.561 ↓ 0.0 0 1

Hash Right Join (cost=93,892.17..2,206,901.98 rows=434,757 width=12) (actual time=2,771.561..2,771.561 rows=0 loops=1)

  • Hash Cond: (l1_1.article_id = r_1.article_id)
399. 0.000 0.000 ↓ 0.0 0

Append (cost=86,027.15..1,675,567.74 rows=37,754,302 width=16) (never executed)

400.          

CTE lnot1

401. 0.000 0.000 ↓ 0.0 0

Subquery Scan on article_live_items2_2 (cost=5,980.21..6,065.62 rows=2,662 width=16) (never executed)

402. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=5,980.21..6,039.00 rows=2,662 width=767) (never executed)

  • Merge Cond: (base_p_34.packaging_id = tmp_pkg_li_4.packaging_id)
403.          

CTE tmp_d_li1

404. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3.89..8.74 rows=31 width=12) (never executed)

  • Hash Cond: (e_28.live_distributor_base_prop_id = base_p_28.distributor_base_prop_id)
405. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.70..6.38 rows=31 width=28) (never executed)

  • Hash Cond: (label_p_28.distributor_label_prop_id = e_28.live_distributor_label_prop_id)
406. 0.000 0.000 ↓ 0.0 0

Seq Scan on distributor_label_props label_p_28 (cost=0.00..4.53 rows=53 width=8) (never executed)

407. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.31..1.31 rows=31 width=36) (never executed)

408. 0.000 0.000 ↓ 0.0 0

Seq Scan on distributors e_28 (cost=0.00..1.31 rows=31 width=36) (never executed)

409. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.53..1.53 rows=53 width=8) (never executed)

410. 0.000 0.000 ↓ 0.0 0

Seq Scan on distributor_base_props base_p_28 (cost=0.00..1.53 rows=53 width=8) (never executed)

411.          

CTE tmp_p_li

412. 0.000 0.000 ↓ 0.0 0

Subquery Scan on product_live_items_4 (cost=773.94..1,265.42 rows=1,310 width=12) (never executed)

413. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=773.94..1,252.32 rows=1,310 width=828) (never executed)

  • Hash Cond: (e_30.live_product_econtent_prop_id = econtent_p_4.product_econtent_prop_id)
414.          

CTE tmp_li1

415. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=45.19..82.95 rows=270 width=12) (never executed)

  • Hash Cond: (label_p_29.brand_label_prop_id = e_29.live_brand_label_prop_id)
416. 0.000 0.000 ↓ 0.0 0

Seq Scan on brand_label_props label_p_29 (cost=0.00..33.54 rows=454 width=8) (never executed)

417. 0.000 0.000 ↓ 0.0 0

Hash (cost=41.82..41.82 rows=270 width=28) (never executed)

418. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=10.07..41.82 rows=270 width=28) (never executed)

  • Hash Cond: (base_p_29.brand_base_prop_id = e_29.live_brand_base_prop_id)
419. 0.000 0.000 ↓ 0.0 0

Seq Scan on brand_base_props base_p_29 (cost=0.00..30.54 rows=454 width=8) (never executed)

420. 0.000 0.000 ↓ 0.0 0

Hash (cost=6.70..6.70 rows=270 width=36) (never executed)

421. 0.000 0.000 ↓ 0.0 0

Seq Scan on brands e_29 (cost=0.00..6.70 rows=270 width=36) (never executed)

422. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=424.20..892.59 rows=1,310 width=52) (never executed)

  • Hash Cond: (e_30.live_product_label_prop_id = label_p_30.product_label_prop_id)
423. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=307.62..772.57 rows=1,310 width=60) (never executed)

  • Hash Cond: (sr_p_8.product_sr_prop_id = e_30.live_product_sr_prop_id)
424. 0.000 0.000 ↓ 0.0 0

Seq Scan on product_sr_props sr_p_8 (cost=0.00..446.83 rows=2,283 width=8) (never executed)

425. 0.000 0.000 ↓ 0.0 0

Hash (cost=291.24..291.24 rows=1,310 width=68) (never executed)

426. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=254.52..291.24 rows=1,310 width=68) (never executed)

  • Hash Cond: (tmp_li1_4.brand_id = base_p_30.brand_id)
427. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_li1 tmp_li1_4 (cost=0.00..5.40 rows=270 width=12) (never executed)

428. 0.000 0.000 ↓ 0.0 0

Hash (cost=238.02..238.02 rows=1,320 width=64) (never executed)

429. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=83.70..238.02 rows=1,320 width=64) (never executed)

  • Hash Cond: (base_p_30.product_base_prop_id = e_30.live_product_base_prop_id)
430. 0.000 0.000 ↓ 0.0 0

Seq Scan on product_base_props base_p_30 (cost=0.00..148.42 rows=2,242 width=12) (never executed)

431. 0.000 0.000 ↓ 0.0 0

Hash (cost=67.20..67.20 rows=1,320 width=68) (never executed)

432. 0.000 0.000 ↓ 0.0 0

Seq Scan on products e_30 (cost=0.00..67.20 rows=1,320 width=68) (never executed)

433. 0.000 0.000 ↓ 0.0 0

Hash (cost=88.48..88.48 rows=2,248 width=8) (never executed)

434. 0.000 0.000 ↓ 0.0 0

Seq Scan on product_label_props label_p_30 (cost=0.00..88.48 rows=2,248 width=8) (never executed)

435. 0.000 0.000 ↓ 0.0 0

Hash (cost=238.77..238.77 rows=2,242 width=8) (never executed)

436. 0.000 0.000 ↓ 0.0 0

Index Only Scan using product_econtent_props_pkey on product_econtent_props econtent_p_4 (cost=0.28..238.77 rows=2,242 width=8) (never executed)

  • Heap Fetches: 0
437.          

CTE tmp_pkg_li

438. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,211.40..1,367.30 rows=2,935 width=12) (never executed)

  • Hash Cond: (e_33.live_packaging_tech_prop_id = tech_p_18.packaging_tech_prop_id)
439. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,144.11..1,292.29 rows=2,935 width=20) (never executed)

  • Hash Cond: (e_33.live_packaging_label_prop_id = label_p_33.packaging_label_prop_id)
440. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=973.81..1,114.28 rows=2,935 width=28) (never executed)

  • Hash Cond: (e_33.live_packaging_base_prop_id = base_p_33.packaging_base_prop_id)
441. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=845.52..978.27 rows=2,935 width=36) (never executed)

  • Hash Cond: (l1_12.packaging_id = e_33.packaging_id)
442. 0.000 0.000 ↓ 0.0 0

Append (cost=779.41..875.07 rows=2,935 width=16) (never executed)

443.          

CTE lnot1

444. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=163.36..294.79 rows=166 width=16) (never executed)

445. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=163.08..213.46 rows=166 width=40) (never executed)

  • Hash Cond: (tech_p_16.packaging_tech_prop_id = e_31.live_packaging_tech_prop_id)
446. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_tech_props tech_p_16 (cost=0.00..41.02 rows=2,102 width=8) (never executed)

447. 0.000 0.000 ↓ 0.0 0

Hash (cost=161.01..161.01 rows=166 width=48) (never executed)

448. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=105.92..161.01 rows=166 width=48) (never executed)

  • Hash Cond: (e_31.live_packaging_base_prop_id = base_p_31.packaging_base_prop_id)
449. 0.000 0.000 ↓ 0.0 0

Seq Scan on packagings e_31 (cost=0.00..52.16 rows=1,116 width=52) (never executed)

450. 0.000 0.000 ↓ 0.0 0

Hash (cost=102.02..102.02 rows=312 width=12) (never executed)

451. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_base_props base_p_31 (cost=0.00..102.02 rows=312 width=12) (never executed)

  • Filter: (based_on_packaging_id IS NOT NULL)
452. 0.000 0.000 ↓ 0.0 0

Index Only Scan using packaging_label_props_pkey on packaging_label_props label_p_31 (cost=0.28..0.49 rows=1 width=8) (never executed)

  • Index Cond: (packaging_label_prop_id = e_31.live_packaging_label_prop_id)
  • Heap Fetches: 0
453.          

CTE l1

454. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=251.86..414.53 rows=950 width=12) (never executed)

  • Hash Cond: (label_p_32.packaging_label_prop_id = e_32.live_packaging_label_prop_id)
455. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_label_props label_p_32 (cost=0.00..144.02 rows=2,102 width=8) (never executed)

456. 0.000 0.000 ↓ 0.0 0

Hash (cost=239.98..239.98 rows=950 width=36) (never executed)

457. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=190.50..239.98 rows=950 width=36) (never executed)

  • Hash Cond: (e_32.live_packaging_base_prop_id = base_p_32.packaging_base_prop_id)
458. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=66.11..112.66 rows=1,116 width=44) (never executed)

  • Hash Cond: (tech_p_17.packaging_tech_prop_id = e_32.live_packaging_tech_prop_id)
459. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_tech_props tech_p_17 (cost=0.00..41.02 rows=2,102 width=8) (never executed)

460. 0.000 0.000 ↓ 0.0 0

Hash (cost=52.16..52.16 rows=1,116 width=52) (never executed)

461. 0.000 0.000 ↓ 0.0 0

Seq Scan on packagings e_32 (cost=0.00..52.16 rows=1,116 width=52) (never executed)

462. 0.000 0.000 ↓ 0.0 0

Hash (cost=102.02..102.02 rows=1,790 width=8) (never executed)

463. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_base_props base_p_32 (cost=0.00..102.02 rows=1,790 width=8) (never executed)

  • Filter: (based_on_packaging_id IS NULL)
464.          

CTE l2

465. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.40..37.81 rows=788 width=12) (never executed)

  • Hash Cond: (l1_11.packaging_id = x_16.based_on_packaging_id)
466. 0.000 0.000 ↓ 0.0 0

CTE Scan on l1 l1_11 (cost=0.00..19.00 rows=950 width=12) (never executed)

467. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.32..3.32 rows=166 width=16) (never executed)

468. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_16 (cost=0.00..3.32 rows=166 width=16) (never executed)

469.          

CTE l3

470. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.40..32.28 rows=654 width=12) (never executed)

  • Hash Cond: (l2_11.packaging_id = x_17.based_on_packaging_id)
471. 0.000 0.000 ↓ 0.0 0

CTE Scan on l2 l2_11 (cost=0.00..15.76 rows=788 width=12) (never executed)

472. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.32..3.32 rows=166 width=16) (never executed)

473. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_17 (cost=0.00..3.32 rows=166 width=16) (never executed)

474. 0.000 0.000 ↓ 0.0 0

CTE Scan on l1 l1_12 (cost=0.00..19.00 rows=950 width=16) (never executed)

475. 0.000 0.000 ↓ 0.0 0

CTE Scan on l2 l2_12 (cost=0.00..15.76 rows=788 width=16) (never executed)

476. 0.000 0.000 ↓ 0.0 0

CTE Scan on l3 l3_12 (cost=0.00..13.08 rows=654 width=16) (never executed)

477. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.40..27.71 rows=543 width=16) (never executed)

  • Hash Cond: (l3_13.packaging_id = x_18.based_on_packaging_id)
478. 0.000 0.000 ↓ 0.0 0

CTE Scan on l3 l3_13 (cost=0.00..13.08 rows=654 width=12) (never executed)

479. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.32..3.32 rows=166 width=16) (never executed)

480. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_18 (cost=0.00..3.32 rows=166 width=16) (never executed)

481. 0.000 0.000 ↓ 0.0 0

Hash (cost=52.16..52.16 rows=1,116 width=28) (never executed)

482. 0.000 0.000 ↓ 0.0 0

Seq Scan on packagings e_33 (cost=0.00..52.16 rows=1,116 width=28) (never executed)

483. 0.000 0.000 ↓ 0.0 0

Hash (cost=102.02..102.02 rows=2,102 width=8) (never executed)

484. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_base_props base_p_33 (cost=0.00..102.02 rows=2,102 width=8) (never executed)

485. 0.000 0.000 ↓ 0.0 0

Hash (cost=144.02..144.02 rows=2,102 width=8) (never executed)

486. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_label_props label_p_33 (cost=0.00..144.02 rows=2,102 width=8) (never executed)

487. 0.000 0.000 ↓ 0.0 0

Hash (cost=41.02..41.02 rows=2,102 width=8) (never executed)

488. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_tech_props tech_p_18 (cost=0.00..41.02 rows=2,102 width=8) (never executed)

489. 0.000 0.000 ↓ 0.0 0

Sort (cost=3,111.00..3,113.10 rows=837 width=84) (never executed)

  • Sort Key: base_p_34.packaging_id
490. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,369.01..3,070.37 rows=837 width=84) (never executed)

  • Hash Cond: (base_p_34.product_id = tmp_p_li_4.product_id)
491. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,326.44..2,916.68 rows=618 width=80) (never executed)

  • Hash Cond: (legal_p_4.distributor_id = tmp_d_li1_4.distributor_id)
492. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,325.43..2,907.18 rows=618 width=76) (never executed)

493. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,325.15..1,995.90 rows=618 width=84) (never executed)

494. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,324.87..1,537.46 rows=618 width=92) (never executed)

  • Hash Cond: (tech_p_19.article_tech_prop_id = e_34.live_article_tech_prop_id)
495. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_tech_props tech_p_19 (cost=0.00..180.57 rows=7,257 width=8) (never executed)

496. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,317.14..1,317.14 rows=618 width=100) (never executed)

497. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,136.55..1,317.14 rows=618 width=100) (never executed)

  • Hash Cond: (wvd_p_4.article_wvd_prop_id = e_34.live_article_wvd_prop_id)
498. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_wvd_props wvd_p_4 (cost=0.00..148.57 rows=7,257 width=8) (never executed)

499. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,128.82..1,128.82 rows=618 width=108) (never executed)

500. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=955.23..1,128.82 rows=618 width=108) (never executed)

  • Hash Cond: (legal_p_4.article_legal_prop_id = e_34.live_article_legal_prop_id)
501. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_legal_props legal_p_4 (cost=0.00..141.57 rows=7,257 width=12) (never executed)

502. 0.000 0.000 ↓ 0.0 0

Hash (cost=947.50..947.50 rows=618 width=112) (never executed)

503. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=774.91..947.50 rows=618 width=112) (never executed)

  • Hash Cond: (palettizing_p_4.article_palettizing_prop_id = e_34.live_article_palettizing_prop_id)
504. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_palettizing_props palettizing_p_4 (cost=0.00..140.57 rows=7,257 width=8) (never executed)

505. 0.000 0.000 ↓ 0.0 0

Hash (cost=767.19..767.19 rows=618 width=120) (never executed)

506. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=285.74..767.19 rows=618 width=120) (never executed)

  • Hash Cond: (e_34.live_article_base_prop_id = base_p_34.article_base_prop_id)
507. 0.000 0.000 ↓ 0.0 0

Seq Scan on articles e_34 (cost=0.00..470.80 rows=4,056 width=116) (never executed)

  • Filter: (NOT on_hold)
508. 0.000 0.000 ↓ 0.0 0

Hash (cost=271.91..271.91 rows=1,106 width=20) (never executed)

509. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on article_base_props base_p_34 (cost=40.85..271.91 rows=1,106 width=20) (never executed)

  • Recheck Cond: (based_on_article_id IS NOT NULL)
510. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on article_base_props_based_on_article_id_key (cost=0.00..40.58 rows=1,106 width=0) (never executed)

  • Index Cond: (based_on_article_id IS NOT NULL)
511. 0.000 0.000 ↓ 0.0 0

Index Only Scan using article_label_props_pkey on article_label_props label_p_34 (cost=0.28..0.74 rows=1 width=8) (never executed)

  • Index Cond: (article_label_prop_id = e_34.live_article_label_prop_id)
  • Heap Fetches: 0
512. 0.000 0.000 ↓ 0.0 0

Index Only Scan using article_sr_props_pkey on article_sr_props sr_p_9 (cost=0.28..1.47 rows=1 width=8) (never executed)

  • Index Cond: (article_sr_prop_id = e_34.live_article_sr_prop_id)
  • Heap Fetches: 0
513. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.62..0.62 rows=31 width=12) (never executed)

514. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_d_li1 tmp_d_li1_4 (cost=0.00..0.62 rows=31 width=12) (never executed)

515. 0.000 0.000 ↓ 0.0 0

Hash (cost=26.20..26.20 rows=1,310 width=12) (never executed)

516. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_p_li tmp_p_li_4 (cost=0.00..26.20 rows=1,310 width=12) (never executed)

517. 0.000 0.000 ↓ 0.0 0

Sort (cost=227.74..235.08 rows=2,935 width=12) (never executed)

  • Sort Key: tmp_pkg_li_4.packaging_id
518. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_pkg_li tmp_pkg_li_4 (cost=0.00..58.70 rows=2,935 width=12) (never executed)

519.          

CTE l1

520. 0.000 0.000 ↓ 0.0 0

Subquery Scan on article_live_items2_3 (cost=6,880.57..7,566.31 rows=14,809 width=12) (never executed)

521. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=6,880.57..7,418.22 rows=14,809 width=767) (never executed)

  • Hash Cond: (tmp_pkg_li_5.packaging_id = base_p_41.packaging_id)
522.          

CTE tmp_d_li1

523. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3.89..8.74 rows=31 width=12) (never executed)

  • Hash Cond: (e_35.live_distributor_base_prop_id = base_p_35.distributor_base_prop_id)
524. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.70..6.38 rows=31 width=28) (never executed)

  • Hash Cond: (label_p_35.distributor_label_prop_id = e_35.live_distributor_label_prop_id)
525. 0.000 0.000 ↓ 0.0 0

Seq Scan on distributor_label_props label_p_35 (cost=0.00..4.53 rows=53 width=8) (never executed)

526. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.31..1.31 rows=31 width=36) (never executed)

527. 0.000 0.000 ↓ 0.0 0

Seq Scan on distributors e_35 (cost=0.00..1.31 rows=31 width=36) (never executed)

528. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.53..1.53 rows=53 width=8) (never executed)

529. 0.000 0.000 ↓ 0.0 0

Seq Scan on distributor_base_props base_p_35 (cost=0.00..1.53 rows=53 width=8) (never executed)

530.          

CTE tmp_p_li

531. 0.000 0.000 ↓ 0.0 0

Subquery Scan on product_live_items_5 (cost=773.94..1,265.42 rows=1,310 width=12) (never executed)

532. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=773.94..1,252.32 rows=1,310 width=828) (never executed)

  • Hash Cond: (e_37.live_product_econtent_prop_id = econtent_p_5.product_econtent_prop_id)
533.          

CTE tmp_li1

534. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=45.19..82.95 rows=270 width=12) (never executed)

  • Hash Cond: (label_p_36.brand_label_prop_id = e_36.live_brand_label_prop_id)
535. 0.000 0.000 ↓ 0.0 0

Seq Scan on brand_label_props label_p_36 (cost=0.00..33.54 rows=454 width=8) (never executed)

536. 0.000 0.000 ↓ 0.0 0

Hash (cost=41.82..41.82 rows=270 width=28) (never executed)

537. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=10.07..41.82 rows=270 width=28) (never executed)

  • Hash Cond: (base_p_36.brand_base_prop_id = e_36.live_brand_base_prop_id)
538. 0.000 0.000 ↓ 0.0 0

Seq Scan on brand_base_props base_p_36 (cost=0.00..30.54 rows=454 width=8) (never executed)

539. 0.000 0.000 ↓ 0.0 0

Hash (cost=6.70..6.70 rows=270 width=36) (never executed)

540. 0.000 0.000 ↓ 0.0 0

Seq Scan on brands e_36 (cost=0.00..6.70 rows=270 width=36) (never executed)

541. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=424.20..892.59 rows=1,310 width=52) (never executed)

  • Hash Cond: (e_37.live_product_label_prop_id = label_p_37.product_label_prop_id)
542. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=307.62..772.57 rows=1,310 width=60) (never executed)

  • Hash Cond: (sr_p_10.product_sr_prop_id = e_37.live_product_sr_prop_id)
543. 0.000 0.000 ↓ 0.0 0

Seq Scan on product_sr_props sr_p_10 (cost=0.00..446.83 rows=2,283 width=8) (never executed)

544. 0.000 0.000 ↓ 0.0 0

Hash (cost=291.24..291.24 rows=1,310 width=68) (never executed)

545. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=254.52..291.24 rows=1,310 width=68) (never executed)

  • Hash Cond: (tmp_li1_5.brand_id = base_p_37.brand_id)
546. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_li1 tmp_li1_5 (cost=0.00..5.40 rows=270 width=12) (never executed)

547. 0.000 0.000 ↓ 0.0 0

Hash (cost=238.02..238.02 rows=1,320 width=64) (never executed)

548. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=83.70..238.02 rows=1,320 width=64) (never executed)

  • Hash Cond: (base_p_37.product_base_prop_id = e_37.live_product_base_prop_id)
549. 0.000 0.000 ↓ 0.0 0

Seq Scan on product_base_props base_p_37 (cost=0.00..148.42 rows=2,242 width=12) (never executed)

550. 0.000 0.000 ↓ 0.0 0

Hash (cost=67.20..67.20 rows=1,320 width=68) (never executed)

551. 0.000 0.000 ↓ 0.0 0

Seq Scan on products e_37 (cost=0.00..67.20 rows=1,320 width=68) (never executed)

552. 0.000 0.000 ↓ 0.0 0

Hash (cost=88.48..88.48 rows=2,248 width=8) (never executed)

553. 0.000 0.000 ↓ 0.0 0

Seq Scan on product_label_props label_p_37 (cost=0.00..88.48 rows=2,248 width=8) (never executed)

554. 0.000 0.000 ↓ 0.0 0

Hash (cost=238.77..238.77 rows=2,242 width=8) (never executed)

555. 0.000 0.000 ↓ 0.0 0

Index Only Scan using product_econtent_props_pkey on product_econtent_props econtent_p_5 (cost=0.28..238.77 rows=2,242 width=8) (never executed)

  • Heap Fetches: 0
556.          

CTE tmp_pkg_li

557. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,211.40..1,367.30 rows=2,935 width=12) (never executed)

  • Hash Cond: (e_40.live_packaging_tech_prop_id = tech_p_22.packaging_tech_prop_id)
558. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,144.11..1,292.29 rows=2,935 width=20) (never executed)

  • Hash Cond: (e_40.live_packaging_label_prop_id = label_p_40.packaging_label_prop_id)
559. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=973.81..1,114.28 rows=2,935 width=28) (never executed)

  • Hash Cond: (e_40.live_packaging_base_prop_id = base_p_40.packaging_base_prop_id)
560. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=845.52..978.27 rows=2,935 width=36) (never executed)

  • Hash Cond: (l1_14.packaging_id = e_40.packaging_id)
561. 0.000 0.000 ↓ 0.0 0

Append (cost=779.41..875.07 rows=2,935 width=16) (never executed)

562.          

CTE lnot1

563. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=163.36..294.79 rows=166 width=16) (never executed)

564. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=163.08..213.46 rows=166 width=40) (never executed)

  • Hash Cond: (tech_p_20.packaging_tech_prop_id = e_38.live_packaging_tech_prop_id)
565. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_tech_props tech_p_20 (cost=0.00..41.02 rows=2,102 width=8) (never executed)

566. 0.000 0.000 ↓ 0.0 0

Hash (cost=161.01..161.01 rows=166 width=48) (never executed)

567. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=105.92..161.01 rows=166 width=48) (never executed)

  • Hash Cond: (e_38.live_packaging_base_prop_id = base_p_38.packaging_base_prop_id)
568. 0.000 0.000 ↓ 0.0 0

Seq Scan on packagings e_38 (cost=0.00..52.16 rows=1,116 width=52) (never executed)

569. 0.000 0.000 ↓ 0.0 0

Hash (cost=102.02..102.02 rows=312 width=12) (never executed)

570. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_base_props base_p_38 (cost=0.00..102.02 rows=312 width=12) (never executed)

  • Filter: (based_on_packaging_id IS NOT NULL)
571. 0.000 0.000 ↓ 0.0 0

Index Only Scan using packaging_label_props_pkey on packaging_label_props label_p_38 (cost=0.28..0.49 rows=1 width=8) (never executed)

  • Index Cond: (packaging_label_prop_id = e_38.live_packaging_label_prop_id)
  • Heap Fetches: 0
572.          

CTE l1

573. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=251.86..414.53 rows=950 width=12) (never executed)

  • Hash Cond: (label_p_39.packaging_label_prop_id = e_39.live_packaging_label_prop_id)
574. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_label_props label_p_39 (cost=0.00..144.02 rows=2,102 width=8) (never executed)

575. 0.000 0.000 ↓ 0.0 0

Hash (cost=239.98..239.98 rows=950 width=36) (never executed)

576. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=190.50..239.98 rows=950 width=36) (never executed)

  • Hash Cond: (e_39.live_packaging_base_prop_id = base_p_39.packaging_base_prop_id)
577. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=66.11..112.66 rows=1,116 width=44) (never executed)

  • Hash Cond: (tech_p_21.packaging_tech_prop_id = e_39.live_packaging_tech_prop_id)
578. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_tech_props tech_p_21 (cost=0.00..41.02 rows=2,102 width=8) (never executed)

579. 0.000 0.000 ↓ 0.0 0

Hash (cost=52.16..52.16 rows=1,116 width=52) (never executed)

580. 0.000 0.000 ↓ 0.0 0

Seq Scan on packagings e_39 (cost=0.00..52.16 rows=1,116 width=52) (never executed)

581. 0.000 0.000 ↓ 0.0 0

Hash (cost=102.02..102.02 rows=1,790 width=8) (never executed)

582. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_base_props base_p_39 (cost=0.00..102.02 rows=1,790 width=8) (never executed)

  • Filter: (based_on_packaging_id IS NULL)
583.          

CTE l2

584. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.40..37.81 rows=788 width=12) (never executed)

  • Hash Cond: (l1_13.packaging_id = x_19.based_on_packaging_id)
585. 0.000 0.000 ↓ 0.0 0

CTE Scan on l1 l1_13 (cost=0.00..19.00 rows=950 width=12) (never executed)

586. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.32..3.32 rows=166 width=16) (never executed)

587. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_19 (cost=0.00..3.32 rows=166 width=16) (never executed)

588.          

CTE l3

589. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.40..32.28 rows=654 width=12) (never executed)

  • Hash Cond: (l2_13.packaging_id = x_20.based_on_packaging_id)
590. 0.000 0.000 ↓ 0.0 0

CTE Scan on l2 l2_13 (cost=0.00..15.76 rows=788 width=12) (never executed)

591. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.32..3.32 rows=166 width=16) (never executed)

592. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_20 (cost=0.00..3.32 rows=166 width=16) (never executed)

593. 0.000 0.000 ↓ 0.0 0

CTE Scan on l1 l1_14 (cost=0.00..19.00 rows=950 width=16) (never executed)

594. 0.000 0.000 ↓ 0.0 0

CTE Scan on l2 l2_14 (cost=0.00..15.76 rows=788 width=16) (never executed)

595. 0.000 0.000 ↓ 0.0 0

CTE Scan on l3 l3_14 (cost=0.00..13.08 rows=654 width=16) (never executed)

596. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.40..27.71 rows=543 width=16) (never executed)

  • Hash Cond: (l3_15.packaging_id = x_21.based_on_packaging_id)
597. 0.000 0.000 ↓ 0.0 0

CTE Scan on l3 l3_15 (cost=0.00..13.08 rows=654 width=12) (never executed)

598. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.32..3.32 rows=166 width=16) (never executed)

599. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_21 (cost=0.00..3.32 rows=166 width=16) (never executed)

600. 0.000 0.000 ↓ 0.0 0

Hash (cost=52.16..52.16 rows=1,116 width=28) (never executed)

601. 0.000 0.000 ↓ 0.0 0

Seq Scan on packagings e_40 (cost=0.00..52.16 rows=1,116 width=28) (never executed)

602. 0.000 0.000 ↓ 0.0 0

Hash (cost=102.02..102.02 rows=2,102 width=8) (never executed)

603. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_base_props base_p_40 (cost=0.00..102.02 rows=2,102 width=8) (never executed)

604. 0.000 0.000 ↓ 0.0 0

Hash (cost=144.02..144.02 rows=2,102 width=8) (never executed)

605. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_label_props label_p_40 (cost=0.00..144.02 rows=2,102 width=8) (never executed)

606. 0.000 0.000 ↓ 0.0 0

Hash (cost=41.02..41.02 rows=2,102 width=8) (never executed)

607. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_tech_props tech_p_22 (cost=0.00..41.02 rows=2,102 width=8) (never executed)

608. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_pkg_li tmp_pkg_li_5 (cost=0.00..58.70 rows=2,935 width=12) (never executed)

609. 0.000 0.000 ↓ 0.0 0

Hash (cost=4,180.90..4,180.90 rows=4,657 width=80) (never executed)

610. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3,816.48..4,180.90 rows=4,657 width=80) (never executed)

  • Hash Cond: (legal_p_5.distributor_id = tmp_d_li1_5.distributor_id)
611. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3,815.48..4,115.86 rows=4,657 width=76) (never executed)

  • Hash Cond: (tmp_p_li_5.product_id = base_p_41.product_id)
612. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_p_li tmp_p_li_5 (cost=0.00..26.20 rows=1,310 width=12) (never executed)

613. 0.000 0.000 ↓ 0.0 0

Hash (cost=3,772.50..3,772.50 rows=3,438 width=72) (never executed)

614. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2,442.85..3,772.50 rows=3,438 width=72) (never executed)

  • Hash Cond: (e_41.live_article_palettizing_prop_id = palettizing_p_5.article_palettizing_prop_id)
615. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2,211.57..3,532.19 rows=3,438 width=80) (never executed)

  • Hash Cond: (e_41.live_article_tech_prop_id = tech_p_23.article_tech_prop_id)
616. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,940.28..3,251.89 rows=3,438 width=88) (never executed)

  • Hash Cond: (e_41.live_article_wvd_prop_id = wvd_p_5.article_wvd_prop_id)
617. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,701.00..3,003.58 rows=3,438 width=96) (never executed)

  • Hash Cond: (e_41.live_article_legal_prop_id = legal_p_5.article_legal_prop_id)
618. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,468.72..2,762.27 rows=3,438 width=100) (never executed)

  • Hash Cond: (sr_p_11.article_sr_prop_id = e_41.live_article_sr_prop_id)
619. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_sr_props sr_p_11 (cost=0.00..1,239.57 rows=7,257 width=8) (never executed)

620. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,425.74..1,425.74 rows=3,438 width=108) (never executed)

621. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=873.19..1,425.74 rows=3,438 width=108) (never executed)

  • Hash Cond: (label_p_41.article_label_prop_id = e_41.live_article_label_prop_id)
622. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_label_props label_p_41 (cost=0.00..498.57 rows=7,257 width=8) (never executed)

623. 0.000 0.000 ↓ 0.0 0

Hash (cost=830.21..830.21 rows=3,438 width=116) (never executed)

624. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=521.50..830.21 rows=3,438 width=116) (never executed)

  • Hash Cond: (base_p_41.article_base_prop_id = e_41.live_article_base_prop_id)
625. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_base_props base_p_41 (cost=0.00..292.56 rows=6,150 width=16) (never executed)

  • Filter: (based_on_article_id IS NULL)
626. 0.000 0.000 ↓ 0.0 0

Hash (cost=470.80..470.80 rows=4,056 width=116) (never executed)

627. 0.000 0.000 ↓ 0.0 0

Seq Scan on articles e_41 (cost=0.00..470.80 rows=4,056 width=116) (never executed)

  • Filter: (NOT on_hold)
628. 0.000 0.000 ↓ 0.0 0

Hash (cost=141.57..141.57 rows=7,257 width=12) (never executed)

629. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_legal_props legal_p_5 (cost=0.00..141.57 rows=7,257 width=12) (never executed)

630. 0.000 0.000 ↓ 0.0 0

Hash (cost=148.57..148.57 rows=7,257 width=8) (never executed)

631. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_wvd_props wvd_p_5 (cost=0.00..148.57 rows=7,257 width=8) (never executed)

632. 0.000 0.000 ↓ 0.0 0

Hash (cost=180.57..180.57 rows=7,257 width=8) (never executed)

633. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_tech_props tech_p_23 (cost=0.00..180.57 rows=7,257 width=8) (never executed)

634. 0.000 0.000 ↓ 0.0 0

Hash (cost=140.57..140.57 rows=7,257 width=8) (never executed)

635. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_palettizing_props palettizing_p_5 (cost=0.00..140.57 rows=7,257 width=8) (never executed)

636. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.62..0.62 rows=31 width=12) (never executed)

637. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_d_li1 tmp_d_li1_5 (cost=0.00..0.62 rows=31 width=12) (never executed)

638.          

CTE l2

639. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,526.70..4,989.40 rows=197,108 width=12) (never executed)

  • Merge Cond: (x_22.based_on_article_id = l1_15.article_id)
640. 0.000 0.000 ↓ 0.0 0

Sort (cost=204.69..211.34 rows=2,662 width=16) (never executed)

  • Sort Key: x_22.based_on_article_id
641. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_22 (cost=0.00..53.24 rows=2,662 width=16) (never executed)

642. 0.000 0.000 ↓ 0.0 0

Sort (cost=1,322.01..1,359.04 rows=14,809 width=12) (never executed)

  • Sort Key: l1_15.article_id
643. 0.000 0.000 ↓ 0.0 0

CTE Scan on l1 l1_15 (cost=0.00..296.18 rows=14,809 width=12) (never executed)

644.          

CTE l3

645. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=21,481.14..67,405.82 rows=2,623,507 width=12) (never executed)

  • Merge Cond: (x_23.based_on_article_id = l2_15.article_id)
646. 0.000 0.000 ↓ 0.0 0

Sort (cost=204.69..211.34 rows=2,662 width=16) (never executed)

  • Sort Key: x_23.based_on_article_id
647. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_23 (cost=0.00..53.24 rows=2,662 width=16) (never executed)

648. 0.000 0.000 ↓ 0.0 0

Sort (cost=21,276.46..21,769.23 rows=197,108 width=12) (never executed)

  • Sort Key: l2_15.article_id
649. 0.000 0.000 ↓ 0.0 0

CTE Scan on l2 l2_15 (cost=0.00..3,942.16 rows=197,108 width=12) (never executed)

650. 0.000 0.000 ↓ 0.0 0

CTE Scan on l1 l1_1 (cost=0.00..296.18 rows=14,809 width=16) (never executed)

651. 0.000 0.000 ↓ 0.0 0

CTE Scan on l2 l2_1 (cost=0.00..3,942.16 rows=197,108 width=16) (never executed)

652. 0.000 0.000 ↓ 0.0 0

CTE Scan on l3 l3_2 (cost=0.00..52,470.14 rows=2,623,507 width=16) (never executed)

653. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=377,219.38..994,871.82 rows=34,918,878 width=16) (never executed)

  • Merge Cond: (x_1.based_on_article_id = l3_3.article_id)
654. 0.000 0.000 ↓ 0.0 0

Sort (cost=204.69..211.34 rows=2,662 width=16) (never executed)

  • Sort Key: x_1.based_on_article_id
655. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_1 (cost=0.00..53.24 rows=2,662 width=16) (never executed)

656. 0.000 0.000 ↓ 0.0 0

Materialize (cost=377,014.69..390,132.23 rows=2,623,507 width=12) (never executed)

657. 0.000 0.000 ↓ 0.0 0

Sort (cost=377,014.69..383,573.46 rows=2,623,507 width=12) (never executed)

  • Sort Key: l3_3.article_id
658. 0.000 0.000 ↓ 0.0 0

CTE Scan on l3 l3_3 (cost=0.00..52,470.14 rows=2,623,507 width=12) (never executed)

659. 0.000 2,771.559 ↓ 0.0 0 1

Hash (cost=7,862.52..7,862.52 rows=200 width=16) (actual time=2,771.559..2,771.559 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
660. 0.002 2,771.559 ↓ 0.0 0 1

Hash Join (cost=7,857.27..7,862.52 rows=200 width=16) (actual time=2,771.558..2,771.559 rows=0 loops=1)

  • Hash Cond: (get_change_notification_pending_changes_on_reactivated_entities.article_id = r_1.article_id)
661. 0.002 2,771.557 ↓ 0.0 0 1

Sort (cost=34.89..35.39 rows=200 width=92) (actual time=2,771.557..2,771.557 rows=0 loops=1)

  • Sort Key: get_change_notification_pending_changes_on_reactivated_entities.rcpt_id, get_change_notification_pending_changes_on_reactivated_entities.article_id, get_change_notification_pending_changes_on_reactivated_entities.eh_dt, get_change_notification_pending_changes_on_reactivated_entities.eh_id
  • Sort Method: quicksort Memory: 25kB
662. 0.002 2,771.555 ↓ 0.0 0 1

HashAggregate (cost=25.25..27.25 rows=200 width=92) (actual time=2,771.555..2,771.555 rows=0 loops=1)

  • Group Key: get_change_notification_pending_changes_on_reactivated_entities.rcpt_id, get_change_notification_pending_changes_on_reactivated_entities.article_id, get_change_notification_pending_changes_on_reactivated_entities.eh_dt, get_change_notification_pending_changes_on_reactivated_entities.eh_id, get_change_notification_pending_changes_on_reactivated_entities.action, get_change_notification_pending_changes_on_reactivated_entities.comment
663. 2,771.553 2,771.553 ↓ 0.0 0 1

Function Scan on get_change_notification_pending_changes_on_reactivated_entities (cost=0.25..10.25 rows=1,000 width=92) (actual time=2,771.553..2,771.553 rows=0 loops=1)

664. 0.000 0.000 ↓ 0.0 0

Hash (cost=7,605.27..7,605.27 rows=17,368 width=4) (never executed)

665. 0.000 0.000 ↓ 0.0 0

Subquery Scan on r_1 (cost=6,942.40..7,605.27 rows=17,368 width=4) (never executed)

666. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=6,942.40..7,431.59 rows=17,368 width=767) (never executed)

  • Hash Cond: (tmp_pkg_li_1.packaging_id = base_p_1.packaging_id)
667.          

CTE tmp_d_li1

668. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3.89..8.74 rows=31 width=12) (never executed)

  • Hash Cond: (e_22.live_distributor_base_prop_id = base_p_22.distributor_base_prop_id)
669. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.70..6.38 rows=31 width=28) (never executed)

  • Hash Cond: (label_p_22.distributor_label_prop_id = e_22.live_distributor_label_prop_id)
670. 0.000 0.000 ↓ 0.0 0

Seq Scan on distributor_label_props label_p_22 (cost=0.00..4.53 rows=53 width=8) (never executed)

671. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.31..1.31 rows=31 width=36) (never executed)

672. 0.000 0.000 ↓ 0.0 0

Seq Scan on distributors e_22 (cost=0.00..1.31 rows=31 width=36) (never executed)

673. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.53..1.53 rows=53 width=8) (never executed)

674. 0.000 0.000 ↓ 0.0 0

Seq Scan on distributor_base_props base_p_22 (cost=0.00..1.53 rows=53 width=8) (never executed)

675.          

CTE tmp_p_li

676. 0.000 0.000 ↓ 0.0 0

Subquery Scan on product_live_items_3 (cost=773.94..1,265.42 rows=1,310 width=12) (never executed)

677. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=773.94..1,252.32 rows=1,310 width=828) (never executed)

  • Hash Cond: (e_24.live_product_econtent_prop_id = econtent_p_3.product_econtent_prop_id)
678.          

CTE tmp_li1

679. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=45.19..82.95 rows=270 width=12) (never executed)

  • Hash Cond: (label_p_23.brand_label_prop_id = e_23.live_brand_label_prop_id)
680. 0.000 0.000 ↓ 0.0 0

Seq Scan on brand_label_props label_p_23 (cost=0.00..33.54 rows=454 width=8) (never executed)

681. 0.000 0.000 ↓ 0.0 0

Hash (cost=41.82..41.82 rows=270 width=28) (never executed)

682. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=10.07..41.82 rows=270 width=28) (never executed)

  • Hash Cond: (base_p_23.brand_base_prop_id = e_23.live_brand_base_prop_id)
683. 0.000 0.000 ↓ 0.0 0

Seq Scan on brand_base_props base_p_23 (cost=0.00..30.54 rows=454 width=8) (never executed)

684. 0.000 0.000 ↓ 0.0 0

Hash (cost=6.70..6.70 rows=270 width=36) (never executed)

685. 0.000 0.000 ↓ 0.0 0

Seq Scan on brands e_23 (cost=0.00..6.70 rows=270 width=36) (never executed)

686. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=424.20..892.59 rows=1,310 width=52) (never executed)

  • Hash Cond: (e_24.live_product_label_prop_id = label_p_24.product_label_prop_id)
687. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=307.62..772.57 rows=1,310 width=60) (never executed)

  • Hash Cond: (sr_p_7.product_sr_prop_id = e_24.live_product_sr_prop_id)
688. 0.000 0.000 ↓ 0.0 0

Seq Scan on product_sr_props sr_p_7 (cost=0.00..446.83 rows=2,283 width=8) (never executed)

689. 0.000 0.000 ↓ 0.0 0

Hash (cost=291.24..291.24 rows=1,310 width=68) (never executed)

690. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=254.52..291.24 rows=1,310 width=68) (never executed)

  • Hash Cond: (tmp_li1_3.brand_id = base_p_24.brand_id)
691. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_li1 tmp_li1_3 (cost=0.00..5.40 rows=270 width=12) (never executed)

692. 0.000 0.000 ↓ 0.0 0

Hash (cost=238.02..238.02 rows=1,320 width=64) (never executed)

693. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=83.70..238.02 rows=1,320 width=64) (never executed)

  • Hash Cond: (base_p_24.product_base_prop_id = e_24.live_product_base_prop_id)
694. 0.000 0.000 ↓ 0.0 0

Seq Scan on product_base_props base_p_24 (cost=0.00..148.42 rows=2,242 width=12) (never executed)

695. 0.000 0.000 ↓ 0.0 0

Hash (cost=67.20..67.20 rows=1,320 width=68) (never executed)

696. 0.000 0.000 ↓ 0.0 0

Seq Scan on products e_24 (cost=0.00..67.20 rows=1,320 width=68) (never executed)

697. 0.000 0.000 ↓ 0.0 0

Hash (cost=88.48..88.48 rows=2,248 width=8) (never executed)

698. 0.000 0.000 ↓ 0.0 0

Seq Scan on product_label_props label_p_24 (cost=0.00..88.48 rows=2,248 width=8) (never executed)

699. 0.000 0.000 ↓ 0.0 0

Hash (cost=238.77..238.77 rows=2,242 width=8) (never executed)

700. 0.000 0.000 ↓ 0.0 0

Index Only Scan using product_econtent_props_pkey on product_econtent_props econtent_p_3 (cost=0.28..238.77 rows=2,242 width=8) (never executed)

  • Heap Fetches: 0
701.          

CTE tmp_pkg_li

702. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,211.40..1,367.30 rows=2,935 width=12) (never executed)

  • Hash Cond: (e_27.live_packaging_tech_prop_id = tech_p_15.packaging_tech_prop_id)
703. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,144.11..1,292.29 rows=2,935 width=20) (never executed)

  • Hash Cond: (e_27.live_packaging_label_prop_id = label_p_27.packaging_label_prop_id)
704. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=973.81..1,114.28 rows=2,935 width=28) (never executed)

  • Hash Cond: (e_27.live_packaging_base_prop_id = base_p_27.packaging_base_prop_id)
705. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=845.52..978.27 rows=2,935 width=36) (never executed)

  • Hash Cond: (l1_10.packaging_id = e_27.packaging_id)
706. 0.000 0.000 ↓ 0.0 0

Append (cost=779.41..875.07 rows=2,935 width=16) (never executed)

707.          

CTE lnot1

708. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=163.36..294.79 rows=166 width=16) (never executed)

709. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=163.08..213.46 rows=166 width=40) (never executed)

  • Hash Cond: (tech_p_13.packaging_tech_prop_id = e_25.live_packaging_tech_prop_id)
710. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_tech_props tech_p_13 (cost=0.00..41.02 rows=2,102 width=8) (never executed)

711. 0.000 0.000 ↓ 0.0 0

Hash (cost=161.01..161.01 rows=166 width=48) (never executed)

712. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=105.92..161.01 rows=166 width=48) (never executed)

  • Hash Cond: (e_25.live_packaging_base_prop_id = base_p_25.packaging_base_prop_id)
713. 0.000 0.000 ↓ 0.0 0

Seq Scan on packagings e_25 (cost=0.00..52.16 rows=1,116 width=52) (never executed)

714. 0.000 0.000 ↓ 0.0 0

Hash (cost=102.02..102.02 rows=312 width=12) (never executed)

715. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_base_props base_p_25 (cost=0.00..102.02 rows=312 width=12) (never executed)

  • Filter: (based_on_packaging_id IS NOT NULL)
716. 0.000 0.000 ↓ 0.0 0

Index Only Scan using packaging_label_props_pkey on packaging_label_props label_p_25 (cost=0.28..0.49 rows=1 width=8) (never executed)

  • Index Cond: (packaging_label_prop_id = e_25.live_packaging_label_prop_id)
  • Heap Fetches: 0
717.          

CTE l1

718. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=251.86..414.53 rows=950 width=12) (never executed)

  • Hash Cond: (label_p_26.packaging_label_prop_id = e_26.live_packaging_label_prop_id)
719. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_label_props label_p_26 (cost=0.00..144.02 rows=2,102 width=8) (never executed)

720. 0.000 0.000 ↓ 0.0 0

Hash (cost=239.98..239.98 rows=950 width=36) (never executed)

721. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=190.50..239.98 rows=950 width=36) (never executed)

  • Hash Cond: (e_26.live_packaging_base_prop_id = base_p_26.packaging_base_prop_id)
722. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=66.11..112.66 rows=1,116 width=44) (never executed)

  • Hash Cond: (tech_p_14.packaging_tech_prop_id = e_26.live_packaging_tech_prop_id)
723. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_tech_props tech_p_14 (cost=0.00..41.02 rows=2,102 width=8) (never executed)

724. 0.000 0.000 ↓ 0.0 0

Hash (cost=52.16..52.16 rows=1,116 width=52) (never executed)

725. 0.000 0.000 ↓ 0.0 0

Seq Scan on packagings e_26 (cost=0.00..52.16 rows=1,116 width=52) (never executed)

726. 0.000 0.000 ↓ 0.0 0

Hash (cost=102.02..102.02 rows=1,790 width=8) (never executed)

727. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_base_props base_p_26 (cost=0.00..102.02 rows=1,790 width=8) (never executed)

  • Filter: (based_on_packaging_id IS NULL)
728.          

CTE l2

729. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.40..37.81 rows=788 width=12) (never executed)

  • Hash Cond: (l1_9.packaging_id = x_13.based_on_packaging_id)
730. 0.000 0.000 ↓ 0.0 0

CTE Scan on l1 l1_9 (cost=0.00..19.00 rows=950 width=12) (never executed)

731. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.32..3.32 rows=166 width=16) (never executed)

732. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_13 (cost=0.00..3.32 rows=166 width=16) (never executed)

733.          

CTE l3

734. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.40..32.28 rows=654 width=12) (never executed)

  • Hash Cond: (l2_9.packaging_id = x_14.based_on_packaging_id)
735. 0.000 0.000 ↓ 0.0 0

CTE Scan on l2 l2_9 (cost=0.00..15.76 rows=788 width=12) (never executed)

736. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.32..3.32 rows=166 width=16) (never executed)

737. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_14 (cost=0.00..3.32 rows=166 width=16) (never executed)

738. 0.000 0.000 ↓ 0.0 0

CTE Scan on l1 l1_10 (cost=0.00..19.00 rows=950 width=16) (never executed)

739. 0.000 0.000 ↓ 0.0 0

CTE Scan on l2 l2_10 (cost=0.00..15.76 rows=788 width=16) (never executed)

740. 0.000 0.000 ↓ 0.0 0

CTE Scan on l3 l3_10 (cost=0.00..13.08 rows=654 width=16) (never executed)

741. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.40..27.71 rows=543 width=16) (never executed)

  • Hash Cond: (l3_11.packaging_id = x_15.based_on_packaging_id)
742. 0.000 0.000 ↓ 0.0 0

CTE Scan on l3 l3_11 (cost=0.00..13.08 rows=654 width=12) (never executed)

743. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.32..3.32 rows=166 width=16) (never executed)

744. 0.000 0.000 ↓ 0.0 0

CTE Scan on lnot1 x_15 (cost=0.00..3.32 rows=166 width=16) (never executed)

745. 0.000 0.000 ↓ 0.0 0

Hash (cost=52.16..52.16 rows=1,116 width=28) (never executed)

746. 0.000 0.000 ↓ 0.0 0

Seq Scan on packagings e_27 (cost=0.00..52.16 rows=1,116 width=28) (never executed)

747. 0.000 0.000 ↓ 0.0 0

Hash (cost=102.02..102.02 rows=2,102 width=8) (never executed)

748. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_base_props base_p_27 (cost=0.00..102.02 rows=2,102 width=8) (never executed)

749. 0.000 0.000 ↓ 0.0 0

Hash (cost=144.02..144.02 rows=2,102 width=8) (never executed)

750. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_label_props label_p_27 (cost=0.00..144.02 rows=2,102 width=8) (never executed)

751. 0.000 0.000 ↓ 0.0 0

Hash (cost=41.02..41.02 rows=2,102 width=8) (never executed)

752. 0.000 0.000 ↓ 0.0 0

Seq Scan on packaging_tech_props tech_p_15 (cost=0.00..41.02 rows=2,102 width=8) (never executed)

753. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_pkg_li tmp_pkg_li_1 (cost=0.00..58.70 rows=2,935 width=4) (never executed)

754. 0.000 0.000 ↓ 0.0 0

Hash (cost=4,232.67..4,232.67 rows=5,462 width=8) (never executed)

755. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3,849.13..4,232.67 rows=5,462 width=8) (never executed)

  • Hash Cond: (legal_p_1.distributor_id = tmp_d_li1_1.distributor_id)
756. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3,848.12..4,156.56 rows=5,462 width=12) (never executed)

  • Hash Cond: (tmp_p_li_1.product_id = base_p_1.product_id)
757. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_p_li tmp_p_li_1 (cost=0.00..26.20 rows=1,310 width=4) (never executed)

758. 0.000 0.000 ↓ 0.0 0

Hash (cost=3,797.72..3,797.72 rows=4,032 width=16) (never executed)

759. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2,446.62..3,797.72 rows=4,032 width=16) (never executed)

  • Hash Cond: (e_1.live_article_palettizing_prop_id = palettizing_p_1.article_palettizing_prop_id)
760. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2,215.34..3,555.86 rows=4,032 width=24) (never executed)

  • Hash Cond: (e_1.live_article_tech_prop_id = tech_p_1.article_tech_prop_id)
761. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,944.06..3,273.99 rows=4,032 width=32) (never executed)

  • Hash Cond: (e_1.live_article_wvd_prop_id = wvd_p_1.article_wvd_prop_id)
762. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,704.77..3,024.12 rows=4,032 width=40) (never executed)

  • Hash Cond: (e_1.live_article_legal_prop_id = legal_p_1.article_legal_prop_id)
763. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,472.49..2,781.26 rows=4,032 width=44) (never executed)

  • Hash Cond: (e_1.live_article_base_prop_id = base_p_1.article_base_prop_id)
764. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,089.23..2,387.41 rows=4,032 width=44) (never executed)

  • Hash Cond: (sr_p_1.article_sr_prop_id = e_1.live_article_sr_prop_id)
765. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_sr_props sr_p_1 (cost=0.00..1,239.57 rows=7,257 width=8) (never executed)

766. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,038.83..1,038.83 rows=4,032 width=52) (never executed)

767. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=521.20..1,038.83 rows=4,032 width=52) (never executed)

  • Hash Cond: (label_p_1.article_label_prop_id = e_1.live_article_label_prop_id)
768. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_label_props label_p_1 (cost=0.00..498.57 rows=7,257 width=8) (never executed)

769. 0.000 0.000 ↓ 0.0 0

Hash (cost=470.80..470.80 rows=4,032 width=60) (never executed)

770. 0.000 0.000 ↓ 0.0 0

Seq Scan on articles e_1 (cost=0.00..470.80 rows=4,032 width=60) (never executed)

  • Filter: ((NOT on_hold) AND (NOT on_hold))
771. 0.000 0.000 ↓ 0.0 0

Hash (cost=292.56..292.56 rows=7,256 width=16) (never executed)

772. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_base_props base_p_1 (cost=0.00..292.56 rows=7,256 width=16) (never executed)

773. 0.000 0.000 ↓ 0.0 0

Hash (cost=141.57..141.57 rows=7,257 width=12) (never executed)

774. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_legal_props legal_p_1 (cost=0.00..141.57 rows=7,257 width=12) (never executed)

775. 0.000 0.000 ↓ 0.0 0

Hash (cost=148.57..148.57 rows=7,257 width=8) (never executed)

776. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_wvd_props wvd_p_1 (cost=0.00..148.57 rows=7,257 width=8) (never executed)

777. 0.000 0.000 ↓ 0.0 0

Hash (cost=180.57..180.57 rows=7,257 width=8) (never executed)

778. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_tech_props tech_p_1 (cost=0.00..180.57 rows=7,257 width=8) (never executed)

779. 0.000 0.000 ↓ 0.0 0

Hash (cost=140.57..140.57 rows=7,257 width=8) (never executed)

780. 0.000 0.000 ↓ 0.0 0

Seq Scan on article_palettizing_props palettizing_p_1 (cost=0.00..140.57 rows=7,257 width=8) (never executed)

781. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.62..0.62 rows=31 width=4) (never executed)

782. 0.000 0.000 ↓ 0.0 0

CTE Scan on tmp_d_li1 tmp_d_li1_1 (cost=0.00..0.62 rows=31 width=4) (never executed)

Planning time : 37.288 ms