explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3uBK

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

Unique (cost=136,405,070.01..136,652,410.26 rows=3,297,870 width=565) (actual rows= loops=)

2.          

CTE cnt_track

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,415,712.83..1,610,196.56 rows=1,648,935 width=91) (actual rows= loops=)

  • Group Key: lwl.label_key, lwl.customer_key, lwl.country_code, lwl.lsl_key, lwl.wea_key
4. 0.000 0.000 ↓ 0.0

Sort (cost=1,406,122.73..1,422,685.47 rows=6,625,095 width=23) (actual rows= loops=)

  • Sort Key: lwl.label_key, lwl.customer_key, lwl.country_code, lwl.lsl_key, lwl.wea_key
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=45,033.67..519,649.21 rows=6,625,095 width=23) (actual rows= loops=)

  • Hash Cond: (lwl.product_key = p.product_key)
6. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_product_dsp_cnt_lwl lwl (cost=0.00..346,529.52 rows=16,489,352 width=23) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=42,916.67..42,916.67 rows=169,360 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_product p (cost=0.00..42,916.67 rows=169,360 width=4) (actual rows= loops=)

  • Filter: (((product_type)::text = 'Full Length Recording (Track)'::text) AND ((product_id_type)::text = 'ISRC'::text) AND ((product_category)::text = 'Audio'::text))
9.          

SubPlan (forGroupAggregate)

10. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_customer (cost=0.00..4,795.02 rows=17 width=4) (actual rows= loops=)

  • Filter: ((customer_feed)::text = 'Streams'::text)
11. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_customer lkp_customer_1 (cost=0.00..4,795.02 rows=1 width=4) (actual rows= loops=)

  • Filter: ((customer_feed)::text = 'Downloads'::text)
12.          

CTE cnt_group_track

13. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,372,062.41..1,554,698.27 rows=1,648,935 width=91) (actual rows= loops=)

  • Group Key: lwl_1.label_key, lwl_1.customer_key, lwl_1.country_code, lwl_1.lsl_key, lwl_1.wea_key
14. 0.000 0.000 ↓ 0.0

Sort (cost=1,362,472.32..1,377,850.27 rows=6,151,180 width=23) (actual rows= loops=)

  • Sort Key: lwl_1.label_key, lwl_1.customer_key, lwl_1.country_code, lwl_1.lsl_key, lwl_1.wea_key
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=72,825.13..542,701.48 rows=6,151,180 width=23) (actual rows= loops=)

  • Hash Cond: (lwl_1.product_key = p_1.product_key)
16. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_product_dsp_cnt_lwl lwl_1 (cost=0.00..346,529.52 rows=16,489,352 width=23) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash (cost=70,859.57..70,859.57 rows=157,245 width=8) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash Join (cost=25,735.35..70,859.57 rows=157,245 width=8) (actual rows= loops=)

  • Hash Cond: (p_1.product_group_key = pg.product_group_key)
19. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_product p_1 (cost=0.00..42,916.67 rows=169,360 width=8) (actual rows= loops=)

  • Filter: (((product_type)::text = 'Full Length Recording (Track)'::text) AND ((product_id_type)::text = 'ISRC'::text) AND ((product_category)::text = 'Audio'::text))
20. 0.000 0.000 ↓ 0.0

Hash (cost=22,635.83..22,635.83 rows=247,961 width=4) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Index Only Scan using lkp_product_group_product_group_key on lkp_product_group pg (cost=0.42..22,635.83 rows=247,961 width=4) (actual rows= loops=)

22.          

SubPlan (forGroupAggregate)

23. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_customer lkp_customer_2 (cost=0.00..4,795.02 rows=17 width=4) (actual rows= loops=)

  • Filter: ((customer_feed)::text = 'Streams'::text)
24. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_customer lkp_customer_3 (cost=0.00..4,795.02 rows=1 width=4) (actual rows= loops=)

  • Filter: ((customer_feed)::text = 'Downloads'::text)
25.          

CTE cnt_album

26. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=516,545.34..552,209.98 rows=839,168 width=91) (actual rows= loops=)

  • Group Key: lwl_2.label_key, lwl_2.customer_key, lwl_2.country_code, lwl_2.lsl_key, lwl_2.wea_key
27. 0.000 0.000 ↓ 0.0

Sort (cost=506,955.25..509,053.17 rows=839,168 width=23) (actual rows= loops=)

  • Sort Key: lwl_2.label_key, lwl_2.customer_key, lwl_2.country_code, lwl_2.lsl_key, lwl_2.wea_key
28. 0.000 0.000 ↓ 0.0

Gather (cost=43,657.92..407,177.49 rows=839,168 width=23) (actual rows= loops=)

  • Workers Planned: 2
29. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,657.92..322,260.69 rows=349,653 width=23) (actual rows= loops=)

  • Hash Cond: (lwl_2.product_key = p_2.product_key)
30. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on lkp_product_dsp_cnt_lwl lwl_2 (cost=0.00..250,341.63 rows=6,870,563 width=23) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=42,389.76..42,389.76 rows=21,452 width=4) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_product p_2 (cost=0.00..42,389.76 rows=21,452 width=4) (actual rows= loops=)

  • Filter: (((product_id_type)::text = ANY ('{EAN,UPC}'::text[])) AND ((product_type)::text = ANY ('{Album,Single,"Long Form Video (Album)"}'::text[])))
33.          

SubPlan (forGroupAggregate)

34. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_customer lkp_customer_4 (cost=0.00..4,795.02 rows=17 width=4) (actual rows= loops=)

  • Filter: ((customer_feed)::text = 'Streams'::text)
35. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_customer lkp_customer_5 (cost=0.00..4,795.02 rows=1 width=4) (actual rows= loops=)

  • Filter: ((customer_feed)::text = 'Downloads'::text)
36.          

CTE cnt_group_album

37. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=533,283.52..566,396.97 rows=779,140 width=91) (actual rows= loops=)

  • Group Key: lwl_3.label_key, lwl_3.customer_key, lwl_3.country_code, lwl_3.lsl_key, lwl_3.wea_key
38. 0.000 0.000 ↓ 0.0

Sort (cost=523,693.43..525,641.28 rows=779,140 width=23) (actual rows= loops=)

  • Sort Key: lwl_3.label_key, lwl_3.customer_key, lwl_3.country_code, lwl_3.lsl_key, lwl_3.wea_key
39. 0.000 0.000 ↓ 0.0

Gather (cost=69,393.26..431,467.65 rows=779,140 width=23) (actual rows= loops=)

  • Workers Planned: 2
40. 0.000 0.000 ↓ 0.0

Hash Join (cost=68,393.26..352,553.65 rows=324,642 width=23) (actual rows= loops=)

  • Hash Cond: (p_3.product_group_key = pg_1.product_group_key)
41. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,657.92..322,260.69 rows=349,653 width=23) (actual rows= loops=)

  • Hash Cond: (lwl_3.product_key = p_3.product_key)
42. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on lkp_product_dsp_cnt_lwl lwl_3 (cost=0.00..250,341.63 rows=6,870,563 width=23) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Hash (cost=42,389.76..42,389.76 rows=21,452 width=8) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_product p_3 (cost=0.00..42,389.76 rows=21,452 width=8) (actual rows= loops=)

  • Filter: (((product_id_type)::text = ANY ('{EAN,UPC}'::text[])) AND ((product_type)::text = ANY ('{Album,Single,"Long Form Video (Album)"}'::text[])))
45. 0.000 0.000 ↓ 0.0

Hash (cost=22,635.83..22,635.83 rows=247,961 width=4) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Index Only Scan using lkp_product_group_product_group_key on lkp_product_group pg_1 (cost=0.42..22,635.83 rows=247,961 width=4) (actual rows= loops=)

47.          

SubPlan (forGroupAggregate)

48. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_customer lkp_customer_6 (cost=0.00..4,795.02 rows=17 width=4) (actual rows= loops=)

  • Filter: ((customer_feed)::text = 'Streams'::text)
49. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_customer lkp_customer_7 (cost=0.00..4,795.02 rows=1 width=4) (actual rows= loops=)

  • Filter: ((customer_feed)::text = 'Downloads'::text)
50.          

CTE cnt_artist

51. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=3,139,229.15..3,580,319.31 rows=1,648,935 width=91) (actual rows= loops=)

  • Group Key: lwl_4.label_key, lwl_4.customer_key, lwl_4.country_code, lwl_4.lsl_key, lwl_4.wea_key
52. 0.000 0.000 ↓ 0.0

Sort (cost=3,129,639.06..3,170,862.44 rows=16,489,352 width=23) (actual rows= loops=)

  • Sort Key: lwl_4.label_key, lwl_4.customer_key, lwl_4.country_code, lwl_4.lsl_key, lwl_4.wea_key
53. 0.000 0.000 ↓ 0.0

Hash Join (cost=46,671.29..814,812.40 rows=16,489,352 width=23) (actual rows= loops=)

  • Hash Cond: (lwl_4.product_key = p_4.product_key)
54. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_product_dsp_cnt_lwl lwl_4 (cost=0.00..346,529.52 rows=16,489,352 width=23) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Hash (cost=39,755.24..39,755.24 rows=421,524 width=8) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_product p_4 (cost=0.00..39,755.24 rows=421,524 width=8) (actual rows= loops=)

57.          

SubPlan (forGroupAggregate)

58. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_customer lkp_customer_8 (cost=0.00..4,795.02 rows=17 width=4) (actual rows= loops=)

  • Filter: ((customer_feed)::text = 'Streams'::text)
59. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_customer lkp_customer_9 (cost=0.00..4,795.02 rows=1 width=4) (actual rows= loops=)

  • Filter: ((customer_feed)::text = 'Downloads'::text)
60.          

CTE kpi_group_track

61. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2,762,019.92..2,953,030.27 rows=664,384 width=91) (actual rows= loops=)

  • Group Key: "*SELECT* 1".customer_key, "*SELECT* 1".country_code, "*SELECT* 1".label_key, "*SELECT* 1".wea_key, "*SELECT* 1".lsl_key, "*SELECT* 1".sales_type
62. 0.000 0.000 ↓ 0.0

Sort (cost=2,762,019.92..2,778,629.52 rows=6,643,838 width=55) (actual rows= loops=)

  • Sort Key: "*SELECT* 1".customer_key, "*SELECT* 1".country_code, "*SELECT* 1".label_key, "*SELECT* 1".wea_key, "*SELECT* 1".lsl_key, "*SELECT* 1".sales_type
63. 0.000 0.000 ↓ 0.0

Result (cost=1,293,168.88..1,782,066.97 rows=6,643,838 width=55) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Append (cost=1,293,168.88..1,715,628.59 rows=6,643,838 width=55) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=1,293,168.88..1,565,197.22 rows=6,400,667 width=55) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,293,168.88..1,501,190.55 rows=6,400,667 width=87) (actual rows= loops=)

  • Group Key: pg_2.product_group_key, trc.customer_key, trc.country_code, trc.label_key, trc.wea_key, trc.lsl_key
  • Filter: (sum(COALESCE(trc.stream_count_rtd, '0'::bigint)) > '0'::numeric)
67. 0.000 0.000 ↓ 0.0

Sort (cost=1,293,168.88..1,309,170.54 rows=6,400,667 width=31) (actual rows= loops=)

  • Sort Key: pg_2.product_group_key, trc.customer_key, trc.country_code, trc.label_key, trc.wea_key, trc.lsl_key
68. 0.000 0.000 ↓ 0.0

Hash Join (cost=64,330.19..416,437.67 rows=6,400,667 width=31) (actual rows= loops=)

  • Hash Cond: (trc.product_key = tr.product_key)
69. 0.000 0.000 ↓ 0.0

Seq Scan on track_streams_current_kpi trc (cost=0.00..166,468.04 rows=6,893,804 width=31) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Hash (cost=57,909.06..57,909.06 rows=391,371 width=8) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Hash Join (cost=25,735.77..57,909.06 rows=391,371 width=8) (actual rows= loops=)

  • Hash Cond: (tr.product_group_key = pg_2.product_group_key)
72. 0.000 0.000 ↓ 0.0

Index Only Scan using lkp_product_product_key_product_group_key_idx on lkp_product tr (cost=0.42..26,679.28 rows=421,524 width=8) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Hash (cost=22,635.83..22,635.83 rows=247,961 width=4) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Index Only Scan using lkp_product_group_product_group_key on lkp_product_group pg_2 (cost=0.42..22,635.83 rows=247,961 width=4) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=140,096.60..150,431.37 rows=243,171 width=55) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=140,096.60..147,999.66 rows=243,171 width=87) (actual rows= loops=)

  • Group Key: pg_3.product_group_key, dnl.customer_key, dnl.country_code, dnl.label_key, dnl.wea_key, dnl.lsl_key
  • Filter: (sum(COALESCE(dnl.track_count_rtd, '0'::bigint)) > '0'::numeric)
77. 0.000 0.000 ↓ 0.0

Sort (cost=140,096.60..140,704.53 rows=243,171 width=31) (actual rows= loops=)

  • Sort Key: pg_3.product_group_key, dnl.customer_key, dnl.country_code, dnl.label_key, dnl.wea_key, dnl.lsl_key
78. 0.000 0.000 ↓ 0.0

Hash Join (cost=59,330.68..118,342.99 rows=243,171 width=31) (actual rows= loops=)

  • Hash Cond: (tr_1.product_group_key = pg_3.product_group_key)
79. 0.000 0.000 ↓ 0.0

Hash Join (cost=33,595.33..89,193.79 rows=261,906 width=31) (actual rows= loops=)

  • Hash Cond: (dnl.entity_id = tr_1.product_key)
80. 0.000 0.000 ↓ 0.0

Seq Scan on downloads_current_kpi dnl (cost=0.00..46,768.25 rows=261,906 width=31) (actual rows= loops=)

  • Filter: ((entity_type)::text = 'track'::text)
81. 0.000 0.000 ↓ 0.0

Hash (cost=26,679.28..26,679.28 rows=421,524 width=8) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Index Only Scan using lkp_product_product_key_product_group_key_idx on lkp_product tr_1 (cost=0.42..26,679.28 rows=421,524 width=8) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Hash (cost=22,635.83..22,635.83 rows=247,961 width=4) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Index Only Scan using lkp_product_group_product_group_key on lkp_product_group pg_3 (cost=0.42..22,635.83 rows=247,961 width=4) (actual rows= loops=)

85.          

CTE kpi_track

86. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=929,944.83..951,257.07 rows=74,130 width=91) (actual rows= loops=)

  • Group Key: "*SELECT* 1_1".customer_key, "*SELECT* 1_1".country_code, "*SELECT* 1_1".label_key, "*SELECT* 1_1".wea_key, "*SELECT* 1_1".lsl_key, "*SELECT* 1_1".sales_type
87. 0.000 0.000 ↓ 0.0

Sort (cost=929,944.83..931,798.07 rows=741,295 width=55) (actual rows= loops=)

  • Sort Key: "*SELECT* 1_1".customer_key, "*SELECT* 1_1".country_code, "*SELECT* 1_1".label_key, "*SELECT* 1_1".wea_key, "*SELECT* 1_1".lsl_key, "*SELECT* 1_1".sales_type
88. 0.000 0.000 ↓ 0.0

Result (cost=504,102.11..832,329.72 rows=741,295 width=55) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Append (cost=504,102.11..824,916.77 rows=741,295 width=55) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1_1 (cost=504,102.11..772,397.08 rows=689,380 width=55) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=504,102.11..765,503.28 rows=689,380 width=87) (actual rows= loops=)

  • Group Key: trc_1.product_key, trc_1.customer_key, trc_1.country_code, trc_1.label_key, trc_1.wea_key, trc_1.lsl_key
  • Filter: (sum(COALESCE(trc_1.stream_count_rtd, '0'::bigint)) > '0'::numeric)
92. 0.000 0.000 ↓ 0.0

Gather Merge (cost=504,102.11..729,310.83 rows=1,378,760 width=55) (actual rows= loops=)

  • Workers Planned: 2
93. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=503,102.08..569,167.69 rows=689,380 width=55) (actual rows= loops=)

  • Group Key: trc_1.product_key, trc_1.customer_key, trc_1.country_code, trc_1.label_key, trc_1.wea_key, trc_1.lsl_key
94. 0.000 0.000 ↓ 0.0

Sort (cost=503,102.08..510,283.13 rows=2,872,418 width=31) (actual rows= loops=)

  • Sort Key: trc_1.product_key, trc_1.customer_key, trc_1.country_code, trc_1.label_key, trc_1.wea_key, trc_1.lsl_key
95. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on track_streams_current_kpi trc_1 (cost=0.00..126,254.18 rows=2,872,418 width=31) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2_1 (cost=51,351.60..52,519.69 rows=51,915 width=55) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

HashAggregate (cost=51,351.60..52,000.54 rows=51,915 width=87) (actual rows= loops=)

  • Group Key: dnl_1.entity_id, dnl_1.customer_key, dnl_1.country_code, dnl_1.label_key, dnl_1.wea_key, dnl_1.lsl_key
  • Filter: (sum(COALESCE(dnl_1.track_count_rtd, '0'::bigint)) > '0'::numeric)
98. 0.000 0.000 ↓ 0.0

Seq Scan on downloads_current_kpi dnl_1 (cost=0.00..46,768.25 rows=261,906 width=31) (actual rows= loops=)

  • Filter: ((entity_type)::text = 'track'::text)
99.          

CTE kpi_group_album

100. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=122,274.04..124,564.53 rows=7,967 width=91) (actual rows= loops=)

  • Group Key: "*SELECT* 1_2".customer_key, "*SELECT* 1_2".country_code, "*SELECT* 1_2".label_key, "*SELECT* 1_2".wea_key, "*SELECT* 1_2".lsl_key, "*SELECT* 1_2".sales_type
101. 0.000 0.000 ↓ 0.0

Sort (cost=122,274.04..122,473.22 rows=79,669 width=55) (actual rows= loops=)

  • Sort Key: "*SELECT* 1_2".customer_key, "*SELECT* 1_2".country_code, "*SELECT* 1_2".label_key, "*SELECT* 1_2".wea_key, "*SELECT* 1_2".lsl_key, "*SELECT* 1_2".sales_type
102. 0.000 0.000 ↓ 0.0

Result (cost=75,166.15..115,788.30 rows=79,669 width=55) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Append (cost=75,166.15..114,991.61 rows=79,669 width=55) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1_2 (cost=75,166.15..76,120.33 rows=42,408 width=55) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Finalize HashAggregate (cost=75,166.15..75,696.25 rows=42,408 width=87) (actual rows= loops=)

  • Group Key: pg_4.product_group_key, dnl_2.customer_key, dnl_2.country_code, dnl_2.label_key, dnl_2.wea_key, dnl_2.lsl_key
  • Filter: (sum(COALESCE(dnl_2.album_count_rtd, '0'::bigint)) > '0'::numeric)
106. 0.000 0.000 ↓ 0.0

Gather (cost=70,704.48..74,459.35 rows=35,340 width=55) (actual rows= loops=)

  • Workers Planned: 2
107. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=69,704.48..69,925.35 rows=17,670 width=55) (actual rows= loops=)

  • Group Key: pg_4.product_group_key, dnl_2.customer_key, dnl_2.country_code, dnl_2.label_key, dnl_2.wea_key, dnl_2.lsl_key
108. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..69,395.25 rows=17,670 width=31) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..60,024.86 rows=19,031 width=31) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on downloads_current_kpi dnl_2 (cost=0.00..42,979.35 rows=19,031 width=31) (actual rows= loops=)

  • Filter: ((entity_type)::text = 'album'::text)
111. 0.000 0.000 ↓ 0.0

Index Only Scan using lkp_product_product_key_product_group_key_idx on lkp_product tr_2 (cost=0.42..0.89 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (product_key = dnl_2.entity_id)
112. 0.000 0.000 ↓ 0.0

Index Only Scan using lkp_product_group_product_group_key on lkp_product_group pg_4 (cost=0.42..0.48 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (product_group_key = tr_2.product_group_key)
113. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2_2 (cost=38,032.90..38,871.27 rows=37,261 width=55) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Finalize HashAggregate (cost=38,032.90..38,498.66 rows=37,261 width=87) (actual rows= loops=)

  • Group Key: pg_5.product_group_key, ph.country_code, ph.label_key, ph.wea_key, ph.lsl_key
  • Filter: (sum(COALESCE(ph.physical_count_rtd, '0'::bigint)) > '0'::numeric)
115. 0.000 0.000 ↓ 0.0

Gather (cost=34,190.46..37,489.53 rows=31,050 width=51) (actual rows= loops=)

  • Workers Planned: 2
116. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=33,190.46..33,384.53 rows=15,525 width=51) (actual rows= loops=)

  • Group Key: pg_5.product_group_key, ph.country_code, ph.label_key, ph.wea_key, ph.lsl_key
117. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..32,957.59 rows=15,525 width=27) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..24,724.09 rows=16,722 width=27) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on physical_current_kpi ph (cost=0.00..8,717.35 rows=16,722 width=27) (actual rows= loops=)

  • Filter: ((entity_type)::text = 'album'::text)
120. 0.000 0.000 ↓ 0.0

Index Only Scan using lkp_product_product_key_product_group_key_idx on lkp_product tr_3 (cost=0.42..0.95 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (product_key = ph.entity_id)
121. 0.000 0.000 ↓ 0.0

Index Only Scan using lkp_product_group_product_group_key on lkp_product_group pg_5 (cost=0.42..0.48 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (product_group_key = tr_3.product_group_key)
122.          

CTE kpi_album

123. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=62,653.14..63,963.23 rows=4,557 width=91) (actual rows= loops=)

  • Group Key: "*SELECT* 1_3".customer_key, "*SELECT* 1_3".country_code, "*SELECT* 1_3".label_key, "*SELECT* 1_3".wea_key, "*SELECT* 1_3".lsl_key, "*SELECT* 1_3".sales_type
124. 0.000 0.000 ↓ 0.0

Sort (cost=62,653.14..62,767.06 rows=45,568 width=55) (actual rows= loops=)

  • Sort Key: "*SELECT* 1_3".customer_key, "*SELECT* 1_3".country_code, "*SELECT* 1_3".label_key, "*SELECT* 1_3".wea_key, "*SELECT* 1_3".lsl_key, "*SELECT* 1_3".sales_type
125. 0.000 0.000 ↓ 0.0

Result (cost=47,567.56..59,127.15 rows=45,568 width=55) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Append (cost=47,567.56..58,671.47 rows=45,568 width=55) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1_3 (cost=47,567.56..48,270.80 rows=31,255 width=55) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

HashAggregate (cost=47,567.56..47,958.25 rows=31,255 width=87) (actual rows= loops=)

  • Group Key: dnl_3.entity_id, dnl_3.customer_key, dnl_3.country_code, dnl_3.label_key, dnl_3.wea_key, dnl_3.lsl_key
  • Filter: (sum(COALESCE(dnl_3.album_count_rtd, '0'::bigint)) > '0'::numeric)
129. 0.000 0.000 ↓ 0.0

Seq Scan on downloads_current_kpi dnl_3 (cost=0.00..46,768.25 rows=45,675 width=31) (actual rows= loops=)

  • Filter: ((entity_type)::text = 'album'::text)
130. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2_3 (cost=10,078.63..10,400.67 rows=14,313 width=55) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

HashAggregate (cost=10,078.63..10,257.54 rows=14,313 width=87) (actual rows= loops=)

  • Group Key: ph_1.entity_id, ph_1.country_code, ph_1.label_key, ph_1.wea_key, ph_1.lsl_key
  • Filter: (sum(COALESCE(ph_1.physical_count_rtd, '0'::bigint)) > '0'::numeric)
132. 0.000 0.000 ↓ 0.0

Seq Scan on physical_current_kpi ph_1 (cost=0.00..9,476.65 rows=40,132 width=27) (actual rows= loops=)

  • Filter: ((entity_type)::text = 'album'::text)
133.          

CTE kpi_artist

134. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=122,014.25..126,717.18 rows=16,358 width=91) (actual rows= loops=)

  • Group Key: "*SELECT* 1_4".customer_key, "*SELECT* 1_4".country_code, "*SELECT* 1_4".label_key, "*SELECT* 1_4".wea_key, "*SELECT* 1_4".lsl_key, "*SELECT* 1_4".sales_type
135. 0.000 0.000 ↓ 0.0

Sort (cost=122,014.25..122,423.20 rows=163,580 width=55) (actual rows= loops=)

  • Sort Key: "*SELECT* 1_4".customer_key, "*SELECT* 1_4".country_code, "*SELECT* 1_4".label_key, "*SELECT* 1_4".wea_key, "*SELECT* 1_4".lsl_key, "*SELECT* 1_4".sales_type
136. 0.000 0.000 ↓ 0.0

Result (cost=44,208.55..107,848.52 rows=163,580 width=55) (actual rows= loops=)

137. 0.000 0.000 ↓ 0.0

Append (cost=44,208.55..106,212.72 rows=163,580 width=55) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1_4 (cost=44,208.55..46,579.85 rows=105,391 width=55) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

HashAggregate (cost=44,208.55..45,525.94 rows=105,391 width=87) (actual rows= loops=)

  • Group Key: kpi.artist_id, kpi.customer_key, kpi.country_code, kpi.label_key, kpi.wea_key, kpi.lsl_key
  • Filter: (sum(COALESCE(kpi.stream_cnt_rtd, '0'::bigint)) > '0'::numeric)
140. 0.000 0.000 ↓ 0.0

Seq Scan on artist_streams_current_kpi kpi (cost=0.00..25,765.11 rows=1,053,911 width=31) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2_4 (cost=48,427.48..49,440.70 rows=45,032 width=55) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

HashAggregate (cost=48,427.48..48,990.38 rows=45,032 width=87) (actual rows= loops=)

  • Group Key: kpi_1.entity_id, kpi_1.customer_key, kpi_1.country_code, kpi_1.label_key, kpi_1.wea_key, kpi_1.lsl_key
  • Filter: (sum(COALESCE(kpi_1.track_count_rtd, '0'::bigint)) > '0'::numeric)
143. 0.000 0.000 ↓ 0.0

Seq Scan on downloads_current_kpi kpi_1 (cost=0.00..46,768.25 rows=94,813 width=31) (actual rows= loops=)

  • Filter: ((entity_type)::text = 'artist'::text)
144. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 3 (cost=9,896.14..10,192.17 rows=13,157 width=55) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

HashAggregate (cost=9,896.14..10,060.60 rows=13,157 width=87) (actual rows= loops=)

  • Group Key: kpi_2.entity_id, kpi_2.country_code, kpi_2.label_key, kpi_2.wea_key, kpi_2.lsl_key
  • Filter: (sum(COALESCE(kpi_2.physical_count_rtd, '0'::bigint)) > '0'::numeric)
146. 0.000 0.000 ↓ 0.0

Seq Scan on physical_current_kpi kpi_2 (cost=0.00..9,476.65 rows=27,966 width=27) (actual rows= loops=)

  • Filter: ((entity_type)::text = 'artist'::text)
147. 0.000 0.000 ↓ 0.0

Sort (cost=124,321,716.63..124,329,961.30 rows=3,297,870 width=565) (actual rows= loops=)

  • Sort Key: lkp.label_key, lkp.label_name, lkp.thumbnail_url, (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), kpi_track.label_key)), kpi_group_track.label_key)), kpi_album.label_key)), kpi_group_album.label_key)), kpi_artist.label_key)), lkp.label_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)), kpi_track.customer_key)), kpi_group_track.customer_key)), kpi_album.customer_key)), kpi_group_album.customer_key)), kpi_artist.customer_key)), '-999999'::integer)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code)), kpi_track.country_code)), kpi_group_track.country_code)), kpi_album.country_code)), kpi_group_album.country_code)), kpi_artist.country_code)), 'No Country'::character varying)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)), kpi_track.wea_key)), kpi_group_track.wea_key)), kpi_album.wea_key)), kpi_group_album.wea_key)), kpi_artist.wea_key)), '-999999'::integer)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)), kpi_track.lsl_key)), kpi_group_track.lsl_key)), kpi_album.lsl_key)), kpi_group_album.lsl_key)), kpi_artist.lsl_key)), '-999999'::integer)), ((COALESCE(kpi_track.track_count, '0'::bigint))::integer), ((COALESCE(kpi_group_track.group_track_count, '0'::bigint))::integer), ((COALESCE(kpi_album.album_count, '0'::bigint))::integer), ((COALESCE(kpi_group_album.group_album_count, '0'::bigint))::integer), ((COALESCE(kpi_artist.artist_count, '0'::bigint))::integer), ((COALESCE(cnt_track.track_count, '0'::bigint))::integer), ((COALESCE(cnt_group_track.group_track_count, '0'::bigint))::integer), (COALESCE(cnt_album.album_count, '0'::bigint)), (COALESCE(cnt_group_album.group_album_count, '0'::bigint)), (COALESCE(cnt_artist.artist_count, '0'::bigint)), ((SubPlan 21)), ((SubPlan 22)), ((SubPlan 23)), ((SubPlan 24)), ((SubPlan 25)), ((SubPlan 26)), ((SubPlan 27)), ((SubPlan 28)), ((SubPlan 29)), ((SubPlan 30)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type)), kpi_track.sales_type)), kpi_group_track.sales_type)), kpi_album.sales_type)), kpi_group_album.sales_type)), kpi_artist.sales_type)), 'Non Sold'::text))
148. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=5,724,663.93..122,296,410.03 rows=3,297,870 width=565) (actual rows= loops=)

  • Hash Cond: (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), kpi_track.label_key)), kpi_group_track.label_key)), kpi_album.label_key)), kpi_group_album.label_key)), kpi_artist.label_key) = lkp.label_key)
149. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=5,724,425.04..5,757,690.02 rows=1,648,935 width=460) (actual rows= loops=)

  • Merge Cond: (((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)), kpi_track.customer_key)), kpi_group_track.customer_key)), kpi_album.customer_key)), kpi_group_album.customer_key)) = kpi_artist.customer_key) AND (((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code)), kpi_track.country_code)), kpi_group_track.country_code)), kpi_album.country_code)), kpi_group_album.country_code))::text) = (kpi_artist.country_code)::text) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), kpi_track.label_key)), kpi_group_track.label_key)), kpi_album.label_key)), kpi_group_album.label_key)) = kpi_artist.label_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)), kpi_track.wea_key)), kpi_group_track.wea_key)), kpi_album.wea_key)), kpi_group_album.wea_key)) = kpi_artist.wea_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)), kpi_track.lsl_key)), kpi_group_track.lsl_key)), kpi_album.lsl_key)), kpi_group_album.lsl_key)) = kpi_artist.lsl_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type)), kpi_track.sales_type)), kpi_group_track.sales_type)), kpi_album.sales_type)), kpi_group_album.sales_type)) = kpi_artist.sales_type))
150. 0.000 0.000 ↓ 0.0

Sort (cost=5,722,953.01..5,727,075.35 rows=1,648,935 width=576) (actual rows= loops=)

  • Sort Key: (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)), kpi_track.customer_key)), kpi_group_track.customer_key)), kpi_album.customer_key)), kpi_group_album.customer_key)), ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code)), kpi_track.country_code)), kpi_group_track.country_code)), kpi_album.country_code)), kpi_group_album.country_code))::text), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), kpi_track.label_key)), kpi_group_track.label_key)), kpi_album.label_key)), kpi_group_album.label_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)), kpi_track.wea_key)), kpi_group_track.wea_key)), kpi_album.wea_key)), kpi_group_album.wea_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)), kpi_track.lsl_key)), kpi_group_track.lsl_key)), kpi_album.lsl_key)), kpi_group_album.lsl_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type)), kpi_track.sales_type)), kpi_group_track.sales_type)), kpi_album.sales_type)), kpi_group_album.sales_type))
151. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=5,096,854.76..5,129,972.89 rows=1,648,935 width=576) (actual rows= loops=)

  • Merge Cond: (((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)), kpi_track.customer_key)), kpi_group_track.customer_key)), kpi_album.customer_key)) = kpi_group_album.customer_key) AND (((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code)), kpi_track.country_code)), kpi_group_track.country_code)), kpi_album.country_code))::text) = (kpi_group_album.country_code)::text) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), kpi_track.label_key)), kpi_group_track.label_key)), kpi_album.label_key)) = kpi_group_album.label_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)), kpi_track.wea_key)), kpi_group_track.wea_key)), kpi_album.wea_key)) = kpi_group_album.wea_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)), kpi_track.lsl_key)), kpi_group_track.lsl_key)), kpi_album.lsl_key)) = kpi_group_album.lsl_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type)), kpi_track.sales_type)), kpi_group_track.sales_type)), kpi_album.sales_type)) = kpi_group_album.sales_type))
152. 0.000 0.000 ↓ 0.0

Sort (cost=5,096,179.16..5,100,301.50 rows=1,648,935 width=540) (actual rows= loops=)

  • Sort Key: (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)), kpi_track.customer_key)), kpi_group_track.customer_key)), kpi_album.customer_key)), ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code)), kpi_track.country_code)), kpi_group_track.country_code)), kpi_album.country_code))::text), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), kpi_track.label_key)), kpi_group_track.label_key)), kpi_album.label_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)), kpi_track.wea_key)), kpi_group_track.wea_key)), kpi_album.wea_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)), kpi_track.lsl_key)), kpi_group_track.lsl_key)), kpi_album.lsl_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type)), kpi_track.sales_type)), kpi_group_track.sales_type)), kpi_album.sales_type))
153. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=4,492,684.08..4,525,742.54 rows=1,648,935 width=540) (actual rows= loops=)

  • Merge Cond: (((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)), kpi_track.customer_key)), kpi_group_track.customer_key)) = kpi_album.customer_key) AND (((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code)), kpi_track.country_code)), kpi_group_track.country_code))::text) = (kpi_album.country_code)::text) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), kpi_track.label_key)), kpi_group_track.label_key)) = kpi_album.label_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)), kpi_track.wea_key)), kpi_group_track.wea_key)) = kpi_album.wea_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)), kpi_track.lsl_key)), kpi_group_track.lsl_key)) = kpi_album.lsl_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type)), kpi_track.sales_type)), kpi_group_track.sales_type)) = kpi_album.sales_type))
154. 0.000 0.000 ↓ 0.0

Sort (cost=4,492,316.02..4,496,438.35 rows=1,648,935 width=504) (actual rows= loops=)

  • Sort Key: (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)), kpi_track.customer_key)), kpi_group_track.customer_key)), ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code)), kpi_track.country_code)), kpi_group_track.country_code))::text), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), kpi_track.label_key)), kpi_group_track.label_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)), kpi_track.wea_key)), kpi_group_track.wea_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)), kpi_track.lsl_key)), kpi_group_track.lsl_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type)), kpi_track.sales_type)), kpi_group_track.sales_type))
155. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=3,903,791.50..3,950,057.89 rows=1,648,935 width=504) (actual rows= loops=)

  • Merge Cond: (((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)), kpi_track.customer_key)) = kpi_group_track.customer_key) AND (((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code)), kpi_track.country_code))::text) = (kpi_group_track.country_code)::text) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), kpi_track.label_key)) = kpi_group_track.label_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)), kpi_track.wea_key)) = kpi_group_track.wea_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)), kpi_track.lsl_key)) = kpi_group_track.lsl_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type)), kpi_track.sales_type)) = kpi_group_track.sales_type))
156. 0.000 0.000 ↓ 0.0

Sort (cost=3,785,375.88..3,789,498.22 rows=1,648,935 width=468) (actual rows= loops=)

  • Sort Key: (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)), kpi_track.customer_key)), ((COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code)), kpi_track.country_code))::text), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), kpi_track.label_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)), kpi_track.wea_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)), kpi_track.lsl_key)), (COALESCE((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type)), kpi_track.sales_type))
157. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=3,231,388.77..3,265,664.76 rows=1,648,935 width=468) (actual rows= loops=)

  • Merge Cond: (((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)) = kpi_track.customer_key) AND (((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code))::text) = (kpi_track.country_code)::text) AND ((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)) = kpi_track.label_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)) = kpi_track.wea_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)) = kpi_track.lsl_key) AND ((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type)) = kpi_track.sales_type))
158. 0.000 0.000 ↓ 0.0

Sort (cost=3,223,909.88..3,228,032.22 rows=1,648,935 width=432) (actual rows= loops=)

  • Sort Key: (COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), cnt_artist.customer_key)), ((COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code)), cnt_artist.country_code))::text), (COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), cnt_artist.label_key)), (COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), cnt_artist.wea_key)), (COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), cnt_artist.lsl_key)), (COALESCE((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)), cnt_artist.sales_type))
159. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=2,670,542.19..2,732,377.26 rows=1,648,935 width=432) (actual rows= loops=)

  • Merge Cond: (((COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)) = cnt_artist.customer_key) AND (((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code))::text) = (cnt_artist.country_code)::text) AND ((COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)) = cnt_artist.label_key) AND ((COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)) = cnt_artist.wea_key) AND ((COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)) = cnt_artist.lsl_key) AND ((COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type)) = cnt_artist.sales_type))
160. 0.000 0.000 ↓ 0.0

Sort (cost=2,365,834.37..2,369,956.70 rows=1,648,935 width=392) (actual rows= loops=)

  • Sort Key: (COALESCE((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), cnt_group_album.customer_key)), ((COALESCE((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code)), cnt_group_album.country_code))::text), (COALESCE((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), cnt_group_album.label_key)), (COALESCE((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), cnt_group_album.wea_key)), (COALESCE((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), cnt_group_album.lsl_key)), (COALESCE((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)), cnt_group_album.sales_type))
161. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=1,858,044.57..1,902,483.74 rows=1,648,935 width=392) (actual rows= loops=)

  • Merge Cond: (((COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)) = cnt_group_album.customer_key) AND (((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code))::text) = (cnt_group_album.country_code)::text) AND ((COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)) = cnt_group_album.label_key) AND ((COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)) = cnt_group_album.wea_key) AND ((COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)) = cnt_group_album.lsl_key) AND ((COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type)) = cnt_group_album.sales_type))
162. 0.000 0.000 ↓ 0.0

Sort (cost=1,718,280.99..1,722,403.33 rows=1,648,935 width=352) (actual rows= loops=)

  • Sort Key: (COALESCE((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), cnt_album.customer_key)), ((COALESCE((COALESCE(cnt_track.country_code, cnt_group_track.country_code)), cnt_album.country_code))::text), (COALESCE((COALESCE(cnt_track.label_key, cnt_group_track.label_key)), cnt_album.label_key)), (COALESCE((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), cnt_album.wea_key)), (COALESCE((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), cnt_album.lsl_key)), (COALESCE((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)), cnt_album.sales_type))
163. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=1,237,469.13..1,283,108.87 rows=1,648,935 width=352) (actual rows= loops=)

  • Merge Cond: (((COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)) = cnt_album.customer_key) AND (((COALESCE(cnt_track.country_code, cnt_group_track.country_code))::text) = (cnt_album.country_code)::text) AND ((COALESCE(cnt_track.label_key, cnt_group_track.label_key)) = cnt_album.label_key) AND ((COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)) = cnt_album.wea_key) AND ((COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)) = cnt_album.lsl_key) AND ((COALESCE(cnt_track.sales_type, cnt_group_track.sales_type)) = cnt_album.sales_type))
164. 0.000 0.000 ↓ 0.0

Sort (cost=1,086,489.02..1,090,611.35 rows=1,648,935 width=312) (actual rows= loops=)

  • Sort Key: (COALESCE(cnt_track.customer_key, cnt_group_track.customer_key)), ((COALESCE(cnt_track.country_code, cnt_group_track.country_code))::text), (COALESCE(cnt_track.label_key, cnt_group_track.label_key)), (COALESCE(cnt_track.wea_key, cnt_group_track.wea_key)), (COALESCE(cnt_track.lsl_key, cnt_group_track.lsl_key)), (COALESCE(cnt_track.sales_type, cnt_group_track.sales_type))
165. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=609,415.65..679,495.39 rows=1,648,935 width=312) (actual rows= loops=)

  • Merge Cond: ((cnt_track.customer_key = cnt_group_track.customer_key) AND ((cnt_track.country_code)::text = (cnt_group_track.country_code)::text) AND (cnt_track.label_key = cnt_group_track.label_key) AND (cnt_track.wea_key = cnt_group_track.wea_key) AND (cnt_track.lsl_key = cnt_group_track.lsl_key) AND (cnt_track.sales_type = cnt_group_track.sales_type))
166. 0.000 0.000 ↓ 0.0

Sort (cost=304,707.82..308,830.16 rows=1,648,935 width=120) (actual rows= loops=)

  • Sort Key: cnt_track.customer_key, cnt_track.country_code, cnt_track.label_key, cnt_track.wea_key, cnt_track.lsl_key, cnt_track.sales_type
167. 0.000 0.000 ↓ 0.0

CTE Scan on cnt_track (cost=0.00..32,978.70 rows=1,648,935 width=120) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

Materialize (cost=304,707.82..312,952.50 rows=1,648,935 width=120) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Sort (cost=304,707.82..308,830.16 rows=1,648,935 width=120) (actual rows= loops=)

  • Sort Key: cnt_group_track.customer_key, cnt_group_track.country_code, cnt_group_track.label_key, cnt_group_track.wea_key, cnt_group_track.lsl_key, cnt_group_track.sales_type
170. 0.000 0.000 ↓ 0.0

CTE Scan on cnt_group_track (cost=0.00..32,978.70 rows=1,648,935 width=120) (actual rows= loops=)

171. 0.000 0.000 ↓ 0.0

Materialize (cost=150,980.12..155,175.96 rows=839,168 width=120) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Sort (cost=150,980.12..153,078.04 rows=839,168 width=120) (actual rows= loops=)

  • Sort Key: cnt_album.customer_key, cnt_album.country_code, cnt_album.label_key, cnt_album.wea_key, cnt_album.lsl_key, cnt_album.sales_type
173. 0.000 0.000 ↓ 0.0

CTE Scan on cnt_album (cost=0.00..16,783.36 rows=839,168 width=120) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Materialize (cost=139,763.58..143,659.28 rows=779,140 width=120) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Sort (cost=139,763.58..141,711.43 rows=779,140 width=120) (actual rows= loops=)

  • Sort Key: cnt_group_album.customer_key, cnt_group_album.country_code, cnt_group_album.label_key, cnt_group_album.wea_key, cnt_group_album.lsl_key, cnt_group_album.sales_type
176. 0.000 0.000 ↓ 0.0

CTE Scan on cnt_group_album (cost=0.00..15,582.80 rows=779,140 width=120) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Materialize (cost=304,707.82..312,952.50 rows=1,648,935 width=120) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Sort (cost=304,707.82..308,830.16 rows=1,648,935 width=120) (actual rows= loops=)

  • Sort Key: cnt_artist.customer_key, cnt_artist.country_code, cnt_artist.label_key, cnt_artist.wea_key, cnt_artist.lsl_key, cnt_artist.sales_type
179. 0.000 0.000 ↓ 0.0

CTE Scan on cnt_artist (cost=0.00..32,978.70 rows=1,648,935 width=120) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Sort (cost=7,478.89..7,664.22 rows=74,130 width=120) (actual rows= loops=)

  • Sort Key: kpi_track.customer_key, kpi_track.country_code, kpi_track.label_key, kpi_track.wea_key, kpi_track.lsl_key, kpi_track.sales_type
181. 0.000 0.000 ↓ 0.0

CTE Scan on kpi_track (cost=0.00..1,482.60 rows=74,130 width=120) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Materialize (cost=118,415.62..121,737.54 rows=664,384 width=120) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Sort (cost=118,415.62..120,076.58 rows=664,384 width=120) (actual rows= loops=)

  • Sort Key: kpi_group_track.customer_key, kpi_group_track.country_code, kpi_group_track.label_key, kpi_group_track.wea_key, kpi_group_track.lsl_key, kpi_group_track.sales_type
184. 0.000 0.000 ↓ 0.0

CTE Scan on kpi_group_track (cost=0.00..13,287.68 rows=664,384 width=120) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Sort (cost=368.07..379.46 rows=4,557 width=120) (actual rows= loops=)

  • Sort Key: kpi_album.customer_key, kpi_album.country_code, kpi_album.label_key, kpi_album.wea_key, kpi_album.lsl_key, kpi_album.sales_type
186. 0.000 0.000 ↓ 0.0

CTE Scan on kpi_album (cost=0.00..91.14 rows=4,557 width=120) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Sort (cost=675.59..695.51 rows=7,967 width=120) (actual rows= loops=)

  • Sort Key: kpi_group_album.customer_key, kpi_group_album.country_code, kpi_group_album.label_key, kpi_group_album.wea_key, kpi_group_album.lsl_key, kpi_group_album.sales_type
188. 0.000 0.000 ↓ 0.0

CTE Scan on kpi_group_album (cost=0.00..159.34 rows=7,967 width=120) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Sort (cost=1,472.03..1,512.93 rows=16,358 width=120) (actual rows= loops=)

  • Sort Key: kpi_artist.customer_key, kpi_artist.country_code, kpi_artist.label_key, kpi_artist.wea_key, kpi_artist.lsl_key, kpi_artist.sales_type
190. 0.000 0.000 ↓ 0.0

CTE Scan on kpi_artist (cost=0.00..327.16 rows=16,358 width=120) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Hash (cost=147.84..147.84 rows=7,284 width=113) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Seq Scan on lkp_label lkp (cost=0.00..147.84 rows=7,284 width=113) (actual rows= loops=)

193.          

SubPlan (forHash Right Join)

194. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.52..3.53 rows=1 width=32) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.77..2.27 rows=100 width=32) (actual rows= loops=)

  • Group Key: unnest(ARRAY[string_to_array(kpi_track.track_agg, ','::text)])
196. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

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

198. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.52..3.53 rows=1 width=32) (actual rows= loops=)

199. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.77..2.27 rows=100 width=32) (actual rows= loops=)

  • Group Key: unnest(ARRAY[string_to_array(kpi_group_track.group_track_agg, ','::text)])
200. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

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

202. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.52..3.53 rows=1 width=32) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.77..2.27 rows=100 width=32) (actual rows= loops=)

  • Group Key: unnest(ARRAY[string_to_array(kpi_album.album_agg, ','::text)])
204. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

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

206. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.52..3.53 rows=1 width=32) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.77..2.27 rows=100 width=32) (actual rows= loops=)

  • Group Key: unnest(ARRAY[string_to_array(kpi_group_album.group_album_agg, ','::text)])
208. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

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

210. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.52..3.53 rows=1 width=32) (actual rows= loops=)

211. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.77..2.27 rows=100 width=32) (actual rows= loops=)

  • Group Key: unnest(ARRAY[string_to_array(kpi_artist.artist_agg, ','::text)])
212. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

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

214. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.52..3.53 rows=1 width=32) (actual rows= loops=)

215. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.77..2.27 rows=100 width=32) (actual rows= loops=)

  • Group Key: unnest(ARRAY[string_to_array(cnt_track.track_agg, ','::text)])
216. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual rows= loops=)

217. 0.000 0.000 ↓ 0.0

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

218. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.52..3.53 rows=1 width=32) (actual rows= loops=)

219. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.77..2.27 rows=100 width=32) (actual rows= loops=)

  • Group Key: unnest(ARRAY[string_to_array(cnt_group_track.group_track_agg, ','::text)])
220. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual rows= loops=)

221. 0.000 0.000 ↓ 0.0

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

222. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.52..3.53 rows=1 width=32) (actual rows= loops=)

223. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.77..2.27 rows=100 width=32) (actual rows= loops=)

  • Group Key: unnest(ARRAY[string_to_array(cnt_album.album_agg, ','::text)])
224. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

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

226. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.52..3.53 rows=1 width=32) (actual rows= loops=)

227. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.77..2.27 rows=100 width=32) (actual rows= loops=)

  • Group Key: unnest(ARRAY[string_to_array(cnt_group_album.group_album_agg, ','::text)])
228. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual rows= loops=)

229. 0.000 0.000 ↓ 0.0

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

230. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.52..3.53 rows=1 width=32) (actual rows= loops=)

231. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.77..2.27 rows=100 width=32) (actual rows= loops=)

  • Group Key: unnest(ARRAY[string_to_array(cnt_artist.artist_agg, ','::text)])
232. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual rows= loops=)

233. 0.000 0.000 ↓ 0.0

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