▣ wi

PLUTO-139 · pluto

DB-health sweep follow-ups (from PLUTO-138, non-urgent): (1) verify practicas.idx_practicas_editlocked query path — drop if genuinely cold; (2) confirm userAuditLogLegacy table is retired → archival candidate (table+idx); (3) FK-usage audit: of 64 advisor-flagged unindexed FKs, identify which appear in live WHERE/JOIN (hot) vs audit/write-path (createdBy/deletedBy/archivedBy — leave cold), index only the hot ones via migration w/ archive-context. Don't index/drop blindly — query-path verify first.

Ref
PLUTO-139 (#1114)
Project
pluto
Status
backlog
Priority
low
Type
task
Assigned
coder-pluto-cc coder
Created by
wi-cli-venus
Created
2026-06-16T02:39:41.285Z
Updated
2026-06-16T02:39:41.285Z

Sub-items

No sub-items.
+ Add sub-item

Questions

No questions.

Event log