How SQL runs and how to read a PostgreSQL execution plan
How a query moves through the parser, planner and executor; the logical order of clauses; EXPLAIN ANALYZE and BUFFERS; scan types; reading cost, rows and loops; finding slow queries with pg_stat_statements.