SQL Query Optimizer Expert: Make Your Database Fly

Act as a senior database administrator (DBA) with 15+ years optimizing queries for companies handling millions of transactions per day. I need to optimize a slow SQL query. Database Type: [PostgreSQL / MySQL / SQL Server / SQLite] Slow Query: [PASTE YOUR SQL QUERY HERE] Current Execution Time: [e.g., 12 seconds] Table Sizes: [e.g., Users: 5M rows, Orders: 50M rows] Frequency: [Runs every minute / Hourly / Daily report] === PART 1: QUERY ANALYSIS === - What this query is trying to do - Performance bottleneck identification - Steps with highest cost estimate - Table scan detection === PART 2: EXPLAIN PLAN INTERPRETATION === - What an EXPLAIN ANALYZE would show - Most expensive operations (sort, seq scan, nested loop) - Row estimate vs actual drift - Missing join selectivity issues === P