MARS-131 Mars DB hygiene (no IO risk, found in 06-15 Disk-IO self-check): (1) VACUUM ANALYZE teacherComisionMemberships (65d stale, 19.7% dead); (2) lower autovacuum_vacuum_scale_factor on notifications (high churn); (3) drop unused idx_st_createdbyuserid on supportTickets (0 scans, 13 rows); (4) index users.comisionId when query plans warrant. All reversible, audit pre-apply DDL review.

MARS-131 · mars

Mars DB hygiene (no IO risk, found in 06-15 Disk-IO self-check): (1) VACUUM ANALYZE teacherComisionMemberships (65d stale, 19.7% dead); (2) lower autovacuum_vacuum_scale_factor on notifications (high churn); (3) drop unused idx_st_createdbyuserid on supportTickets (0 scans, 13 rows); (4) index users.comisionId when query plans warrant. All reversible, audit pre-apply DDL review.

No sub-items.

No questions.

2026-06-15T16:12:22.560Z · created · wi-cli-venus
2026-06-16T02:37:52.468Z · commented · wi-cli-venus

DB-health sweep (2026-06-15, bs-mqg1357zx6m) surfaced 2 more hygiene items for this WI's db lane: (A) userRoles last autovacuum 2026-04-02 (75d stale, 13.3% dead, 80/104 toward threshold) -> manual VACUUM ANALYZE "userRoles" now is harmless; consider lowering scale_factor like the notifications item. (C) prune-notifications cron DELETE does a full seq-scan (WHERE readAt IS NOT NULL AND readAt < now()-30d), 637ms mean, grows with volume -> partial index on (readAt) WHERE readAt IS NOT NULL. Both low-pri, audit pre-apply DDL review as already scoped here.