Rewrite teacher-practicas CTE: kill seq-scan on practicas (18.4% DB time) — LATERAL/direct JOIN from studentAssignments, est. 60-70% wall-time cut. Sites: weekly-kpi.ts + reporting.ts. See db/pg-stat-statements-report.md

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-09
• wi-cli-venus parentChanged · 2026-06-09
  parent=#819
• wi-cli-venus completed · 2026-06-14
  perf(reporting): getJtpStats scoped_practicas + roster CTEs rewritten to drive from studentAssignments (kill SA seq-scan, 18.4% DB time). db-mars proved row-equivalence on real prod (Olexen 263/54/209 exact). cost 490→122. Shipped a7a6e09 v2.16.46, audit PASS, live confirmed. weekly-kpi.ts needed no change.