Operational Reliability Reports

Incident Queue Reliability

Count Visible Severity

Incident reports can filter open incidents by a selected severity threshold and keep high-severity counts visible.

Program

Play the script to choose the minimum severity and inspect the grouped queue counts.

incident_queue_reliability_report.sql 
CREATE TABLE incidents (id INTEGER, service TEXT, severity INTEGER, status TEXT);
INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');
WITH params(min_severity) AS (VALUES ()), visible AS (SELECT service, severity FROM incidents WHERE status = 'open' AND severity >= (SELECT min_severity FROM params)) SELECT service, COUNT(*) AS visible_incidents, SUM(CASE WHEN severity = 3 THEN 1 ELSE 0 END) AS high_incidents FROM visible GROUP BY service ORDER BY service;

CREATE TABLE incidents (id INTEGER, service TEXT, severity INTEGER, status TEXT);
INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');
WITH params(min_severity) AS (VALUES ()), visible AS (SELECT service, severity FROM incidents WHERE status = 'open' AND severity >= (SELECT min_severity FROM params)) SELECT service, COUNT(*) AS visible_incidents, SUM(CASE WHEN severity = 3 THEN 1 ELSE 0 END) AS high_incidents FROM visible GROUP BY service ORDER BY service;

CREATE TABLE incidents (id INTEGER, service TEXT, severity INTEGER, status TEXT);
INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');
WITH params(min_severity) AS (VALUES ()), visible AS (SELECT service, severity FROM incidents WHERE status = 'open' AND severity >= (SELECT min_severity FROM params)) SELECT service, COUNT(*) AS visible_incidents, SUM(CASE WHEN severity = 3 THEN 1 ELSE 0 END) AS high_incidents FROM visible GROUP BY service ORDER BY service;
open incidents The report filters closed incidents out before grouping.
severity threshold `min_severity` controls which open incidents are visible.
high count A separate high-severity count keeps the most serious incidents visible.