Understanding your database is understanding where your application actually spends most of its time. These articles go deep into PostgreSQL: how queries are parsed, planned, and executed, how to read execution plans, practical performance techniques, and the process and memory architecture that makes it all work.

Articles are numbered in recommended reading order. Start with the query pipeline to build the mental model, then use EXPLAIN ANALYZE to diagnose real queries.