What Actually Happens When You Run a SQL Query?

The query looked harmless. One SELECT, one WHERE clause, one row back. But when I started tracing it through PostgreSQL, the “database lookup” turned into a chain of decisions about protocols, plans,