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.

min_severity
incident_queue_reliability_report.sql
Replay: real traced execution (multi-file project)
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 (2)), 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 (1)), 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 (3)), 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;

  1. tables ← 1 row

    1CREATE TABLE incidents (id INTEGER, service TEXT, severity INTEGER, status TEXT);2INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');
    values this step1 rowtables

  2. incidents ← 5 rows

    1CREATE TABLE incidents (id INTEGER, service TEXT, severity INTEGER, status TEXT);2INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');3WITH params(min_severity) AS (VALUES (2)), 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;
    values this step5 rowsincidents

  3. result ← 3 rows

    2INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');3WITH params(min_severity) AS (VALUES (2)), 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;
    values this step3 rowsresult

  1. tables ← 1 row

    1CREATE TABLE incidents (id INTEGER, service TEXT, severity INTEGER, status TEXT);2INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');
    values this step1 rowtables

  2. incidents ← 5 rows

    1CREATE TABLE incidents (id INTEGER, service TEXT, severity INTEGER, status TEXT);2INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');3WITH params(min_severity) AS (VALUES (1)), 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;
    values this step5 rowsincidents

  3. result ← 3 rows

    2INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');3WITH params(min_severity) AS (VALUES (1)), 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;
    values this step3 rowsresult

  1. tables ← 1 row

    1CREATE TABLE incidents (id INTEGER, service TEXT, severity INTEGER, status TEXT);2INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');
    values this step1 rowtables

  2. incidents ← 5 rows

    1CREATE TABLE incidents (id INTEGER, service TEXT, severity INTEGER, status TEXT);2INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');3WITH params(min_severity) AS (VALUES (3)), 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;
    values this step5 rowsincidents

  3. result ← 2 rows

    2INSERT INTO incidents VALUES (1, 'api', 3, 'open'), (2, 'api', 1, 'open'), (3, 'billing', 2, 'open'), (4, 'billing', 3, 'closed'), (5, 'web', 3, 'open');3WITH params(min_severity) AS (VALUES (3)), 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;
    values this step2 rowsresult
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.