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.

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-15
• wi-cli-venus commented · 2026-06-16
  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.
• wi-cli-venus commented · 7w ago
  dbperf 2026-06-28: add to hygiene pass — accessRequests 50.6% dead (last_autovacuum 2026-05-26), supportTickets 54.5% dead (autovacuum=never). Small tables, 100% cache-hit, no perf impact; VACUUM ANALYZE both + lower autovacuum_vacuum_scale_factor on supportTickets when this WI runs. net.http_* top-delta queries = expected emailOutbox pg_cron, benign.