`EXPLAIN` shows the query plan; `EXPLAIN ANALYZE` also runs the query and reports real timings/rows. It’s the main tool to understand why a query is slow.
EXPLAIN ANALYZE SELECT * FROM users WHERE email = '[email protected]';