---
title: Quarterly infrastructure review
author: Your name
date: 2026-01-15
toc: true
toc_depth: 2
number_sections: true
theme: newsprint
header: Quarterly infrastructure review
footer: Internal — do not distribute
---

# Summary

Three things changed this quarter, and one of them needs a decision before the
next release.

- Latency at p95 dropped from 480 ms to 310 ms after the query cache was split.
- Two of the four nightly jobs now run in parallel, cutting the batch window by 40%.
- The staging database still has no restore test; this is the open risk.

# Key figures

| Metric | Last quarter | This quarter | Change |
| --- | --- | --- | --- |
| p95 latency | 480 ms | 310 ms | −35% |
| Batch window | 3 h 10 m | 1 h 55 m | −40% |
| Failed jobs / week | 12 | 3 | −75% |

# Method

Every measurement comes from the same dashboard window (00:00–24:00 UTC) so the
numbers stay comparable between quarters.

1. Export the raw series for the full quarter.
2. Drop the two maintenance days.
3. Compare against the same window one quarter earlier.

The query used for the export is intentionally boring:

```sql
select date_trunc('day', created_at) as day,
       percentile_cont(0.95) within group (order by latency_ms) as p95
from requests
where created_at >= :start and created_at < :end
group by 1
order by 1;
```

# Where the time went

![Bar chart: p95 latency by week, falling from 480 ms to 310 ms](figure.png)

Keep `figure.png` next to this file, or replace the path with your own image.
The alt text above is the only thing a screen reader gets — describe what the
chart shows, not that it is a chart.

# Open risk: no restore test

The staging database is backed up nightly, but nobody has restored it since
March. A backup that has never been restored is a hypothesis, not a backup.

# Next steps

| Owner | Action | Due |
| --- | --- | --- |
| Platform | Restore staging from the newest backup and record the time | 2026-01-29 |
| Data | Move the remaining two jobs to the parallel runner | 2026-02-05 |

Write to [the platform channel](https://example.com/platform) if you want to
pick one of these up.
