How Does PostgreSQL Decide How to Execute a Query?

When you send a SQL query to a database, have you ever wondered what actually happens behind the scenes? Consider the following query: SELECT * FROM orders WHERE user_id = 123 ORDER BY created_at DESC