Accelerate Reference Spine Overview Lists
completetasks12/12accelerate-reference-spine-overview-lists
openspec/changes/accelerate-reference-spine-overview-lists/View on GitHub →
Artifacts
Official change artifacts tracked under openspec/.
Proposal
The owner console overview and runs pages block on reference spine list routes. Live measurement after the connector-summary fix showed /ref/traces at about 365-900ms and /ref/runs?limit=100 at about 700-950ms. The traces route was doing a full aggregate over roughly 579k spine events to show six recent rows.
Design
The dashboard home needs a small "what has been read" list and the runs page needs a recent run list. Those are overview reads. Before this change, Postgres computed them by grouping every matching spine_events row, sorting the full aggregate, then hydrating each summary sequentially.
Tasks (12/12)
Spec Deltas (1)
Affected capabilities
Capability specs this change proposes to modify.