An execution plan is the tree of operations chosen by the optimizer for a SQL statement. The same SQL may use a sequential scan or an index scan depending on data distribution, statistics, and indexes.
The demo compares a broad scan with an index path that narrows candidates. Inspect actual time, rows, and buffers alongside estimated cost.
When to use
Use EXPLAIN ANALYZE to locate scan, join, or sort bottlenecks in a slow query.