What information does EXPLAIN ANALYZE show?

EXPLAIN ANALYZE is a command in SQL that shows the execution plan of a query along with actual execution statistics. It helps understand how the DBMS executes the query, where time and resources are spent.

The main information provided by EXPLAIN ANALYZE includes:

• The query execution plan (e.g., sequential scan, index scan, joins).
• Estimated number of rows at each step.
• Actual number of rows processed.
• Execution time for each step of the plan.
• Resource usage (CPU, I/O).

This allows for query optimization, identifying bottlenecks, and understanding why a query runs slowly.