Diagnosing Query Speed Degradation

Let’s say you’re supporting a customer-facing dashboard at Meta that tracks user activity, and you notice that a SQL query which usually returns results in 2–3 seconds is now taking 30 minutes to complete, even though the query hasn’t changed.

How would you approach diagnosing the cause of this sudden performance degradation?