On-call ready: locks, connections & replication

PostgreSQL · 5 scenarios

Prototype — data is mocked and actions are not connected yet.

← Goals

PostgreSQL L2

Handle the incidents that page you at 3am — deadlocks, connection storms and replication lag — and resolve them without making it worse.

2 / 5 scenarios passedScore avg 79%
Due Jun 12, 2026 · 6 days left

Scenarios to pass

PostgreSQL Locks & transactions · L2 Classic deadlock 84% Passed
PostgreSQL Connections · L1 Too many connections 74% Passed
PostgreSQL Connections · L2 Connection storm after a restart — In progress
PostgreSQL WAL & replication · L2 Replication lag from a write burst — Not started
PostgreSQL Locks & transactions · L2 Long transaction blocks DDL — Not started

How this goal was set

  • SystemsPostgreSQL
  • LevelMid
  • Focus areasLocks · Connections · Replication
  • IntensityGameDay

The scenario set is assembled from your answers. Re-answer to regenerate it.

Prototype — scenario scores are mocked.