EXPLAIN displays the execution plan chosen by the planner for a query, without executing it: operations, order, estimated costs and row counts. It lets you see whether an index is used and understand why a query is slow.
Example
EXPLAIN SELECT * FROM commandes WHERE client_id = 42;