A PostgreSQL database with 50 million rows across multiple tables is experiencing performance issues with complex analytical queries taking over 2 minutes. These queries involve joins between 5+ tables with various aggregations and filtering conditions. Provide a comprehensive optimization strategy that includes query rewriting, indexing strategies, partitioning approaches, and configuration adjustments. Explain how you would analyze the query execution plan and identify bottlenecks.