PostgreSQL Internals: How Queries Actually Execute

https://singhajit.com/postgresql-internals-how-queries-execute/