Django6 min
How to Find and Fix N+1 Queries in Django
A practical guide to finding N+1 query problems in Django with django-debug-toolbar and assertNumQueries, and fixing them with select_related, prefetch_related and Prefetch.
Tag
PostgreSQL
2 articles tagged PostgreSQL.
PostgreSQL8 min
PostgreSQL Indexes Explained: How They Actually Improve Query Performance
What a B-tree index really does, how to read EXPLAIN ANALYZE, why column order in composite indexes matters, and when adding an index makes a query slower instead of faster.