Skip to main content

sre.mttr_history

Dated snapshots of every incident, one row per incident per snapshot.

The append-only companion to mttr_current: same source, columns, and provenance, but instead of holding only the latest state it accumulates a dated snapshot of every incident on each upload.

Each row is one incident (incident_id) as it appeared on one snapshot date, so an incident’s metrics can change from one snapshot to the next as it is re-triaged. A row is unique on (incident_id, date).

Keywords: MTTR, MTTA, MTTM, incident, incident response, snapshot, history, severity, reliability, SRE, mean time to resolve

Fields

Every column is identical to mttr_current, with one addition:

Field Name Type Description
date string Snapshot date as YYYY-MM-DD text; the grain that lets this table accumulate. Equals the date portion of fetched_at