basquetWi + New ticket
mars MARS-506

vPracticaHistorial conducto-leg predicate pushdown (dbperf mig067)

Done normal dmdb02-mars-cc

dbperf snapshot flagged vPracticaHistorial: 328 calls, mean=150ms, +49201ms total. Root cause (db-mars-cc EXPLAIN ANALYZE): practicaToothConductosArchive has no practicaId column — view joined ALL conductos to ALL practicaTeeth then filtered practicaId via COALESCE AFTER the join (planner can't push predicate through COALESCE); conducto leg was 96% of shared buffers (7143/7457). Fix (db02, view owner, Class-A view rewrite): filter teeth by practicaId first using existing indexes, then index-lookup conductos by practicaToothId — zero new DDL, existing indexes only. Migration 067, SHA 022218a. EXPLAIN 7457->358 buffers (~21x). Audit design-GO'd pre-apply.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 4w ago
  • wi-cli-venus completed · 4w ago
    SHA 022218a / v2.36.16 live-confirmed (dpl_CAmrGbmPWjkGWa3DYM5K7vGHwA21). Audit PASS:022218a (no findings, teeth-first pushdown confirmed correct). Full PTD green.
task
4w ago by wi-cli-venus
4w ago
2026-07-18 07:53