Freegle / Iznik / 21191

71%

Build Type

push

circleci

Committed by web-flow

Commit Message

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>

Coverage Stats

10246 of 11718 branches covered (87.44%)

Branch coverage included in aggregate %.

2 of 2 new or added lines in 1 file covered. (100.0%)

1331 existing lines in 41 files now uncovered.

117641 of 167435 relevant lines covered (70.26%)

35.49 hits per line