PLUTO-139 ·
plutoDB-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
Questions
No questions.