What Happens When You Run a SELECT in PostgreSQL?

You type SELECT * FROM users WHERE id = 42 and hit Enter. Results appear almost instantly. But what actually happened in those…