cc-context-monitor v2.5: cum_turns column (turns/hour + tokens-per-turn)

Sub-tickets

Questions

Activity

• system created · 2026-05-21
  wi cli
• bin-whey-cc assigned · 2026-05-21
  assigned to bin-whey-cc
• system commented · 2026-05-21
  Add cum_turns INTEGER to context_samples = cumulative count of assistant turns (messages with a usage block; isCompactSummary/system records are NOT turns) — one '+= 1' in the existing jsonl-sum loop, zero extra I/O. MIGRATION: context_samples already exists on all 3 host buffer DBs + the canonical whey DB (v4 schema); CREATE TABLE IF NOT EXISTS will not add the column — v2.5 must run an idempotent ALTER TABLE context_samples ADD COLUMN cum_turns INTEGER (guard the duplicate-column error). The 90d-retention canonical DB on whey especially must get the column or new INSERTs fail. Ship to sh.git as v2.5; deploy = git pull on venus+lezama, whey from own tree, no unit change. Unlocks turns/hour=Δcum_turns/Δt and tokens-per-turn=Δcum_new_tokens/Δcum_turns within a session_id. Dispatched by PM nw-venus-cc, Elazar GO 2026-05-21 01:49.
• system commented · 2026-05-21
  v2.5 SHIPPED to sh.git - commit 94e988b (4f47d98..94e988b). cum_turns INTEGER added (nullable; old v2.4 rows NULL). Idempotent ALTER TABLE migration in metrics_connect() + pull-leg REMOTE_READ self-migrates remote buffers before SELECT (whey v2.5 pull works against still-v2.4 venus/lezama during deploy window). Smoke-tested whey: exit 0, canonical DB migrated in place, 18 sessions logged with cum_turns, tokens-per-turn computes (e.g. coder-mars-cc 10452 vs pm-mars-cc 2996 tok/turn). whey runs v2.5 from own tree. PENDING: venus+lezama git ff-pull 4f47d98->94e988b. Close when both confirm.
• system statusChanged · 2026-05-21
  Code shipped (94e988b), whey live; awaiting venus+lezama ff-pull for fleet-wide activation.
• system commented · 2026-05-21
  lezama pulled v2.5 (94e988b), exit 0, 8 samples logged with cum_turns. whey + lezama on v2.5; awaiting venus ff-pull only.
• system completed · 2026-05-21
  v2.5 cum_turns complete fleet-wide. sh.git 94e988b: cum_turns INTEGER added to context_samples (count of assistant turns); idempotent ALTER TABLE migration in metrics_connect() + pull-leg self-migrates remote buffers. Deployed all 3 hosts (whey own tree, lezama+venus ff-pull to 94e988b), all exit 0, cum_turns populated. Churn metric live: tokens-per-turn = Δcum_new_tokens/Δcum_turns, turns/hour = Δcum_turns/Δt (within session_id). PM nw-venus-cc cleared close 2026-05-21 01:52.