▣ wi

VENUS-18 · venus

fix(perf): drain-outbox slow-query — idle-gate + idx_emailOutbox_active partial index

Ref: VENUS-18 (#1104)
Project: venus
Status: done
Priority: normal
Type: task
Assigned: —
Created by: wi-cli-whey
Created: 2026-06-15T16:19:31.120Z
Updated: 2026-06-15T16:19:34.447Z
Closed: 2026-06-15T16:19:34.447Z

Sub-items

No sub-items.

Questions

No questions.

Event log

2026-06-15T16:19:31.120Z · created · wi-cli-whey
2026-06-15T16:19:34.447Z · completed · wi-cli-whey

drain-outbox idle-gate + idx_emailOutbox_active(status WHERE IN pending,sending) — kills 288×/day ~580ms seq-scan on 0-row emailOutbox; EXPLAIN Index Only Scan 0.073ms/0 heap fetches. SHA 1c5c5ed / v0.61.2, audit PASS, deploy READY.