Use cases

Where the closed loop earns its keep.

Five real patterns from the OpsKeeper workflow catalog. Each one shipped as a reproducible scenario in the repo so you can replay it end-to-end.

Financial core trading·PostgreSQL

Cut the MTTR on a 3 a.m. connection-pool storm.

Problem

A connection-pool exhaustion incident in the trading database cascaded into order-rejection alerts and exchange-side timeouts. On-call had to correlate Loki logs, Prometheus graphs, and a recently-shipped migration under pressure.

How OpsKeeper helped

OpsKeeper grouped the 47 raw alerts into one incident, traced the RCA back to a connection-pool floor mismatch on the new replica, and proposed raising the floor with explicit blast radius. A human approver signed it in 90 seconds. The verifier confirmed recovery from a four-metric allowlist.

MTTR: 31 minutes → 4 minutes. No exchange-side rollback needed.
Workflow
pg-connection-pool-exhaustion
Severity
critical
SaaS multi-tenant·PostgreSQL · Kubernetes

Stop a noisy neighbour before customers tweet.

Problem

A single noisy tenant on a shared Postgres cluster pushed replica replay lag past 60 seconds for everyone. The platform team needed to identify the tenant and route only their reads away, without affecting the other 1,200 tenants.

How OpsKeeper helped

OpsKeeper correlated the lag spike to one tenant via Qdrant vector recall on historical patterns, drafted a proposal to enable read-only routing for that tenant, and verified recovery against the replay-lag allowlist. The loop ran end-to-end without paging a human until the approval gate.

Customer-visible impact: 4 minutes for one tenant, 0 for the rest.
Workflow
pg-replica-replay-lag
Severity
warn
Retail POS·Edge install

A regional POP goes offline. Stores stay open.

Problem

A regional POP lost upstream connectivity. Local POS terminals kept running on the edge cache but the central OpsKeeper control plane was unreachable. The team needed an autonomous edge that could still emit a clean audit trail.

How OpsKeeper helped

The opskeeper-edge daemon buffered evidence locally and reconnected to the control plane when the POP recovered. The HMAC-chained ledger replayed end-to-end on the central side, with no audit gap and no manual reconciliation.

Zero data loss. Zero manual reconciliation. 19 stores stayed open.
Workflow
edge-resilience
Severity
error
Manufacturing OT/IT·Disk · Compute

A bad checkpoint storms a shop-floor historian.

Problem

A nightly checkpoint on the historian database collided with peak-shift IOPS and saturated the disk subsystem. Production telemetry started dropping. Manual intervention was not an option — the line could not stop.

How OpsKeeper helped

OpsKeeper detected the disk-saturation pattern, traced it to the checkpoint window, and proposed spreading checkpoints across two replicas. The repairer staged the change, the verifier confirmed IOPS recovered below the alert threshold, and the postmortem was auto-drafted for the next morning.

Line uptime: 100%. Disk alerts: zero post-deploy.
Workflow
pg-disk-io-saturation
Severity
critical
Mobile game backend·Lock waits

A long transaction blocks a global event launch.

Problem

A dropped index from a previous release caused lock waits longer than 30 seconds during a global event launch. Player-facing queries stalled and the on-call was staring at a chain of blocked transactions.

How OpsKeeper helped

The investigator traced the blocker back to a single batch job, the reviewer signed off on cancelling it with explicit blast radius, and the verifier confirmed lock waits returned to baseline. The postmortem landed in the team Slack within 60 seconds of recovery.

Launch saved. Postmortem in Slack within 60 seconds of recovery.
Workflow
pg-lock-wait-long-transaction
Severity
error

Have a scenario that is not here?

Open a PR with a new workflow under workflows/ and a matching scenario under deploy/incident-events/. The four PG scenarios in the catalog were all contributed this way.