Glossary term
What is EXPLAIN? Meaning for developers
Shows the plan PostgreSQL chose for a query. With ANALYZE it also runs the query and shows real times.
Learn it properly · SQL & PostgreSQLLesson 5: Indexes and EXPLAINHow a B-tree helps, composite, covering and partial indexes, and reading real EXPLAIN ANALYZE plans on a million rows.