Add Spine Events Source Run Summary Index
completetasks8/8add-spine-events-source-run-summary-index
openspec/changes/add-spine-events-source-run-summary-index/View on GitHub →
Artifacts
Official change artifacts tracked under openspec/.
Proposal
listSpineCorrelations aggregates spine_events by correlation id and supports source filters. Postgres already carries a source/run summary index for that hot path; SQLite lacked equivalent coverage.
Design
The aggregation hot path builds a GROUP BY query over spineevents, applying stable filters such as sourcekind and sourceid before hydrating bounded summary rows. Postgres bootstrap and migration DDL already include idxpgspineeventssourcerun_summary for the source-filtered run summary shape.
Tasks (8/8)
Spec Deltas (1)
Affected capabilities
Capability specs this change proposes to modify.