Most developers use databases to support their projects. However, database systems are normally seen as a “black box” to which a developer passes a query in order to get data.
This talk gives some insights in how a query is processed inside PostgreSQL. It provides a step-by-step walk through the different stages of the database backend. It starts with the analysis of the query syntax, explains the planning of the query execution, and finally shows how the result is retrieved.
If you got hungry for more, have a look at the more detailed workshop that follows.