explain.depesz.com

PostgreSQL's explain analyze made readable

Result: El5p

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

Gather Motion 24:1 (slice13; segments: 24) (cost=147,485,055.38..147,485,055.42 rows=0 width=187) (actual rows= loops=)

  • Merge Key: industry_sector, product_category, vendor, customer_country, product_category_id, vendor_id, _customer_country_id, grossing_coefficient, current_from_date, current_to_date, current_comments, units_original0, revenue_original0, total_country_revenue, total_category_rev, total_vendor_category_rev
  • Rows out: 2554 rows at destination with 116931 ms to first row, 116953 ms to end, start offset by 2236 ms.
  • (slice0) Executor memory: 1859K bytes.
  • (slice1) Executor memory: 1564K bytes avg x 24 workers, 1564K bytes max (seg0).
  • (slice2) Executor memory: 1733K bytes avg x 24 workers, 1733K bytes max (seg0).
  • (slice3) Executor memory: 1564K bytes avg x 24 workers, 1564K bytes max (seg0).
  • (slice4) Executor memory: 2620K bytes avg x 24 workers, 2623K bytes max (seg0). Work_mem: 1K bytes max.
  • (slice5) Executor memory: 1564K bytes avg x 24 workers, 1564K bytes max (seg0).
  • (slice6) Executor memory: 2659K bytes avg x 24 workers, 2659K bytes max (seg0).
  • (slice7) Executor memory: 2534K bytes avg x 24 workers, 2534K bytes max (seg0).
  • (slice8) Executor memory: 7513K bytes avg x 24 workers, 7538K bytes max (seg14). Work_mem: 478K bytes max.
  • (slice9) * Executor memory: 25706K bytes avg x 24 workers, 36892K bytes max (seg14). Work_mem: 35068K bytes max, 170595K bytes wanted.
  • (slice10) * Executor memory: 24790K bytes avg x 24 workers, 45843K bytes max (seg3). Work_mem: 44019K bytes max, 248561K bytes wanted.
  • (slice11) * Executor memory: 29355K bytes avg x 24 workers, 45716K bytes max (seg9). Work_mem: 43884K bytes max, 131516K bytes wanted.
  • (slice12) * Executor memory: 4439K bytes avg x 24 workers, 71807K bytes max (seg21). Work_mem: 43397K bytes max, 1601861K bytes wanted.
  • (slice13) Executor memory: 1417K bytes avg x 24 workers, 1457K bytes max (seg0). Work_mem: 145K bytes max.
  • Memory used: 115870K bytes
  • Memory wanted: 41652460K bytes
2. 0.000 0.000 ↓ 0.0

Unique (cost=147,485,055.38..147,485,055.42 rows=0 width=187) (actual rows= loops=)

  • Group By: coplan.industry_sector, coplan.product_category_standard, coplan.vendor_standard, coplan.name, coplan.product_category_id, coplan.vendor_id, coplan._customer_country_id, coplan.coefficient, coplan.start_date, coplan.end_date, coplan.notes, coplan.sum, coplan.sum, coplan.sum, coplan.sum, coplan.sum
  • Rows out: Avg 106.4 rows x 24 workers. Max 127 rows (seg18) with 116900 ms to end, start offset by 2267 ms.
3. 0.000 0.000 ↓ 0.0

Sort (cost=147,485,055.38..147,485,055.38 rows=1 width=187) (actual rows= loops=)

  • Sort Key (Distinct): coplan.industry_sector, coplan.product_category_standard, coplan.vendor_standard, coplan.name, coplan.product_category_id, coplan.vendor_id, coplan._customer_country_id, coplan.coefficient, coplan.start_date, coplan.end_date, coplan.notes, coplan.sum, coplan.sum, coplan.sum, coplan.sum, coplan.sum
  • Rows out: Avg 106.4 rows x 24 workers. Max 127 rows (seg18) with 116900 ms to end, start offset by 2267 ms.
  • Executor memory: 105K bytes avg, 145K bytes max (seg0).
  • Work_mem used: 105K bytes avg, 145K bytes max (seg0). Workfile: (0 spilling)
4. 0.000 0.000 ↓ 0.0

Redistribute Motion 24:24 (slice12; segments: 24) (cost=147,322,218.55..147,485,055.37 rows=1 width=187) (actual rows= loops=)

  • Hash Key: coplan.industry_sector, coplan.product_category_standard, coplan.vendor_standard, coplan.name, coplan.product_category_id, coplan.vendor_id, coplan._customer_country_id, coplan.coefficient, coplan.start_date, coplan.end_date, coplan.notes, coplan.sum, coplan.sum, coplan.sum, coplan.sum, coplan.sum
  • Rows out: Avg 106.4 rows x 24 workers at destination. Max 127 rows (seg18) with 99095 ms to first row, 116897 ms to end, start offset by 2267 ms.
5. 0.000 0.000 ↓ 0.0

Unique (cost=147,322,218.55..147,485,055.35 rows=1 width=187) (actual rows= loops=)

  • Group By: coplan.industry_sector, coplan.product_category_standard, coplan.vendor_standard, coplan.name, coplan.product_category_id, coplan.vendor_id, coplan._customer_country_id, coplan.coefficient, coplan.start_date, coplan.end_date, coplan.notes, coplan.sum, coplan.sum, coplan.sum, coplan.sum, coplan.sum
  • Rows out: 2554 rows (seg21) with 92837 ms to first row, 116858 ms to end, start offset by 2300 ms.
6. 0.000 0.000 ↓ 0.0

Sort (cost=147,322,218.55..147,331,797.19 rows=159,644 width=187) (actual rows= loops=)

  • Sort Key (Distinct): coplan.industry_sector, coplan.product_category_standard, coplan.vendor_standard, coplan.name, coplan.product_category_id, coplan.vendor_id, coplan._customer_country_id, coplan.coefficient, coplan.start_date, coplan.end_date, coplan.notes, coplan.sum, coplan.sum, coplan.sum, coplan.sum, coplan.sum
  • Rows out: 3689289 rows (seg21) with 92837 ms to first row, 109264 ms to end, start offset by 2300 ms.
  • Executor memory: 1879K bytes avg, 43397K bytes max (seg21).
  • Work_mem used: 1879K bytes avg, 43397K bytes max (seg21). Workfile: (1 spilling)
  • Work_mem wanted: 1601861K bytes avg, 1601861K bytes max (seg21) to lessen workfile I/O affecting 1 workers.
7. 0.000 0.000 ↓ 0.0

Merge Join (cost=146,625,911.22..146,739,088.89 rows=159,644 width=187) (actual rows= loops=)

  • Merge Cond: NOT coplan._customer_country_id IS DISTINCT FROM coplan._customer_country_id
  • Rows out: 3689289 rows (seg21) with 38477 ms to first row, 46965 ms to end, start offset by 2305 ms.
8. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=73,312,955.61..73,331,229.91 rows=1 width=4) (actual rows= loops=)

  • Group By: coplan._customer_country_id
  • Rows out: 1 rows (seg21) with 38477 ms to end, start offset by 2305 ms.
  • Executor memory: 8K bytes.
9. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 12:0) (cost=73,312,955.61..73,321,651.26 rows=159,644 width=183) (actual rows= loops=)

  • Rows out: 3689289 rows (seg21) with 35798 ms to first row, 36737 ms to end, start offset by 2305 ms.
10. 0.000 0.000 ↓ 0.0

Sort (cost=73,303,376.97..73,312,955.61 rows=159,644 width=183) (actual rows= loops=)

  • Sort Key: coplan._customer_country_id
  • Rows out: 0 rows (seg0) with 35798 ms to end, start offset by 2305 ms.
  • Executor memory: 1146K bytes avg, 26765K bytes max (seg21).
  • Work_mem used: 1146K bytes avg, 26765K bytes max (seg21). Workfile: (1 spilling)
  • Work_mem wanted: 1480794K bytes avg, 1480794K bytes max (seg21) to lessen workfile I/O affecting 1 workers.
11. 0.000 0.000 ↓ 0.0

Redistribute Motion 24:24 (slice11; segments: 24) (cost=72,651,747.32..72,884,417.82 rows=159,644 width=183) (actual rows= loops=)

  • Hash Key: coplan._customer_country_id
  • Rows out: 3689289 rows at destination (seg21) with 28012 ms to first row, 30169 ms to end, start offset by 2305 ms.
12. 0.000 0.000 ↓ 0.0

Merge Join (cost=72,651,747.32..72,807,788.74 rows=159,644 width=183) (actual rows= loops=)

  • Merge Cond: NOT coplan._customer_country_id IS DISTINCT FROM coplan._customer_country_id AND NOT coplan.product_category_id IS DISTINCT FROM coplan.product_category_id AND NOT coplan.vendor_id IS DISTINCT FROM coplan.vendor_id
  • Rows out: Avg 153720.4 rows x 24 workers. Max 435374 rows (seg6) with 28127 ms to first row, 30251 ms to end, start offset by 2316 ms.
13. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=36,325,873.66..36,365,579.83 rows=10,257 width=12) (actual rows= loops=)

  • Group By: coplan._customer_country_id, coplan.product_category_id, coplan.vendor_id
  • Rows out: Avg 101.7 rows x 24 workers. Max 133 rows (seg4) with 28016 ms to first row, 28163 ms to end, start offset by 2313 ms.
  • Executor memory: 8K bytes avg, 8K bytes max (seg0).
14. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 11:1) (cost=36,325,873.66..36,334,382.31 rows=159,644 width=171) (actual rows= loops=)

  • Rows out: Avg 153720.4 rows x 24 workers. Max 435374 rows (seg6) with 28127 ms to first row, 28249 ms to end, start offset by 2316 ms.
15. 0.000 0.000 ↓ 0.0

Sort (cost=36,316,295.03..36,325,873.66 rows=159,644 width=171) (actual rows= loops=)

  • Sort Key: coplan._customer_country_id, coplan.product_category_id, coplan.vendor_id
  • Rows out: 0 rows (seg0) with 28282 ms to end, start offset by 2302 ms.
  • Executor memory: 27544K bytes avg, 43884K bytes max (seg9).
  • Work_mem used: 27544K bytes avg, 43884K bytes max (seg9). Workfile: (16 spilling)
  • Work_mem wanted: 66338K bytes avg, 131516K bytes max (seg10) to lessen workfile I/O affecting 16 workers.
16. 0.000 0.000 ↓ 0.0

Redistribute Motion 24:24 (slice10; segments: 24) (cost=35,689,116.56..35,897,335.87 rows=159,644 width=171) (actual rows= loops=)

  • Hash Key: coplan._customer_country_id, coplan.product_category_id, coplan.vendor_id
  • Rows out: Avg 153720.4 rows x 24 workers at destination. Max 435374 rows (seg6) with 23547 ms to first row, 27021 ms to end, start offset by 2316 ms.
17. 0.000 0.000 ↓ 0.0

Merge Join (cost=35,689,116.56..35,820,706.79 rows=159,644 width=171) (actual rows= loops=)

  • Merge Cond: NOT coplan._customer_country_id IS DISTINCT FROM coplan._customer_country_id AND NOT coplan.product_category_id_original IS DISTINCT FROM coplan.product_category_id_original
  • Rows out: Avg 153720.4 rows x 24 workers. Max 899292 rows (seg19) with 24059 ms to first row, 26741 ms to end, start offset by 2296 ms.
18. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=17,844,558.28..17,872,038.86 rows=8 width=8) (actual rows= loops=)

  • Group By: coplan._customer_country_id, coplan.product_category_id_original
  • Rows out: Avg 7.9 rows x 24 workers. Max 14 rows (seg2) with 23574 ms to first row, 23595 ms to end, start offset by 2287 ms.
  • Executor memory: 8K bytes avg, 8K bytes max (seg0).
19. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 10:2) (cost=17,844,558.28..17,852,879.74 rows=159,644 width=163) (actual rows= loops=)

  • Rows out: Avg 153720.4 rows x 24 workers. Max 899292 rows (seg19) with 24048 ms to first row, 24286 ms to end, start offset by 2296 ms.
20. 0.000 0.000 ↓ 0.0

Sort (cost=17,834,979.65..17,844,558.28 rows=159,644 width=163) (actual rows= loops=)

  • Sort Key: coplan._customer_country_id, coplan.product_category_id_original
  • Rows out: 0 rows (seg0) with 24048 ms to end, start offset by 2296 ms.
  • Executor memory: 23003K bytes avg, 44019K bytes max (seg3).
  • Work_mem used: 23003K bytes avg, 44019K bytes max (seg3). Workfile: (11 spilling)
  • Work_mem wanted: 76654K bytes avg, 248561K bytes max (seg19) to lessen workfile I/O affecting 11 workers.
21. 0.000 0.000 ↓ 0.0

Redistribute Motion 24:24 (slice9; segments: 24) (cost=17,184,253.47..17,416,020.49 rows=159,644 width=163) (actual rows= loops=)

  • Hash Key: coplan._customer_country_id, coplan.product_category_id_original
  • Rows out: Avg 153720.4 rows x 24 workers at destination. Max 899292 rows (seg19) with 20957 ms to first row, 22318 ms to end, start offset by 2296 ms.
22. 0.000 0.000 ↓ 0.0

Merge Join (cost=17,184,253.47..17,339,391.41 rows=159,644 width=163) (actual rows= loops=)

  • Merge Cond: NOT coplan.part_key IS DISTINCT FROM coplan._customer_country_id AND NOT coplan.part_key IS DISTINCT FROM coplan.vendor_id AND NOT coplan.part_key IS DISTINCT FROM coplan.product_category_id_original
  • Rows out: Avg 153720.4 rows x 24 workers. Max 478114 rows (seg18) with 21222 ms to first row, 22651 ms to end, start offset by 2295 ms.
23. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=8,592,126.74..8,631,381.17 rows=10,713 width=12) (actual rows= loops=)

  • Group By: df._customer_country_id, df.vendor_id, df.product_category_id_original
  • Rows out: Avg 106.2 rows x 24 workers. Max 135 rows (seg4) with 21154 ms to first row, 21271 ms to end, start offset by 2302 ms.
  • Executor memory: 8K bytes avg, 8K bytes max (seg0).
24. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 9:3) (cost=8,592,126.74..8,600,074.19 rows=159,644 width=151) (actual rows= loops=)

  • Rows out: Avg 153720.4 rows x 24 workers. Max 478114 rows (seg18) with 21221 ms to first row, 21334 ms to end, start offset by 2295 ms.
25. 0.000 0.000 ↓ 0.0

Sort (cost=8,582,548.10..8,592,126.74 rows=159,644 width=151) (actual rows= loops=)

  • Sort Key: df._customer_country_id, df.vendor_id, df.product_category_id_original
  • Rows out: 0 rows (seg0) with 21233 ms to end, start offset by 2309 ms.
  • Executor memory: 23909K bytes avg, 35068K bytes max (seg14).
  • Work_mem used: 23909K bytes avg, 35068K bytes max (seg14). Workfile: (14 spilling)
  • Work_mem wanted: 63095K bytes avg, 170595K bytes max (seg18) to lessen workfile I/O affecting 14 workers.
26. 0.000 0.000 ↓ 0.0

Redistribute Motion 24:24 (slice8; segments: 24) (cost=8,017.15..8,163,588.95 rows=159,644 width=151) (actual rows= loops=)

  • Hash Key: df._customer_country_id, df.vendor_id, df.product_category_id_original
  • Rows out: Avg 153720.4 rows x 24 workers at destination. Max 478114 rows (seg18) with 77 ms to first row, 20000 ms to end, start offset by 2295 ms.
27. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,017.15..8,086,959.87 rows=159,644 width=151) (actual rows= loops=)

  • Hash Cond: df._customer_country_id = gu.country_id AND df.vendor_id = gu.vendor_id AND df.product_category_id = gu.product_category_id
  • Rows out: Avg 153720.4 rows x 24 workers. Max 154142 rows (seg21) with 77 ms to first row, 20476 ms to end, start offset by 2276 ms.
  • Executor memory: 64K bytes avg, 64K bytes max (seg0).
  • Work_mem used: 64K bytes avg, 64K bytes max (seg0). Workfile: (0 spilling)
  • (seg21) Hash chain length 1.2 avg, 11 max, using 675 of 16417 buckets.
28. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=7,638.46..8,019,529.23 rows=159,644 width=90) (actual rows= loops=)

  • Hash Cond: df.product_category_id_original = pc.product_category_id
  • Rows out: Avg 152357.9 rows x 24 workers. Max 152791 rows (seg17) with 16 ms to first row, 18639 ms to end, start offset by 2340 ms.
  • Executor memory: 16K bytes avg, 16K bytes max (seg0).
  • Work_mem used: 16K bytes avg, 16K bytes max (seg0). Workfile: (0 spilling)
  • (seg17) Hash chain length 1.0 avg, 1 max, using 324 of 65539 buckets.
29. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=7,433.02..7,741,543.38 rows=159,644 width=71) (actual rows= loops=)

  • Hash Cond: df.product_category_id_original = pci.product_category_id
  • Rows out: Avg 152357.9 rows x 24 workers. Max 152791 rows (seg17) with 14 ms to first row, 18566 ms to end, start offset by 2341 ms.
  • Executor memory: 13K bytes avg, 13K bytes max (seg0).
  • Work_mem used: 13K bytes avg, 13K bytes max (seg0). Workfile: (0 spilling)
  • (seg17) Hash chain length 1.0 avg, 1 max, using 265 of 65539 buckets.
30. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=7,226.56..7,463,556.51 rows=159,644 width=53) (actual rows= loops=)

  • Hash Cond: df.vendor_id = v.vendor_id
  • Rows out: Avg 152357.9 rows x 24 workers. Max 152791 rows (seg17) with 13 ms to first row, 18502 ms to end, start offset by 2342 ms.
  • Executor memory: 478K bytes avg, 478K bytes max (seg0).
  • Work_mem used: 478K bytes avg, 478K bytes max (seg0). Workfile: (0 spilling)
  • (seg17) Hash chain length 1.0 avg, 1 max, using 12525 of 65539 buckets.
31. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=164.56..7,178,714.09 rows=159,644 width=44) (actual rows= loops=)

  • Hash Cond: df._customer_country_id = cc.country_id
  • Rows out: Avg 152357.9 rows x 24 workers. Max 152791 rows (seg17) with 1.545 ms to first row, 18422 ms to end, start offset by 2354 ms.
  • Executor memory: 11K bytes avg, 11K bytes max (seg0).
  • Work_mem used: 11K bytes avg, 11K bytes max (seg0). Workfile: (0 spilling)
  • (seg17) Hash chain length 1.0 avg, 1 max, using 251 of 65539 buckets.
32. 0.000 0.000 ↓ 0.0

Append-only Scan on distribution_panel df (cost=0.00..6,900,769.12 rows=159,644 width=32) (actual rows= loops=)

  • Filter: vendor_id <> (-1) AND product_category_id_original <> (-1) AND customer_country_id = 72
  • Rows out: Avg 152357.9 rows x 24 workers. Max 152791 rows (seg17) with 0.906 ms to first row, 18346 ms to end, start offset by 2355 ms.
33. 0.000 0.000 ↓ 0.0

Hash (cost=89.26..89.26 rows=251 width=16) (actual rows= loops=)

  • Rows in: Avg 251.0 rows x 24 workers. Max 251 rows (seg0) with 0.166 ms to end, start offset by 2352 ms.
34. 0.000 0.000 ↓ 0.0

Broadcast Motion 24:24 (slice1; segments: 24) (cost=0.00..89.26 rows=251 width=16) (actual rows= loops=)

  • Rows out: Avg 251.0 rows x 24 workers at destination. Max 251 rows (seg0) with 0.008 ms to first row, 0.106 ms to end, start offset by 2352 ms.
35. 0.000 0.000 ↓ 0.0

Append-only Scan on country cc (cost=0.00..26.51 rows=11 width=16) (actual rows= loops=)

  • Rows out: Avg 10.5 rows x 24 workers. Max 13 rows (seg20) with 0.758 ms to first row, 0.784 ms to end, start offset by 2297 ms.
36. 0.000 0.000 ↓ 0.0

Hash (cost=3,304.50..3,304.50 rows=12,525 width=13) (actual rows= loops=)

  • Rows in: Avg 12525.0 rows x 24 workers. Max 12525 rows (seg0) with 6.564 ms to end, start offset by 2345 ms.
37. 0.000 0.000 ↓ 0.0

Broadcast Motion 24:24 (slice2; segments: 24) (cost=0.00..3,304.50 rows=12,525 width=13) (actual rows= loops=)

  • Rows out: Avg 12525.0 rows x 24 workers at destination. Max 12525 rows (seg0) with 0.070 ms to first row, 4.062 ms to end, start offset by 2345 ms.
38. 0.000 0.000 ↓ 0.0

Append-only Scan on vendor v (cost=0.00..173.25 rows=522 width=13) (actual rows= loops=)

  • Rows out: Avg 521.9 rows x 24 workers. Max 542 rows (seg17) with 2.297 ms to first row, 2.561 ms to end, start offset by 2322 ms.
39. 0.000 0.000 ↓ 0.0

Hash (cost=126.96..126.96 rows=265 width=22) (actual rows= loops=)

  • Rows in: Avg 265.0 rows x 24 workers. Max 265 rows (seg0) with 0.262 ms to end, start offset by 2344 ms.
40. 0.000 0.000 ↓ 0.0

Broadcast Motion 24:24 (slice4; segments: 24) (cost=24.79..126.96 rows=265 width=22) (actual rows= loops=)

  • Rows out: Avg 265.0 rows x 24 workers at destination. Max 265 rows (seg0) with 0.014 ms to first row, 0.180 ms to end, start offset by 2344 ms.
41. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=24.79..60.71 rows=12 width=22) (actual rows= loops=)

  • Hash Cond: pci.industry_sector_id = id.industry_sector_id
  • Rows out: Avg 12.6 rows x 21 workers. Max 39 rows (seg2) with 1.534 ms to first row, 39 ms to end, start offset by 2300 ms.
  • Executor memory: 1K bytes avg, 1K bytes max (seg9).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg9). Workfile: (0 spilling)
  • (seg2) Hash chain length 1.0 avg, 1 max, using 1 of 65539 buckets.
  • (seg9) Hash chain length 1.0 avg, 1 max, using 2 of 65539 buckets.
42. 0.000 0.000 ↓ 0.0

Redistribute Motion 24:24 (slice3; segments: 24) (cost=0.00..31.95 rows=12 width=8) (actual rows= loops=)

  • Hash Key: pci.industry_sector_id
  • Rows out: Avg 12.6 rows x 21 workers at destination. Max 39 rows (seg2) with 0.017 ms to first row, 37 ms to end, start offset by 2301 ms.
43. 0.000 0.000 ↓ 0.0

Append-only Scan on product_category_industry_sector pci (cost=0.00..26.65 rows=12 width=8) (actual rows= loops=)

  • Rows out: Avg 11.0 rows x 24 workers. Max 16 rows (seg5) with 0.720 ms to first row, 0.743 ms to end, start offset by 2312 ms.
44. 0.000 0.000 ↓ 0.0

Hash (cost=24.35..24.35 rows=2 width=22) (actual rows= loops=)

  • Rows in: Avg 1.7 rows x 21 workers. Max 2 rows (seg0) with 0.813 ms to end, start offset by 2276 ms.
45. 0.000 0.000 ↓ 0.0

Append-only Scan on industry_sector id (cost=0.00..24.35 rows=2 width=22) (actual rows= loops=)

  • Rows out: Avg 1.7 rows x 21 workers. Max 2 rows (seg0) with 0.778 ms to first row, 0.798 ms to end, start offset by 2276 ms.
46. 0.000 0.000 ↓ 0.0

Hash (cost=108.24..108.24 rows=324 width=23) (actual rows= loops=)

  • Rows in: Avg 324.0 rows x 24 workers. Max 324 rows (seg0) with 0.374 ms to end, start offset by 2343 ms.
47. 0.000 0.000 ↓ 0.0

Broadcast Motion 24:24 (slice5; segments: 24) (cost=0.00..108.24 rows=324 width=23) (actual rows= loops=)

  • Rows out: Avg 324.0 rows x 24 workers at destination. Max 324 rows (seg0) with 0.016 ms to first row, 0.239 ms to end, start offset by 2343 ms.
48. 0.000 0.000 ↓ 0.0

Append-only Scan on product_category pc (cost=0.00..27.24 rows=14 width=23) (actual rows= loops=)

  • Rows out: Avg 13.5 rows x 24 workers. Max 18 rows (seg20) with 0.846 ms to first row, 0.889 ms to end, start offset by 2296 ms.
49. 0.000 0.000 ↓ 0.0

Hash (cost=239.67..239.67 rows=331 width=73) (actual rows= loops=)

  • Rows in: Avg 832.0 rows x 24 workers. Max 832 rows (seg0) with 47 ms to end, start offset by 2295 ms.
50. 0.000 0.000 ↓ 0.0

Broadcast Motion 24:24 (slice7; segments: 24) (cost=150.30..239.67 rows=331 width=73) (actual rows= loops=)

  • Rows out: Avg 1420.0 rows x 24 workers at destination. Max 1420 rows (seg0) with 36 ms to first row, 46 ms to end, start offset by 2295 ms.
51. 0.000 0.000 ↓ 0.0

Subquery Scan gu (cost=150.30..156.92 rows=14 width=73) (actual rows= loops=)

  • Rows out: Avg 59.2 rows x 24 workers. Max 80 rows (seg21) with 42 ms to end, start offset by 2285 ms.
52. 0.000 0.000 ↓ 0.0

HashAggregate (cost=150.30..153.61 rows=14 width=73) (actual rows= loops=)

  • Group By: grossing_pdp_units.country_id, grossing_pdp_units.vendor_id, grossing_pdp_units.product_category_id, grossing_pdp_units.coefficient, grossing_pdp_units.start_date, grossing_pdp_units.end_date, grossing_pdp_units.notes
  • Rows out: Avg 59.2 rows x 24 workers. Max 80 rows (seg21) with 42 ms to end, start offset by 2285 ms.
  • Executor memory: 1113K bytes avg, 1113K bytes max (seg0).
53. 0.000 0.000 ↓ 0.0

Redistribute Motion 24:24 (slice6; segments: 24) (cost=134.58..141.20 rows=14 width=73) (actual rows= loops=)

  • Hash Key: grossing_pdp_units.country_id, grossing_pdp_units.vendor_id, grossing_pdp_units.product_category_id, grossing_pdp_units.coefficient, grossing_pdp_units.start_date, grossing_pdp_units.end_date, grossing_pdp_units.notes
  • Rows out: Avg 113.9 rows x 24 workers at destination. Max 154 rows (seg21) with 0.019 ms to first row, 41 ms to end, start offset by 2286 ms.
54. 0.000 0.000 ↓ 0.0

HashAggregate (cost=134.58..134.58 rows=14 width=73) (actual rows= loops=)

  • Group By: grossing_pdp_units.country_id, grossing_pdp_units.vendor_id, grossing_pdp_units.product_category_id, grossing_pdp_units.coefficient, grossing_pdp_units.start_date, grossing_pdp_units.end_date, grossing_pdp_units.notes
  • Rows out: Avg 113.9 rows x 24 workers. Max 130 rows (seg23) with 1.406 ms to first row, 1.602 ms to end, start offset by 2267 ms.
  • Executor memory: 1113K bytes avg, 1113K bytes max (seg0).
55. 0.000 0.000 ↓ 0.0

Append-only Scan on grossing_pdp_units (cost=0.00..85.00 rows=119 width=54) (actual rows= loops=)

  • Filter: coefficient_type = 1
  • Rows out: Avg 118.0 rows x 24 workers. Max 138 rows (seg8) with 4.905 ms to first row, 5.029 ms to end, start offset by 2291 ms.
56. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=8,592,126.74..8,667,124.64 rows=159,644 width=151) (actual rows= loops=)

  • Rows out: Avg 153720.4 rows x 24 workers. Max 478114 rows (seg18) with 0.058 ms to first row, 808 ms to end, start offset by 23516 ms.
57. 0.000 0.000 ↓ 0.0

Window (cost=8,592,126.74..8,628,810.10 rows=159,644 width=151) (actual rows= loops=)

  • Partition By: df._customer_country_id, df.vendor_id, df.product_category_id_original
  • Rows out: Avg 153720.4 rows x 24 workers. Max 478114 rows (seg18) with 0.056 ms to first row, 732 ms to end, start offset by 23516 ms.
58. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 9:3) (cost=8,592,126.74..8,600,074.19 rows=159,644 width=151) (actual rows= loops=)

  • Rows out: Avg 153720.4 rows x 24 workers. Max 478114 rows (seg18) with 0.021 ms to first row, 158 ms to end, start offset by 23516 ms.
59. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=17,844,558.28..17,910,351.54 rows=159,644 width=163) (actual rows= loops=)

  • Rows out: Avg 153720.4 rows x 24 workers. Max 899292 rows (seg19) with 0.095 ms to first row, 1547 ms to end, start offset by 26355 ms.
60. 0.000 0.000 ↓ 0.0

Window (cost=17,844,558.28..17,872,037.01 rows=159,644 width=163) (actual rows= loops=)

  • Partition By: coplan._customer_country_id, coplan.product_category_id_original
  • Rows out: Avg 153720.4 rows x 24 workers. Max 899292 rows (seg19) with 0.095 ms to first row, 1399 ms to end, start offset by 26355 ms.
61. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 10:2) (cost=17,844,558.28..17,852,879.74 rows=159,644 width=163) (actual rows= loops=)

  • Rows out: Avg 153720.4 rows x 24 workers. Max 899292 rows (seg19) with 0.025 ms to first row, 302 ms to end, start offset by 26355 ms.
62. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=36,325,873.66..36,401,432.76 rows=159,644 width=171) (actual rows= loops=)

  • Rows out: Avg 153720.4 rows x 24 workers. Max 435374 rows (seg6) with 0.052 ms to first row, 1303 ms to end, start offset by 30443 ms.
63. 0.000 0.000 ↓ 0.0

Window (cost=36,325,873.66..36,363,118.22 rows=159,644 width=171) (actual rows= loops=)

  • Partition By: coplan._customer_country_id, coplan.product_category_id, coplan.vendor_id
  • Rows out: Avg 153720.4 rows x 24 workers. Max 435374 rows (seg6) with 0.052 ms to first row, 1194 ms to end, start offset by 30443 ms.
64. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 11:1) (cost=36,325,873.66..36,334,382.31 rows=159,644 width=171) (actual rows= loops=)

  • Rows out: Avg 153720.4 rows x 24 workers. Max 435374 rows (seg6) with 0.010 ms to first row, 263 ms to end, start offset by 30443 ms.
65. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=73,312,955.61..73,369,544.44 rows=159,644 width=183) (actual rows= loops=)

  • Rows out: 3689289 rows (seg21) with 0.068 ms to first row, 6817 ms to end, start offset by 40782 ms.
66. 0.000 0.000 ↓ 0.0

Window (cost=73,312,955.61..73,331,229.90 rows=159,644 width=183) (actual rows= loops=)

  • Partition By: coplan._customer_country_id
  • Rows out: 3689289 rows (seg21) with 0.066 ms to first row, 6225 ms to end, start offset by 40782 ms.
67. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 12:0) (cost=73,312,955.61..73,321,651.26 rows=159,644 width=183) (actual rows= loops=)

  • Rows out: 3689289 rows (seg21) with 0.024 ms to first row, 1291 ms to end, start offset by 40782 ms.