Technical Debt — Trends & Historical Analytics

Track trends, measure impact and understand historical patterns

It introduces historical tracking and trend analytics for technical debt. Observations are recorded from successful reconciliations and provide time-series visibility, lifecycle activity, and financial history.

▤

Total Items

248↓ 12%vs previous period

⚠

Critical & High

76↑ 8%vs previous period

▥

New Items

32↓ 14%vs previous period

✓

Resolved

54↑ 24%vs previous period

Technical debt trends

Last 6 months

200150100500

AprMayJunJunJulAugSep

Critical & HighMediumLow

Items by lifecycle state

248Total Items

• NOT_APPLICABLE12 (5%)
• PENDING_EVALUATION48 (19%)
• WITHIN_SLA76 (31%)
• DUE_SOON32 (13%)
• OVERDUE28 (11%)
• BREACHED18 (7%)
• RESOLVED54 (22%)

Historical model

Technical debt trends are backed by the following persistence model.

Table	Description
technical_debt_observation_runs	One row per organization per UTC bucketDate.
technical_debt_item_observations	Immutable upsert per (organization, item, day).
technical_debt_inventory_snapshots	Aggregated inventory/financial totals per run.
technical_debt_lifecycle_events	Append-only lifecycle state changes.
technical_debt_financial_history	Daily cost and rightsizing estimates.

Data captured

• Inventory time series (items count by lifecycle state)
• Lifecycle activity counts (created, resolved, reopened)
• Financial history (USD estimates)
• Source collection coverage (cloud, GitHub, policy, etc.)
• Backlog drilldown and trends

◷ Scheduler

♙

TechnicalDebtHistoryScheduler

Runs on TECHNICAL_DEBT_HISTORY_INTERVAL_MS (default 24h) and reconciles organizations that have debt items, refreshing observations.