Life of a SQL query

What happens when you run a SQL statement? We follow a Postgres query transformation by transformation as a query is processed and results are returned.