Join Explosion in Revenue Rollup

Scenario: A daily revenue rollup joins events(4B rows) with campaigns(3M rows). Planner picks a huge hash join and spills. Propose one rewrite, one statistics action, and one guardrail metric.