Whenever you're ready, walk me through how you'd approach this.
How would you optimize a slow-running SQL query that joins multiple large tables?
Explain how you would diagnose the bottleneck, improve the query and schema, and validate that the changes help. Cover PostgreSQL execution plans, join conditions, filtering, indexes, statistics, and trade-offs.