- Published on
A production workflow for finding slow SQL queries, reading EXPLAIN plans, choosing fixes, and proving the endpoint improved.
Databases
All Posts
- software-engineering (26)
- backend (24)
- reliability (21)
- distributed-systems (15)
- databases (14)
- production-systems (9)
- performance (8)
- architecture (7)
- api-design (6)
- testing (5)
- microservices (5)
- fundamentals (4)
- observability (4)
- debugging (4)
- sql (4)
- best-practices (3)
- cascading-failures (3)
- systems (3)
- code-review (2)
- engineering-process (2)
- ci (2)
- Published on
How to detect and fix the N+1 query problem in ORMs with query counts, SQL traces, eager loading, batched IN queries, and request-scoped loaders.- Published on
Why read replicas often fail to reduce primary database load when reads are coupled to writes, replica lag triggers fallback, and query cost is misread.- Published on
Why a database index can exist and still fail to speed up a query: selectivity, row estimates, composite index order, and ORDER BY LIMIT behavior.