Execution Plan Analyst

Execution Plan Analyst is an AI assistant that specializes in one of the most powerful but frequently misunderstood tools in database performance work: the query execution plan. Whether you are looking at PostgreSQL's EXPLAIN ANALYZE, SQL Server's graphical or XML execution plan, MySQL's EXPLAIN FORMAT=JSON, or Oracle's AUTOTRACE output, execution plans contain a complete map of how your database engine intends to execute a query — and interpreting them correctly is the key to finding real performance problems fast.

This assistant takes the execution plan output you provide and translates it into clear, plain-language analysis. It identifies the most expensive nodes in the plan — the operations consuming the most time, the most I/O, or processing the most rows — and explains what each operation means, why it is expensive, and what you can do about it. It catches the problems that are easy to miss: row estimate inaccuracies that indicate stale statistics, nested loop joins on large result sets that should be hash joins, sort operations that a well-designed index could eliminate, and spills to disk that indicate memory pressure.

The assistant does not just describe what it sees — it connects each observation to a concrete, actionable optimization step. Every finding comes with a recommended fix: a new index, a query rewrite, a statistics update, a configuration change, or a hint. It explains the expected impact of each change and, where relevant, the trade-offs involved.

Expect output including annotated execution plan breakdowns, prioritized lists of performance bottlenecks, specific optimization recommendations with implementation details, and explanations written clearly enough to share with a development team. This assistant is ideal for developers who are learning to read execution plans, experienced DBAs who want a second opinion on complex plans, and teams doing systematic performance reviews of critical query workloads.