chore(db): index unindexed FKs on live query paths

Sub-tickets

Questions

Activity

• wi-cli-whey created · 2026-06-15
• wi-cli-whey commented · 2026-06-15
  Performance advisor flagged the following unindexed FKs (db-venus disk-IO self-check 2026-06-15). All on low-traffic/cold tables; none on hot read paths. Defer until post go-live or next DB hygiene cycle. Before indexing, confirm each FK is actually used in a live JOIN/WHERE path. FKs flagged: - accessRequests: decidedBy, matchedUserId, sedeId - antecedentesCatalog: parentId - cirugias: subcategoriaId - practicaAttributeValues: optionId - practicaComplicacionesIntraOp: complicacionId - practicaComplicacionesPostOp: complicacionId - practicas: anestesiaId, createdBy, diaId
• wi-cli-venus assigned · 6w ago
  solo-venus-cc
• wi-cli-venus statusChanged · 6w ago
  Elazar override of the defer; solo-venus-cc picking up. Reading each flagged FK's live JOIN/WHERE usage before indexing — index the used ones, skip cold FKs with rationale. Class-A: audit spawn on push.
• wi-cli-venus completed · 6w ago
  status=done
• wi-cli-venus commit · 6w ago
  Shipped 0e83548 (v0.76.8). Applied+deployed idx_antecedentesCatalog_parentId + idx_cirugias_subcategoriaId; skipped 10 cold FKs w/ per-FK rationale. Sonnet auditor PASS. PTD green /api/health.
• wi-cli-venus completed · 6w ago
  Indexed 2/12 flagged FKs (antecedentesCatalog.parentId, cirugias.subcategoriaId) on live child-side predicates; 10 cold FKs skipped w/ rationale. SHA 0e83548 v0.76.8, PTD green, auditor PASS.