Analyze query performance with EXPLAIN plan interpretation, bottleneck identification, and optimization recommendations