Learning path
Diagnose a Slow Endpoint
A task-focused journey: from a slow endpoint to the root cause and fix.
backend, SRE · Intermediate · 3 courses · 4 simulations
The path
Courses, then incidents
Work through the courses, then practise the incidents — each step links to its page.
- Course Reading a Query Plan →
- Course Finding the Heavy Queries →
- Course Who Is Doing What →
- query-performance Missing index on a hot endpoint →
- query-performance N+1 query pattern (missing child-table index) →
- query-performance Slow pagination: deep OFFSET meltdown →
- locks-transactions Blocking transaction holds a row lock →