Freegle / Iznik / 21191 / 21191

71%

master: 71%

push

circleci

perf(emailtracking): FORCE INDEX(sent_at) on email stats timeseries/bytype (#744)

The ModTools outgoing-mail stats endpoints (/modtools/email/stats/timeseries and
.../bytype) time out at 50s (504). email_tracking is ~6.65M rows and the
optimiser full-scans it for these date-range aggregations instead of using the
sent_at index — measured against the live DB, forcing the index drops the
13-day window from a 50s timeout to ~17s (1 day: 1.3s, 7 days: 9s), matching the
fix already on DigestClickPositions.

Immediate relief that takes effect on apiv2 redeploy; complements the permanent
fix in the email_tracking 30-day purge (separate PR), which shrinks the table so
these scans become individually fast.

(stats/ runs ~7 sequential email_tracking scans, so the hint can't get it under
the timeout on the current table — it's handled by the purge.)

Co-authored-by: Claude Opus 4.8 <noreply@anthropic.com>

10246 of 11718 branches covered (87.44%)

Branch coverage included in aggregate %.

67390 of 100582 relevant lines covered (67.0%)

32.75 hits per line