24124
72%
master: 72%

Ran 01 Jul 2026 04:28AM UTC

Files 471

Run time 21s

Badge

Embed ▾

Committed 01 Jul 2026 04:04AM UTC coverage: 68.292% (-0.002%) from 68.294%

Job # 24124

Build Type

push

circleci

Committed by

invalid-email-address

Commit Message

perf(rippling-stats): restore index use on the reply/mean/taken KPIs

The first-ripple anchor put COALESCE(rip.first_ripple, mg.arrival) in the WHERE,
which made the messages_groups arrival filter non-sargable — a ~4M-row scan (~20s).
Filter on mg.arrival directly (indexed) instead; the day/window/cohort still key on
COALESCE(first_ripple, appearance), so dating/classification are unchanged. Verified
0 rippled posts are dropped by the appearance-window filter (a post's appearance is
always within the window that contains its first ripple).

Also bound the first-ripple derived table by arrival (indexed) — messages_groups has
no index on rippled_in, so an unbounded MIN-per-msgid scanned ~8M rows (~15s); all
rippled rows are recent and any <=90-day window is covered, so this is ~0.7s. Net:
~20s -> ~5s.

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_014aXkxBPEiPSJBaRMjz7opk

Coverage Stats

25817 of 37804 relevant lines covered (68.29%)

17.67 hits per line

Freegle / Iznik / 24124 / 24124
72%
master: 72%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job laravel - 24124

Freegle / Iznik / 24124 / 24124 72% master: 72%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job laravel - 24124

Freegle / Iznik / 24124 / 24124
72%
master: 72%

README BADGES
x