Grok Database Performance Tuning Advisor

Tune database performance:

Database: [PostgreSQL/MySQL/MongoDB]
Slow query: [paste query or describe]
Table sizes: [row counts]
Current indexes: [list]
Hardware: [CPU/RAM/storage type]

Provide:
1. Query analysis and bottleneck identification
2. Index recommendations
3. Query rewrite
4. Configuration tuning (shared_buffers, work_mem, etc.)
5. Partitioning strategy if needed
6. Connection pooling advice
7. Monitoring queries to add
8. Benchmark methodology