mirror of
https://github.com/jlengrand/bugsink.git
synced 2026-03-09 23:51:20 +00:00
a2e1caabd1
i.e. the code in check_for_thresholds (when the `qs` filters per project)
On SQLite the effect is like so, from:
EXPLAIN QUERY PLAN SELECT COUNT(*) AS "__count" FROM "events_event" WHERE ("events_event"."project_id" = 1 AND "events_event"."digested_at" >= '2025-12-07 15:12:24.479666');
QUERY PLAN
`--SEARCH events_event USING COVERING INDEX events_even_project_ac6fc7_idx (project_id=?)
to
EXPLAIN QUERY PLAN SELECT COUNT(*) AS "__count" FROM "events_event" WHERE ("events_event"."project_id" = 1 AND "events_event"."digested_at" >= '2025-12-07 15:12:24.479666');
QUERY PLAN
`--SEARCH events_event USING COVERING INDEX events_even_project_625413_idx (project_id=? AND digested_at>?)