What does EXPLAIN do? How read a simple query plan.

EXPLAIN

EXPLAIN ANALYZE
SELECT * FROM orders WHERE customer_id = 42;

• Seq Scan vs Index Scan
• Rows estimated vs actual
• Look for nested loops on big tables