EXPLAIN ANALYZE teeth_agg practica report query (1661ms mean, /informes teeth aggregation)

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-16
• wi-cli-venus completed · 4w ago
  BENIGN-CLOSE with live evidence (db-mars-cc, 2026-07-15 dbperf triage): teeth_agg lives in getScopedPracticas (src/lib/practica.ts:129), the main /practicas list — first-ever top-50 cost-rank appearance in the collector's full month of history, crossed threshold via organic traffic growth (zero related commits since 7/13). Live warm-cache production mean = 163.1ms/157 calls, 100% cache hit — 10x faster than this WI's original 1661ms figure, which was almost certainly a manual cold-cache EXPLAIN ANALYZE. No action needed.