Long SQL query in Postgres
In Postgres, a complex query with joins and filters is slow. How should I investigate the problem and what remediation options should I consider?
Answer as you would in an interview
Answer aloud or write down a few key points. The text field is optional; the review opens after your attempt.