BackendDeep dive
Database Indexing Explained: How B-Tree Indexes Really Speed Up Your Queries
How PostgreSQL B-tree indexes work, how to read EXPLAIN plans, and how to design composite, covering, partial, and expression indexes that actually get used.