# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Subquery Scan outer_q (cost=7,156,219,586,018.04..7,156,219,595,690.64 rows=281 width=4,674) (actual rows= loops=)
|
||
2. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Window (cost=7,156,219,586,018.04..7,156,219,594,989.72 rows=56,073 width=919) (actual rows= loops=)
|
||
3. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Sort (cost=7,156,219,586,018.04..7,156,219,586,158.23 rows=56,073 width=919) (actual rows= loops=)
|
||
4. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Network (cost=35,157,824.17..6,156,219,581,595.28 rows=56,073 width=919) (actual rows= loops=)
|
||
5. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash Join DS_BCAST_INNER (cost=35,157,824.17..6,156,219,581,595.28 rows=56,073 width=919) (actual rows= loops=)
|
||
6. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash Left Join DS_DIST_OUTER (cost=498,310.22..6,155,080,910,259.27 rows=18,691 width=751) (actual rows= loops=)
|
||
7. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash Left Join DS_DIST_INNER (cost=494,289.55..6,152,873,031,256.14 rows=18,691 width=747) (actual rows= loops=)
|
||
8. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash Left Join DS_DIST_OUTER (cost=492,872.59..6,151,376,523,463.33 rows=18,691 width=641) (actual rows= loops=)
|
||
9. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash Left Join DS_DIST_OUTER (cost=491,778.07..6,149,565,831,323.27 rows=18,691 width=610) (actual rows= loops=)
|
||
10. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash Left Join DS_DIST_OUTER (cost=490,683.56..6,147,848,594,183.21 rows=18,691 width=579) (actual rows= loops=)
|
||
11. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash Left Join DS_DIST_OUTER (cost=489,589.05..6,146,224,812,043.15 rows=18,691 width=548) (actual rows= loops=)
|
||
12. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash Join DS_DIST_BOTH (cost=488,494.54..6,144,682,803,028.09 rows=18,691 width=517) (actual rows= loops=)
|
||
13. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash Join DS_BCAST_INNER (cost=619.98..39,700,159,107.12 rows=88,989,756 width=412) (actual rows= loops=)
|
||
14. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Subquery Scan hmd (cost=0.00..11,380,566.28 rows=223,224,051 width=324) (actual rows= loops=) |
||
15. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Multi Scan (cost=0.00..9,148,325.77 rows=223,224,051 width=133) (actual rows= loops=) |
||
16. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on fact_hmd_na (cost=0.00..3,202,926.10 rows=107,364,704 width=133) (actual rows= loops=)
|
||
17. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on fact_hmd_fe (cost=0.00..482,989.36 rows=14,794,820 width=132) (actual rows= loops=)
|
||
18. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on fact_hmd_eu (cost=0.00..1,607,952.27 rows=52,838,129 width=133) (actual rows= loops=)
|
||
19. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on fact_hmd_in (cost=0.00..1,606,747.49 rows=47,657,954 width=133) (actual rows= loops=)
|
||
20. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on fact_hmd_sa (cost=0.00..15,470.05 rows=568,444 width=132) (actual rows= loops=)
|
||
21. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash (cost=413.32..413.32 rows=41,332 width=88) (actual rows= loops=) |
||
22. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on dim_cs_routing_skills dcrs (cost=0.00..413.32 rows=41,332 width=88) (actual rows= loops=)
|
||
23. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash (cost=425,522.97..425,522.97 rows=12,470,318 width=125) (actual rows= loops=) |
||
24. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on dim_ab_customers (cost=0.00..425,522.97 rows=12,470,318 width=125) (actual rows= loops=)
|
||
25. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash (cost=875.61..875.61 rows=87,561 width=35) (actual rows= loops=) |
||
26. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on dim_agent_sic_all_nodes d1 (cost=0.00..875.61 rows=87,561 width=35) (actual rows= loops=) |
||
27. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash (cost=875.61..875.61 rows=87,561 width=35) (actual rows= loops=) |
||
28. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on dim_agent_sic_all_nodes d2 (cost=0.00..875.61 rows=87,561 width=35) (actual rows= loops=) |
||
29. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash (cost=875.61..875.61 rows=87,561 width=35) (actual rows= loops=) |
||
30. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on dim_agent_sic_all_nodes d3 (cost=0.00..875.61 rows=87,561 width=35) (actual rows= loops=) |
||
31. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash (cost=875.61..875.61 rows=87,561 width=35) (actual rows= loops=) |
||
32. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on dim_agent_sic_all_nodes d4 (cost=0.00..875.61 rows=87,561 width=35) (actual rows= loops=) |
||
33. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash (cost=629.76..629.76 rows=62,976 width=142) (actual rows= loops=) |
||
34. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on dim_contact_reason_group dcrg (cost=0.00..629.76 rows=62,976 width=142) (actual rows= loops=) |
||
35. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash (cost=3,216.54..3,216.54 rows=321,654 width=21) (actual rows= loops=) |
||
36. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on pbi_spend_dates pbi (cost=0.00..3,216.54 rows=321,654 width=21) (actual rows= loops=) |
||
37. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Hash (cost=34,659,512.45..34,659,512.45 rows=600 width=176) (actual rows= loops=) |
||
38. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Subquery Scan ct (cost=15,450,968.05..34,659,512.45 rows=600 width=176) (actual rows= loops=) |
||
39. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Append (cost=15,450,968.05..34,659,506.45 rows=600 width=172) (actual rows= loops=) |
||
40. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Subquery Scan "*SELECT* 1" (cost=15,450,968.05..15,450,974.55 rows=200 width=172) (actual rows= loops=) |
||
41. | 0.000 | 0.000 | ↓ 0.0 |
→
XN HashAggregate (cost=15,450,968.05..15,450,972.55 rows=200 width=172) (actual rows= loops=) |
||
42. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Subquery Scan volt_dt_1 (cost=13,742,324.41..14,674,311.85 rows=31,066,248 width=172) (actual rows= loops=) |
||
43. | 0.000 | 0.000 | ↓ 0.0 |
→
XN HashAggregate (cost=13,742,324.41..14,363,649.37 rows=31,066,248 width=52) (actual rows= loops=) |
||
44. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on fact_contact_skill_na (cost=0.00..5,975,762.61 rows=310,662,472 width=52) (actual rows= loops=)
|
||
45. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Subquery Scan "*SELECT* 2" (cost=1,034,758.13..1,034,764.63 rows=200 width=172) (actual rows= loops=) |
||
46. | 0.000 | 0.000 | ↓ 0.0 |
→
XN HashAggregate (cost=1,034,758.13..1,034,762.63 rows=200 width=172) (actual rows= loops=) |
||
47. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Subquery Scan volt_dt_2 (cost=923,201.35..984,050.50 rows=2,028,305 width=172) (actual rows= loops=) |
||
48. | 0.000 | 0.000 | ↓ 0.0 |
→
XN HashAggregate (cost=923,201.35..963,767.45 rows=2,028,305 width=52) (actual rows= loops=) |
||
49. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Seq Scan on fact_contact_skill_fe (cost=0.00..416,125.28 rows=20,283,043 width=52) (actual rows= loops=)
|
||
50. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Subquery Scan "*SELECT* 3" (cost=18,173,760.77..18,173,767.27 rows=200 width=172) (actual rows= loops=) |
||
51. | 0.000 | 0.000 | ↓ 0.0 |
→
XN HashAggregate (cost=18,173,760.77..18,173,765.27 rows=200 width=172) (actual rows= loops=) |
||
52. | 0.000 | 0.000 | ↓ 0.0 |
→
XN Subquery Scan volt_dt_3 (cost=16,178,926.01..17,267,017.70 rows=36,269,723 width=172) (actual rows= loops=) |
||
53. | 0.000 | 0.000 | ↓ 0.0 |
→
XN HashAggregate (cost=16,178,926.01..16,904,320.47 rows=36,269,723 width=52) (actual rows= loops=) |