Skip to content

Events default scope results in a slow query

SELECT  "events".* FROM "events" WHERE ("events"."author_id" IS NOT NULL) AND "events"."project_id" IN (1593931, 1566825, 1419274, 1408767, 1216192, 1184961, 1180659, 1138976, 1093005, 904501, 540272, 485032, 479202, 479186, 445969, 424918, 414874, 403262, 352376, 352346, 338174, 332903, 326157, 303716, 272876, 269537, 242337, 233241, 233229, 233189, 222643, 221033, 215163, 215162, 215161, 215160, 213416, 212316, 212249)  ORDER BY "events"."id" DESC LIMIT 20 OFFSET 0;

Mind the order by.

cc/ @yorickpeterse @stanhu