Lazily load issues/merge requests/participants in the milestone page
Problems
All the issues in the pipeline page are loaded at once. Although we already have a limit of 3000 issues (#39453 (closed) and !27361 (merged)), this limit is still too high IMO. For some crowded projects (https://gitlab.com/groups/gitlab-org/-/milestones/14 or https://gitlab.com/groups/gitlab-org/-/milestones/51), it takes dozen of seconds to minutes to fully load the page. This page includes three steps:
- Load the page backbone
- Load the charts (a graphql ajax call)
- Load the issue list (a XHR call to https://gitlab.com/groups/gitlab-org/-/milestones/51/issues.json?show_project_name=true)
- Or the merge request lists (a XHR call to https://gitlab.com/groups/gitlab-org/-/milestones/51/merge_requests.json?show_project_name=true)
- Or the participant list (a XHR call to https://gitlab.com/groups/gitlab-org/-/milestones/51/participants.json)
- Or the label list (a XHR call to https://gitlab.com/groups/gitlab-org/-/milestones/51/labels.json)
All XHR calls in the page are facing the same problem.
From the user perspective, the page is overwhelming, slow, and laggy. On my work laptop (Macbook Pro, i9, 32GB of Ram), it takes 8 seconds for an initial load (without any information). The browser (Chrome) freezes for a while after the detailed issues are loaded. When I scroll the page, the FPS drops significantly. When I switch to another tab and return, the page freezes again. I could say it's nearly impossible to use.
From the frontend perspective, although the issue list is loaded via XHR, the response is just a object containing a single big HTML string:
The total size of the response is around 11MB (1700 issues) to 30MB (3000 issues). There are several issues with this:
- The payload size is huge, meaning more time waiting for data transferring. Good luck when you are on a slow connection.
- It takes time to parse the string, apply to the page, and re-render the page. Let's look at the detailed performance analytics of the page:
The rendering and painting time alone are 12 seconds, which is huge. In addition, one notable detail is the JS heap. It peaks to 100MB, just for a single tab.
From the backend perspective, rendering and serializing such huge amount of data are costly. In fact, Groups::MilestonesController#issues
appears in one of the top endpoints consuming CPU. It costs both CPU time, and memory.
Plus, this is the source of some enormous SQL queries:
SELECT issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" WHERE "issues"."id" IN (SELECT "id" FROM (SELECT issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 7815314 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 7815314 AND issue_id = issues.id) OR EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 7815314 AND (project_authorizations.project_id = issues.project_id) AND (project_authorizations.access_level >= 20))))) AND "projects"."namespace_id" IN (SELECT "namespaces"."id" FROM (SELECT "namespaces".* FROM "namespaces" INNER JOIN (WITH RECURSIVE "base_and_descendants" AS ((SELECT 1 AS depth, ARRAY[namespaces.id] AS tree_path, false AS tree_cycle, "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970) UNION (SELECT ("base_and_descendants"."depth" + 1), tree_path || "namespaces".id, "namespaces".id = ANY(tree_path), "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" = 'Group' AND "namespaces"."parent_id" = "base_and_descendants"."id" AND "base_and_descendants"."tree_cycle" = FALSE)) SELECT DISTINCT "id", "depth" FROM "base_and_descendants" AS "namespaces") namespaces_join_table on namespaces_join_table.id = namespaces.id WHERE "namespaces"."type" = 'Group' ORDER BY "namespaces_join_table"."depth" ASC) AS "namespaces" WHERE "namespaces"."type" = 'Group') AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 7815314 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IS NULL OR "project_features"."issues_access_level" IN (20,30) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 7815314 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND "issues"."milestone_id" = 490705 GROUP BY "issues"."id" ORDER BY highest_priority ASC NULLS LAST, "issues"."id" DESC LIMIT 3000) subquery) AND ("issues"."state_id" IN (1)) AND (NOT EXISTS (SELECT TRUE FROM issue_assignees WHERE issue_id = issues.id)) GROUP BY "issues"."id" ORDER BY highest_priority ASC NULLS LAST, "issues"."id" DESC
SELECT issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" WHERE "issues"."id" IN (SELECT "id" FROM (SELECT issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 7815314 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 7815314 AND issue_id = issues.id) OR EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 7815314 AND (project_authorizations.project_id = issues.project_id) AND (project_authorizations.access_level >= 20))))) AND "projects"."namespace_id" IN (SELECT "namespaces"."id" FROM (SELECT "namespaces".* FROM "namespaces" INNER JOIN (WITH RECURSIVE "base_and_descendants" AS ((SELECT 1 AS depth, ARRAY[namespaces.id] AS tree_path, false AS tree_cycle, "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970) UNION (SELECT ("base_and_descendants"."depth" + 1), tree_path || "namespaces".id, "namespaces".id = ANY(tree_path), "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" = 'Group' AND "namespaces"."parent_id" = "base_and_descendants"."id" AND "base_and_descendants"."tree_cycle" = FALSE)) SELECT DISTINCT "id", "depth" FROM "base_and_descendants" AS "namespaces") namespaces_join_table on namespaces_join_table.id = namespaces.id WHERE "namespaces"."type" = 'Group' ORDER BY "namespaces_join_table"."depth" ASC) AS "namespaces" WHERE "namespaces"."type" = 'Group') AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 7815314 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IS NULL OR "project_features"."issues_access_level" IN (20,30) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 7815314 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND "issues"."milestone_id" = 490705 GROUP BY "issues"."id" ORDER BY highest_priority ASC NULLS LAST, "issues"."id" DESC LIMIT 3000) subquery) AND ("issues"."state_id" IN (2)) GROUP BY "issues"."id" ORDER BY highest_priority ASC NULLS LAST, "issues"."id" DESC
SELECT "label_links".* FROM "label_links" WHERE "label_links"."target_type" = 'Issue' AND "label_links"."target_id" IN (79700941, 79403655, 77951070, 77198099, 77150786, 72023404, 71533592, 71347559, 71244943, 70827613, 70131551, 69494969, 69494722, 69467122, 69303972, 69218807, 69218782, 69218737, 69016008, 63858960, 55220378, 35745604, 35122809, 35049337, 33752955, 31257752, 31245262, 31046691, 30251974, 29838040, 29476633, 27700259, 27463445, 26283483, 26223918, 26169995, 25698505, 25390790, 25125528, 21962240, 20451792, 9984206, 80246204, 77599139, 74631670, 74493492, 74492151, 73507330, 73244571, 72527996, 72322403, 71671404, 71529801, 71505825, 71244025, 71202266, 71115513, 70968671, 70382928, 70328447, 70003334, 68992911, 68975930, 68973319, 68820947, 58660263, 58660198, 54294492, 53099754, 53006945, 51719780, 46789278, 43923021, 43870285, 43677927, 38604944, 38198604, 35967023, 35447090, 35438568, 35430749, 35428401, 35428302, 35303807, 35298538, 35289367, 35100887, 35062871, 34817245, 34797584, 34790258, 34733263, 34560236, 34273039, 34266922, 34170191, 33846945, 33427776, 33267414, 33097430, 33041743, 33036474, 33010725, 33010086, 32888676, 32799973, 32364024, 32351276, 31997306, 31366505, 30939853, 30649724, 30336433, 29980310, 29635191, 29488673, 29371040, 28410820, 28305727, 28016506, 27730440, 27461963, 27041034, 26994542, 26969828, 25756985, 25583530, 25396224, 25051373, 24727411, 24700552, 24695876, 24691722, 24686871, 24661940, 24656702, 24654756, 24653325, 24647379, 24644960, 24636785, 24124572, 23450241, 23063069, 22905172, 22536225, 22398706, 22153276, 18848219, 18673560, 18001444, 16035203, 10965096, 6136580, 5848672, 79954113, 76865164, 76424258, 76303203, 76037092, 75765676, 75700855, 74076439, 73903848, 72656144, 72357589, 72271020, 72002819, 71904974, 71867676, 71570799, 70665737, 70662137, 70644859, 70640455, 70625886, 70567118, 70390626, 70301354, 70220061, 70220059, 70220055, 70146244, 70038140, 70010166, 69750224, 69702326, 69466368, 69412469, 69411731, 69239863, 69223876, 69168937, 69158918, 68939001, 68877335, 68241878, 54317218, 53918714, 53800552, 53105466, 50111225, 50061459, 50058022, 50054948, 49300774, 47538508, 47062857, 47056257, 46761605, 44917752, 44147649, 42963412, 35472437, 35355149, 35135257, 35054413, 34993997, 34934581, 34903765, 34842269, 34775392, 34737179, 34726329, 34711187, 34610796, 34595711, 34421333, 34289084, 34179495, 34148908, 34143935, 33867723, 33867462, 33857217, 33724467, 33711566, 33680217, 33670507, 33576508, 33567404, 33491510, 33485025, 33361396, 33334430, 33285769, 33283703, 33006402, 32791340, 32758522, 32745231, 32708455, 32631137, 32346493, 32332116, 32250296, 32074205, 31808712, 31412064, 31062174, 31035799, 30898869, 30885606, 30717455, 30673030, 30641200, 30586409, 30401123, 29916701, 29890937, 29604421, 29524454, 29363904, 29361237, 29340616, 29232415, 29190195, 29053474, 28428165, 28313833, 28201222, 28179494, 28105029, 27953485, 27908751, 27904757, 27843256, 27066350, 27056903, 27053254, 27044954, 26987078, 26974714, 26965459, 26832809, 26757497, 26624196, 26519137, 26494587, 26494501, 26454230, 26437638, 26039180, 25993240, 25860736, 25728861, 25686064, 25390995, 25369107, 25297591, 25134528, 24797783, 24727326, 24727282, 24708214, 24702077, 24701810, 24701303, 24700353, 24700047, 24699647, 24699540, 24699400, 24698479, 24698039, 24697704, 24697493, 24696956, 24696751, 24696636, 24696477, 24696417, 24696375, 24695865, 24695763, 24695491, 24695001, 24694243, 24694234, 24693867, 24693573, 24692668, 24692389, 24692140, 24692131, 24691934, 24691601, 24691387, 24691254, 24690849, 24690718, 24690622, 24690614, 24690110, 24689886, 24689564, 24689561, 24689436, 24689106, 24689007, 24688527, 24688164, 24688001, 24687977, 24687716, 24687690, 24687669, 24687452, 24687449, 24687408, 24687288, 24687164, 24686892, 24686745, 24686657, 24686282, 24686247, 24686103, 24685398, 24685296, 24685241, 24684917, 24684895, 24684706, 24684025, 24683986, 24683919, 24683815, 24683785, 24683302, 24683241, 24683225, 24683101, 24683054, 24682889, 24682794, 24682793, 24682494, 24682491, 24682428, 24682418, 24681882, 24681735, 24666237, 24666043, 24665924, 24665722, 24665686, 24665503, 24665271, 24665178, 24665079, 24664255, 24663956, 24663405, 24663124, 24663026, 24662776, 24662602, 24662275, 24662173, 24662107, 24662019, 24661763, 24661364, 24661073, 24660965, 24660429, 24660423, 24660420, 24660108, 24659907, 24659634, 24659489, 24658653, 24658562, 24658516, 24658054, 24657817, 24657790, 24657667, 24657244, 24656793, 24656778, 24656767, 24656735, 24656673, 24656625, 24656512, 24656506, 24656444, 24656439, 24656438, 24656437, 24656120, 24656016, 24655968, 24655750, 24655664, 24655634, 24655631, 24655610, 24655583, 24655579, 24655459, 24655359, 24655352, 24653813, 24653787, 24653721, 24653642, 24653215, 24652741, 24652711, 24652659, 24652644, 24652599, 24651864, 24651791, 24651726, 24651449, 24651426, 24651381, 24651264, 24651225, 24651206, 24650761, 24650525, 24650417, 24650378, 24650280, 24649849, 24648970, 24648827, 24648822, 24648480, 24648396, 24648382, 24647387, 24647184, 24646368, 24645957, 24645921, 24644884, 24644798, 24644760, 24644499, 24644291, 24644230, 24643898, 24642254, 24642155, 24642086, 24641452, 24641365, 24639580, 24639538, 24639491, 24639456, 24639373, 24638992, 24638540, 24638356, 24638350, 24638342, 24638216, 24638215, 24638170, 24637038, 24637020, 24637016, 24330310, 24330300, 24329998, 24329729, 24329702, 24329521, 24329238, 24209880, 21774008, 20721710, 19454931, 19264017, 18983681, 13939420, 9337715, 7086586, 5403555, 4135874, 2327031, 77800537, 77123400, 72890105, 43038309, 35309414, 35144485, 33281506, 32662092, 31909913, 31637787, 30251351, 30106405, 28775175, 27410383, 27051647, 26542566, 24697410, 24692887, 24692477, 24687732, 24686058, 24685815, 24684588, 24666316, 24663207, 24662077, 24654184, 24653368, 24651510, 24650091, 24649660, 24641770, 24638775, 24638644, 24330210, 24330006, 20503721, 10016771, 7598463, 33934666, 30938014, 23487553, 22728731, 21228756, 19715427, 9970177, 9488657, 9422355, 7773437, 34598119, 30046587, 27844275, 24689768, 23087997, 16385280, 14042893, 13220256, 10271872, 10123430, 9984676, 7765687, 7438514, 7323690, 78246815, 77823169, 76359640, 74937667, 72725765, 72222126, 72093222, 71653421, 71515683, 71195593, 70786870, 70703430, 70657536, 70330915, 70011842, 70005345, 69840241, 69400101, 69362453, 68916706, 54029109, 50084076, 50026137, 48556799, 34015418, 33109108, 31565717, 31477015, 30382163, 29834717, 29674059, 29222074, 28879544, 27821324, 27133815, 26749307, 26482437, 26260022, 26250885, 25941694, 25941597, 25227073, 24911544, 24744165, 24685864, 24662526, 24655592, 24288079, 23971806, 23760905, 23589810, 23418432, 23414752, 23413819, 23094265, 22191729, 21847871, 21672576, 21666942, 21539329, 21350831, 21314671, 20691714, 20283427, 19962943, 19874790, 19858741, 19852222, 19840674, 18141922, 17810233, 17606647, 17346396, 17254040, 17186172, 16886293, 16249646, 16165352, 15695981, 15587746, 15241333, 14458772, 14424746, 14312886, 13878560, 13736610, 13458062, 13448660, 13210711, 13130122, 12557465, 12196497, 11769335, 11027062, 10987375, 10969080, 10864138, 10646475, 10408214, 10219326, 9960836, 9484742, 9420619, 9403482, 9348599, 8658731, 8498838, 8444190, 8154787, 7838675, 7790836, 7708882, 7382427, 7143156, 6969665, 6948895, 6865187, 6767429, 6765882, 6617453, 6615786, 6467989, 6247168, 6227733, 6141386, 5990953, 5648071, 5569515, 5460563, 5411901, 5205953, 5205922, 5180692, 4986172, 4971097, 4927121, 4747432, 4738608, 4641251, 4568556, 4296634, 4010084, 3689359, 3646512, 3567944, 3467179, 3162331, 3115950, 2809114, 2665844, 2657934, 2549792, 2482398, 2405585, 2364926, 1498046, 1365735, 1313210, 1284144, 1154484, 1107946, 269536, 76990224, 70239448, 34326610, 33925327, 9621910, 7324004, 6946233, 6896218, 6489859, 75662888, 73969513, 73872737, 73803014, 73008326, 71656040, 70726418, 70705866, 70705295, 70247370, 70103578, 70086176, 69894806, 69809429, 69769846, 69539611, 68935759, 68844863, 54177095, 54114935, 52535134, 50117197, 47715293, 35964468, 35447394, 35433547, 35206629, 35141778, 34987224, 34907651, 34747671, 34492523, 34348516, 34319605, 34319408, 34247148, 34155499, 33976427, 33972175, 33756044, 33755753, 33335009, 33262675, 33117918, 32692494, 32444673, 32016979, 31361689, 31021136, 30939412, 30713531, 30573949, 29970127, 29924032, 29876655, 29868813, 29708506, 29687052, 29435393, 28896426, 28757273, 28023710, 27977745, 27665942, 27581938, 27482529, 27478936, 27474749, 27256499, 27067176, 26506189, 26380776, 26273181, 26232201, 26019940, 25550599, 24925573, 24727503, 24727344, 24708220, 24699246, 24698911, 24698768, 24698366, 24698346, 24697005, 24696558, 24696506, 24695928, 24695694, 24695674, 24694996, 24693314, 24692431, 24691596, 24691593, 24691194, 24688578, 24687101, 24686718, 24685715, 24685698, 24685314, 24684142, 24665088, 24659514, 24656999, 24656789, 24652716, 24652476, 24651321, 24649753, 24647789, 24646270, 24642073, 24638374, 24330073, 15378989, 15244503, 5466817, 80563205, 77250424, 75508049, 72417728, 72027858, 71701880, 71377254, 71265680, 70436704, 70433649, 69989875, 69929091, 68828038, 68828030, 68828019, 64036248, 57507458, 55263815, 50166819, 49909423, 44822848, 44788618, 42944466, 36550306, 33939629, 33498120, 32556697, 32365477, 31382180, 26255262, 77526967, 77435401, 77079178, 76532561, 76057925, 75920548, 75765290, 75357396, 74981484, 74717421, 74483316, 74446796, 74201715, 72980288, 72321424, 71816075, 71369223, 71350378, 70807554, 70524418, 70423120, 70359205, 70322505, 69959906, 69821680, 69787734, 69647259, 69638008, 68962871, 68844585, 68222579, 63252746, 62583890, 53814123, 50146712, 50126466, 34539201, 33277825, 33275680, 31894772, 31618866, 30723423, 29916949, 29796652, 29686639, 27779902, 27472970, 26737643, 26243035, 26174440, 24935555, 24935244, 24918725, 24867443, 24738707, 24708254, 24701584, 24692937, 24688907, 24688443, 24682964, 24665532, 24637307, 24495936, 24428450, 23751010, 23516900, 23397648, 23303165, 23079626, 23078842, 17389912, 12783182, 7649691, 81092591, 80225083, 80099866, 79911302, 79733384, 79686718, 79627834, 79556913, 79519391, 79398873, 79366546, 79366335, 79342024, 79215729, 78709503, 78558063, 78477052, 78421432, 78370336, 78218907, 78092023, 78006549, 77768494, 77717369, 77686738, 77651413, 77571094, 77468595, 77384468, 76943111, 76905166, 76836496, 76827323, 76605098, 76563416, 76198426, 76168485, 76168321, 76160326, 76073662, 76010672, 75965826, 75921468, 75857896, 75825551, 75822625, 75659587, 75629456, 75592367, 75564016, 75548940, 75517405, 75485983, 74915690, 74901315, 74893711, 74870663, 74834780, 74693155, 74678052, 74361910, 74297969, 74284514, 74283758, 74277685, 74214174, 74212957, 74151326, 73961145, 73834706, 73777848, 73735572, 73634712, 73624655, 73602495, 73600013, 73534592, 73528207, 73412706, 73398000, 73271617, 73264010, 73263996, 73263976, 73263956, 73263942, 73263930, 73263926, 73263894, 73251788, 73244957, 73173687, 73096403, 73079575, 73013020, 72962276, 72728768, 72672668, 72614274, 72568064, 72117514, 72056846, 72004428, 71826963, 71619042, 71612005, 71528705, 71364073, 71049654, 70875316, 70714855, 70710686, 70676285, 70594739, 70512179, 70321672, 70304221, 70241300, 70146534, 70130555, 70066295, 70005868, 69981146, 69968300, 69957969, 69947062, 69895963, 69804797, 69779481, 69689766, 69648397, 69625424, 69521489, 69515893, 69483199, 69476316, 68895717, 68107950, 61662332, 61647771, 59618351, 57401334, 54079023, 54050984, 54005422, 53709294, 52444096, 51572260, 49919246, 43855816, 37987009, 35519482, 35387343, 35320668, 35203147, 34912204, 34727624, 34679659, 34572441, 34572318, 34242397, 34142801, 33954746, 33828409, 33755430, 33658198, 33627863, 33401113, 33317605, 33004214, 32967475, 32953782, 32834337, 32738474, 32514867, 32399439, 32367118, 32178608, 32164748, 32095925, 31912912, 31880129, 31837675, 31828465, 31615415, 31572078, 31535124, 31535082, 31516246, 31513716, 31386539, 31370934, 31327755, 31320093, 31260401, 31258659, 30793275, 30690471, 30485607, 30019820, 29809907, 29784070, 29718961, 29594573, 29426436, 29280312, 29221820, 29001997, 28774509, 27987806, 27873348, 27861796, 27751837, 27736779, 27535569, 27463193, 27271193, 26957382, 26945087, 26855816, 26782937, 26565013, 26494598, 26249475, 26174763, 25969674, 25843410, 25547189, 25272747, 25047597, 24995114, 24961306, 24804135, 24708296, 24708292, 24701934, 24700911, 24700264, 24699825, 24699704, 24699207, 24697062, 24696748, 24695890, 24694634, 24694079, 24693911, 24693781, 24693730, 24693719, 24693365, 24693344, 24693339, 24689425, 24688614, 24688607, 24688121, 24687811, 24687375, 24687340, 24686396, 24684878, 24684641, 24684425, 24684415, 24684105, 24683379, 24683289, 24682589, 24682365, 24681954, 24681759, 24681713, 24681662, 24665797, 24665664, 24664078, 24663779, 24663629, 24662995, 24662982, 24662865, 24662795, 24662500, 24662344, 24661335, 24661060, 24657777, 24656834, 24654455, 24654343, 24654099, 24651894, 24651011, 24650277, 24649703, 24648871, 24648189, 24645155, 24643817, 24642146, 24641310, 24330104, 24329970, 24329888, 21648149, 20548863, 19924498, 19889676, 19749265, 19690054, 19346707, 19241000, 19170011, 18221260, 15846839, 15172805, 15091011, 15088933, 14515003, 13536298, 12783198, 12194496, 9702976, 6443438, 5444202, 3734547, 2692848, 2475921, 1063016, 81092676, 81045535, 80775242, 80771072, 80767687, 80749146, 80744948, 80696484, 80686433, 80676176, 80674046, 80671771, 80641450, 80573330, 80557893, 80551121, 80503820, 80500909, 80496692, 80357377, 80261878, 80245019, 80207332, 80189475, 80093449, 79994811, 79940690, 79892849, 79813081, 79811680, 79802746, 79787482, 79742386, 79713746, 79697498, 79630925, 79600772, 79592300, 79581684, 79551177, 79425177, 79385803, 79317888, 79287942, 79228151, 79219331, 79149714, 79124472, 79123762, 79123197, 79102849, 79078339, 79078074, 79066799, 79042518, 79030100, 79008287, 78989863, 78959846, 78947963, 78942830, 78931821, 78913614, 78861052, 78856462, 78791850, 78786791, 78758221, 78756178, 78725570, 78701877, 78664479, 78657671, 78627282, 78606792, 78510009, 78410432, 78333170, 78324398, 78320998, 78236250, 78218559, 78209693, 78187810, 78159506, 78035118, 77983631, 77931411, 77923406, 77898217, 77894450, 77844094, 77801212, 77774136, 77727368, 77708156, 77706668, 77648306, 77633987, 77631712, 77580868, 77575607, 77566187, 77507683, 77503207, 77483077, 77375246, 77373888, 77351706, 77174450, 77147344, 77143617, 77140140, 77111962, 77013525, 77002167, 76994442, 76945385, 76917316, 76905081, 76904884, 76855301, 76811804, 76805247, 76787234, 76783105, 76745928, 76711226, 76658733, 76619184, 76614430, 76469561, 76410688, 76404405, 76380667, 76320652, 76318651, 76201648, 76171417, 76151040, 76100517, 76080426, 76066990, 76045163, 76040687, 76039058, 76030951, 76023347, 75947249, 75826275, 75825478, 75788650, 75760187, 75756800, 75620883, 75610291, 75607129, 75537890, 75461808, 75425220, 75407669, 75395943, 75384151, 75382717, 75374129, 75021581, 75001052, 74976653, 74919063, 74916719, 74866863, 74848762, 74832460, 74782413, 74758503, 74750346, 74741651, 74687639, 74686299, 74668953, 74595150, 74594470, 74582139, 74529160, 74516318, 74513586, 74513275, 74505659, 74438718, 74423662, 74407888, 74373865, 74372255, 74320496, 74270054, 74199448, 74199297, 74190655, 74160578, 74160449, 74152887, 74114958, 74109391, 73993604, 73977575, 73976860, 73976672, 73968249, 73934296, 73918472, 73910686, 73909702, 73876436, 73833387, 73818075, 73815396, 73762381, 73720686, 73687207, 73655683, 73638182, 73637070, 73632071, 73621846, 73564790, 73510108, 73473249, 73456708, 73449871, 73439995, 73436455, 73409611, 73394486, 73376835, 73372782, 73336180, 73272053, 73249447, 73234121, 73173502, 73169966, 73147516, 73076783, 73063291, 73033682, 72943101, 72900159, 72854565, 72823750, 72800694, 72707843, 72701682, 72691063, 72607852, 72572581, 72509930, 72467237, 72462392, 72462147, 72414616, 72374918, 72372623, 72356207, 72351712, 72349160, 72311589, 72305194, 72299699, 72265296, 72258825, 72236867, 72233375, 72231033, 72209202, 72187750, 72184536, 72151622, 72149367, 72112709, 72097530, 72097308, 72071168, 72068715, 72040810, 72030788, 72020842, 72014400, 71974651, 71960828, 71956425, 71937816, 71886988, 71881583, 71864353, 71761650, 71710598, 71710562, 71706933, 71691226, 71690006, 71640659, 71633534, 71625669, 71611357, 71585808, 71584569, 71581674, 71565868, 71560201, 71452837, 71379588, 71370098, 71365060, 71357095, 71328216, 71323424, 71323333, 71312332, 71310433, 71305031, 71262863, 71250380, 71223108, 71219471, 71219460, 71219433, 71190076, 71186270, 71043715, 71043568, 71040604, 71040210, 71030914, 71025050, 71013965, 71012016, 70969644, 70937421, 70904453, 70903279, 70903048, 70821716, 70719663, 70718210, 70711751, 70711150, 70697318, 70690394, 70689766, 70651510, 70597609, 70560160, 70551020, 70463433, 70387814, 70383118, 70381880, 70369980, 70328632, 70319398, 70316097, 70312109, 70280395, 70272122, 70271912, 70270803, 70265362, 70251575, 70239857, 70235515, 70229573, 70227184, 70206598, 70202257, 70125738, 70089008, 70066834, 70066436, 70062892, 70049720, 70037707, 70037454, 69999607, 69978205, 69975331, 69966323, 69964847, 69961941, 69897368, 69850156, 69841683, 69837989, 69808072, 69800734, 69800677, 69790940, 69778298, 69772632, 69752096, 69751762, 69724458, 69722179, 69699456, 69698985, 69686173, 69670355, 69658409, 69641008, 69632650, 69611896, 69552435, 69551227, 69516614, 69504093, 69495499, 69483813, 69475797, 69475001, 69382157, 69374276, 69372344, 69366693, 69348849, 69313313, 69305631, 69302978, 69257695, 69176198, 69028103, 68973339, 68962160, 68942308, 68941386, 68939109, 68912029, 68910044, 68882412, 68873392, 68790362, 68433977, 68286176, 67757568, 64204873, 63593209, 62608991, 61720389, 61197030, 61088309, 58878346, 57194016, 57175261, 56957896, 56791871, 55882923, 55752965, 55240812, 55007115, 54669206, 54351628, 54298151, 54293075, 53977022, 53974919, 53965114, 53953214, 53942201, 53891647, 53887202, 53867709, 53811464, 53811427, 53810709, 53802459, 53245471, 53085519, 52977835, 52279313, 52101561, 51802660, 50765257, 50124064, 50094322, 50052874, 50052775, 50039280, 50039072, 50038756, 50013388, 50003246, 49951786, 49921570, 49915047, 49895363, 49887661, 49886734, 49865280, 49852492, 49848158, 49373315, 49188556, 48462938, 48154277, 47699896, 46687191, 46613542, 46577275, 46504031, 45438625, 45414971, 44201034, 44096139, 43609251, 43523933, 42998946, 42971310, 42960635, 42954211, 42952964, 40854251, 40781358, 40759228, 40433406, 40382546, 39694591, 38234433, 37703960, 36135066, 35941902, 35881587, 35723665, 35539210, 35518313, 35517631, 35495589, 35487456, 35464132, 35457413, 35422400, 35406206, 35401279, 35389520, 35370961, 35320706, 35307905, 35298631, 35289616, 35242218, 35241702, 35206406, 35168747, 35165318, 35133672, 35130171, 35120120, 35050057, 35030904, 35026389, 35016405, 35016137, 35004625, 34976150, 34895902, 34889770, 34880868, 34858969, 34858840, 34857381, 34856026, 34846790, 34845421, 34782656, 34772648, 34731523, 34725613, 34715857, 34686598, 34658668, 34612891, 34597667, 34568252, 34564965, 34563075, 34535856, 34514646, 34503576, 34497480, 34474638, 34471488, 34467329, 34405561, 34391137, 34381143, 34348858, 34328130, 34315263, 34285407, 34282339, 34191877, 34185823, 34169401, 34167056, 34165906, 34150626, 34138136, 34034989, 34015259, 34009198, 34005176, 33991960, 33966494, 33940917, 33917870, 33905168, 33903017, 33894120, 33889938, 33877459, 33874247, 33867974, 33856256, 33855781, 33852415, 33841037, 33753833, 33744748, 33731121, 33730598, 33729477, 33727921, 33724033, 33694950, 33692840, 33664914, 33658248, 33658244, 33658233, 33658231, 33658209, 33658203, 33657856, 33627142, 33622471, 33620930, 33601041, 33600469, 33600466, 33600465, 33600424, 33600419, 33597653, 33587588, 33582004, 33570621, 33569784, 33566367, 33561643, 33521127, 33510338, 33505279, 33498361, 33466667, 33420858, 33405379, 33395927, 33367958, 33353153, 33344093, 33342859, 33337460, 33315853, 33291967, 33282901, 33264848, 33228522, 33227022, 33184606, 33154040, 33149851, 33128896, 33117267, 33097292, 33094492, 33087209, 33077388, 33063967, 33049560, 33017539, 33015477, 32973914, 32968614, 32966944, 32961553, 32959260, 32952153, 32939267, 32913309, 32884739, 32875801, 32826434, 32826257, 32779043, 32768029, 32763778, 32757370, 32756917, 32753357, 32740462, 32725691, 32713546, 32710754, 32705766, 32687374, 32684331, 32683766, 32653167, 32644860, 32641879, 32641493, 32611986, 32574847, 32566125, 32541935, 32486945, 32469332, 32444415, 32400527, 32386569, 32376449, 32353634, 32343444, 32341418, 32260905, 32250750, 32182816, 32171949, 32152971, 32147463, 32136975, 32102186, 32076305, 32070687, 32024310, 32010690, 31932142, 31926191, 31915692, 31912403, 31907844, 31898310, 31880692, 31845964, 31834191, 31812087, 31778405, 31625279, 31613075, 31569237, 31535378, 31534321, 31533090, 31526658, 31506950, 31505033, 31497030, 31450781, 31432967, 31414568, 31397894, 31396981, 31392141, 31389799, 31354740, 31354250, 31344339, 31297927, 31272920, 31253927, 31198316, 31196342, 31193097, 31175029, 31139671, 31136143, 31131921, 31127171, 30977254, 30974546, 30970986, 30953946, 30947210, 30945254, 30925105, 30917691, 30913306, 30781869, 30746212, 30721188, 30667186, 30659891, 30658269, 30655333, 30652893, 30625370, 30614886, 30609601, 30593508, 30591540, 30533530, 30528593, 30515844, 30489904, 30478058, 30456492, 30442561, 30437436, 30433831, 30423406, 30362541, 30349275, 30325198, 30165401, 30102138, 30078402, 30051837, 30049131, 30048766, 30044277, 30032672, 30020880, 29984798, 29959036, 29822052, 29814791, 29773541, 29691431, 29680585, 29643674, 29640694, 29639880, 29639489, 29610012, 29609915, 29595038, 29554905, 29467684, 29451271, 29435371, 29418442, 29412379, 29401670, 29358145, 29323519, 29277837, 29201114, 29179468, 29033991, 29003487, 28968868, 28918130, 28916805, 28864791, 28847239, 28845896, 28817690, 28808307, 28754039, 28725342, 28655000, 28494009, 28422852, 28350372, 28345520, 28341465, 28339849, 28331963, 28326877, 28305413, 28297041, 28277146, 28170872, 28139460, 28045179, 27997033, 27954961, 27947398, 27945223, 27944512, 27944096, 27943252, 27942938, 27941780, 27938334, 27930091, 27916498, 27904039, 27865240, 27858543, 27851940, 27766495, 27730912, 27691622, 27670665, 27656855, 27583967, 27571865, 27563219, 27559334, 27556884, 27551440, 27528116, 27486007, 27480515, 27466381, 27465190, 27423752, 27413042, 27411637, 27276470, 27267477, 27266031, 27250027, 27246047, 27228736, 27222224, 27207958, 27183396, 27042822, 27020164, 27008937, 27008899, 27005572, 26996189, 26995913, 26955343, 26946000, 26945755, 26872119, 26866861, 26859721, 26829847, 26819183, 26759833, 26739390, 26655617, 26550684, 26504215, 26458512, 26366232, 26355722, 26340672, 26330215, 26327566, 26278400, 26241547, 26214100, 26174721, 26161876, 26108102, 26058100, 26029843, 26002283, 25952316, 25923778)
SELECT "label_links".* FROM "label_links" WHERE "label_links"."target_type" = 'Issue' AND "label_links"."target_id" IN (69218823, 68926049, 49888579, 35445674, 34455235, 34309977, 27161320, 24751258, 24727311, 24708223, 24442281, 15453573, 75038969, 73532698, 72796930, 70636597, 70132896, 58839200, 50103496, 46581327, 45385919, 35796557, 32837719, 32813714, 32675841, 32424056, 32126026, 31666767, 28898001, 28242691, 25712691, 25562366, 25043701, 24698445, 21153967, 19694270, 19693215, 17075092, 12082812, 74049625, 73321643, 72659386, 70640730, 69944068, 69547717, 69415821, 69159734, 54073038, 54072950, 53991904, 42956961, 34698608, 34281780, 34238787, 33728716, 33143151, 32878192, 32554029, 30373857, 29697714, 28985350, 27947055, 27945862, 27904378, 27894064, 27285628, 26558191, 26330162, 26144455, 25914051, 24708174, 24701586, 24696614, 24696143, 24694104, 24693407, 24690904, 24690710, 24690450, 24690392, 24689890, 24689714, 24688092, 24682381, 24665165, 24664419, 24663514, 24662336, 24660811, 24659859, 24657615, 24656926, 24653911, 24653680, 24652870, 24651284, 24650189, 24649738, 24644004, 24638689, 24638043, 24330019, 22614595, 20514723, 17152618, 3203702, 78019721, 32041495, 24692501, 24660598, 24651805, 30459383, 22683864, 14508374, 12717797, 12273268, 10546899, 10417234, 7473064, 6948925, 5962092, 5523358, 73798447, 71650450, 68961315, 35356647, 34588242, 30995935, 23648021, 23088636, 22338290, 22338280, 21486407, 16393161, 15669797, 13862760, 13572116, 13194665, 12580385, 11943207, 9962050, 9841357, 9607011, 9555874, 9481545, 8923002, 8024607, 8000805, 7847462, 6708469, 6586601, 6005159, 5577289, 4299804, 3523455, 2932591, 2740928, 801158, 469494, 12324410, 71710463, 70078373, 64452272, 32975917, 31241683, 28631316, 28316454, 27895488, 25929944, 25823423, 25684596, 24701256, 24698355, 24698103, 24697478, 24696412, 24693905, 24692539, 24683421, 24330361, 23023672, 71130111, 34579101, 32029314, 32029257, 29565454, 79286919, 77176773, 76173248, 72745645, 71308146, 69537047, 68867143, 53989226, 35202395, 35129936, 26176937, 25667861, 24763581, 24735421, 24701062, 24694096, 24689771, 24642246, 24534748, 24494297, 24491023, 24392285, 23303113, 22597927, 22554782, 22525346, 22518229, 22424881, 20432812, 13832788, 9722660, 80616287, 80062637, 79211066, 77883792, 77377981, 77041265, 76762357, 76567551, 76462694, 74328802, 73263817, 73257022, 73114108, 72978592, 72863138, 72789169, 72693679, 72111480, 72082578, 71219272, 70740230, 70677513, 70596891, 70388909, 70227506, 70109990, 69726085, 69552610, 69471421, 69468472, 69121794, 68945203, 53477160, 52204278, 44867504, 35323599, 35096755, 34819659, 34818886, 34374818, 34014541, 33856772, 33407168, 33261286, 32694211, 32345605, 31915451, 31915417, 31805509, 31564493, 31487648, 31266852, 31077869, 30786208, 30529415, 30443922, 30255918, 28991542, 28803406, 28020858, 27992353, 27238161, 26869432, 26833617, 26569973, 26494603, 26494280, 26242314, 26129576, 25549397, 25025762, 24722577, 24701615, 24700559, 24700155, 24699823, 24699765, 24699605, 24699354, 24698470, 24696355, 24696165, 24694690, 24694092, 24693897, 24693449, 24693448, 24693447, 24693434, 24693115, 24692966, 24691599, 24691246, 24688061, 24687839, 24687161, 24684475, 24683129, 24682862, 24682797, 24666055, 24665219, 24665198, 24664918, 24664773, 24664591, 24663975, 24663840, 24662230, 24649560, 24647930, 24635433, 24272558, 24040003, 23816599, 23478541, 23166109, 22921612, 22495089, 22096708, 21896273, 21886938, 20659642, 20159942, 17190037, 16032388, 10737080, 10525417, 4824627, 79446334, 79431688, 78916540, 78384965, 77813402, 77623095, 77622308, 77570639, 76958289, 76869539, 76781486, 76732366, 76596215, 76153380, 76151048, 75978245, 75930986, 75898672, 75312046, 74833717, 74734829, 74341632, 74235184, 73560128, 73352194, 73254808, 72087990, 71802001, 71378330, 71185114, 71129073, 71035371, 70727367, 70715496, 70271590, 70262429, 70258113, 69625795, 69610769, 69554390, 69509813, 69345594, 69178802, 69134483, 68995193, 68793481, 63198468, 56675097, 55668839, 53987588, 52406951, 52309709, 50141488, 50091152, 50038930, 50038510, 50038376, 49896238, 43004787, 43004623, 43002342, 35521790, 35478687, 35470111, 35460539, 35306339, 35044192, 34858578, 34719215, 34711370, 34701943, 34668725, 34556042, 34310281, 34237054, 34149283, 34121755, 33897729, 33874208, 33866647, 33754911, 33722334, 33600464, 33509929, 33444526, 33421730, 33253414, 33112054, 32953040, 32875634, 32779079, 32689977, 32652354, 32629727, 32358349, 32268261, 32198837, 32193797, 32190806, 32116901, 32085568, 31973373, 31969263, 31969205, 31901822, 31704301, 31696941, 31560635, 31559178, 31344598, 31284032, 31211385, 31140473, 31122581, 31079097, 31038634, 30970784, 30908619, 30710001, 30692551, 30633139, 30518159, 30404167, 30399112, 30338557, 30281123, 30060053, 29919191, 29905350, 29852472, 29833819, 29826174, 29714131, 29681622, 29608126, 29595035, 29563142, 29558452, 29557574, 29554195, 29437368, 29423866, 29384894, 29361233, 29330997, 29228644, 29225065, 29141732, 29056626, 29022614, 28857832, 28848025, 28777089, 28762525, 28727155, 28690151, 28633403, 28631607, 28412121, 28347290, 28339554, 28334799, 28311445, 28277288, 28277224, 28110144, 28008052, 27956230, 27938877, 27654200, 27609523, 27584105, 27564189, 27551234, 27493578, 27420252, 27409808, 27385201, 27231181, 27228293, 27192230, 27059027, 26806515, 26787049, 26746350, 26653370, 26531887, 26517798, 26494331, 26483009, 26477526, 26401230, 26356620, 26170562, 26161348, 26160429, 26154578, 26117583, 25986242, 25979483, 25910917)
Impact
The heavy requests take up to 10% (135 over 1390 requests per day) of the total requests to this endpoint.
Solution
How about setting a limit of 200 issues/merge requests/participants/labels, and a Load more
button at the end of the page?