This is a dedicated watch page for a single video.
A single long-running query joins a huge fact with a skewed dimension (one country dominates). AQE is ON, yet shuffle partitions still blow out to 40 000; runtime is 40 minutes. Quickest fix without rewriting the query?