Definitions / sustained_outage
Sustained outage
2 meaningsAn interruption long enough to count against the network's reliability figures. The regulator counts anything over three minutes; network operations reports interruptions over five minutes, the international convention its benchmarking uses. Both are right for their purpose; until one is made canonical, every answer shows both.
regulator · Regulation Manager · version 1
Unplanned OMS tickets opened in the period and restored after more than 3 minutes (or still open), with the customer minutes lost.
Latest change: First version.
SQL
SELECT o.id AS outage_id, o.feeder_id, o.opened_at, o.restored_at, o.customers,
round(date_diff('second', o.opened_at, coalesce(least(o.restored_at, {now}), {now})) / 60.0, 1) AS minutes,
round(o.customers * date_diff('second', o.opened_at, coalesce(least(o.restored_at, {now}), {now})) / 60.0, 0) AS customer_minutes
FROM outages o
WHERE o.source IN ('calls', 'scada') AND o.opened_at >= {period_start} AND o.opened_at < {period_end}
AND o.opened_at <= {now}
AND (o.restored_at IS NULL OR o.restored_at > {now} OR o.restored_at > o.opened_at + INTERVAL 3 MINUTE)
ORDER BY o.opened_at, o.id
control · Head of Network Operations · version 1
Unplanned interruptions over 5 minutes counted from the meters themselves: tickets opened in the period whose first last gasp came more than 5 minutes before the restore (or which are still open).
Latest change: First version.
SQL
SELECT o.id AS outage_id, o.feeder_id, o.opened_at, o.restored_at, o.customers,
round(date_diff('second', o.opened_at, coalesce(least(o.restored_at, {now}), {now})) / 60.0, 1) AS minutes
FROM outages o
WHERE o.source IN ('calls', 'scada') AND o.opened_at >= {period_start} AND o.opened_at < {period_end}
AND o.opened_at <= {now}
AND (o.restored_at IS NULL OR o.restored_at > {now} OR o.restored_at > o.opened_at + INTERVAL 5 MINUTE)
ORDER BY o.opened_at, o.id
Tests
| meaning | test | result | observed | expected |
|---|---|---|---|---|
| regulator | count_between | pass | 188 | between 20.0 and 400.0 |
| regulator | unique | pass | {'duplicates': 0} | outage_id unique |
| control | count_between | pass | 187 | between 20.0 and 400.0 |
| control | unique | pass | {'duplicates': 0} | outage_id unique |