Skip to content

GraphQL: Add projects property to CiRunner type

Pedro Pombeiro - OOO from Oct 13-24requested to merge
pedropombeiro/349452-graphql-add-projects-to-runner-type into master

What does this MR do and why?

Describe in detail what your merge request does and why.

This MR builds on GraphQL: Add groups property to CiRunner type (!78454 - merged) and adds a projects property to the Ci::RunnerType GraphQL type, so that the user can determine which projects are associated with a given CI runner. The projects property will be null if the runner is not a project runner.

Screenshots or screen recordings

These are strongly recommended to assist reviewers and reduce the time to merge your change.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

GraphQL query 
query getRunnersProjects {
  runners(first:10) {
    nodes {
      id
      runnerType
      projects {
        nodes {
          fullPath
        }
      }
    }
  }
}
Expected output 
{
  "data": {
    "runners": {
      "nodes": [
        {
          "id": "gid://gitlab/Ci::Runner/103",
          "runnerType": "GROUP_TYPE",
          "projects": null
        },
        {
          "id": "gid://gitlab/Ci::Runner/102",
          "runnerType": "GROUP_TYPE",
          "projects": null
        },
        {
          "id": "gid://gitlab/Ci::Runner/101",
          "runnerType": "INSTANCE_TYPE",
          "projects": null
        },
        {
          "id": "gid://gitlab/Ci::Runner/100",
          "runnerType": "INSTANCE_TYPE",
          "projects": null
        },
        {
          "id": "gid://gitlab/Ci::Runner/99",
          "runnerType": "GROUP_TYPE",
          "projects": null
        },
        {
          "id": "gid://gitlab/Ci::Runner/98",
          "runnerType": "GROUP_TYPE",
          "projects": null
        },
        {
          "id": "gid://gitlab/Ci::Runner/97",
          "runnerType": "GROUP_TYPE",
          "projects": null
        },
        {
          "id": "gid://gitlab/Ci::Runner/96",
          "runnerType": "GROUP_TYPE",
          "projects": null
        },
        {
          "id": "gid://gitlab/Ci::Runner/95",
          "runnerType": "PROJECT_TYPE",
          "projects": {
            "nodes": [
              {
                "fullPath": "h5bp/html5-boilerplate"
              }
            ]
          }
        },
        {
          "id": "gid://gitlab/Ci::Runner/94",
          "runnerType": "PROJECT_TYPE",
          "projects": {
            "nodes": [
              {
                "fullPath": "h5bp/html5-boilerplate"
              }
            ]
          }
        }
      ]
    }
  }
}

Database query plans

I selected a project that contains a large number of runners (ids: 28955390, 16242917) and used the respective runner_ids for the query to simulate a GraphQL query where we select all the runners from the 28955390 and 16242917 projects and in each runner ask in turn for the parent projects.

SQL queries 
SELECT
    "ci_runner_projects"."runner_id",
    "ci_runner_projects"."project_id"
FROM
    "ci_runner_projects"
WHERE
    "ci_runner_projects"."runner_id" IN (2360014,2200682,2068189,9702979,2146073,9703535,2679097,9699255,9706263,3030334,9705441,3295463,9707285,9699373,9695079,9707932,9704313,9705720,9706696,9704699,2068517,9705576,9704614,2115106,9706793,9704354,9705744,2491812,2619576,2347765,9702839,2220570,2090510,9706914,2106238,9695948,1997583,9705735,9707859,9704240,9704620,9706929,2202532,1872712,2183024,9704295,9708630,2201904,9702666,2055369,2491819,9707672,9708255,2075864,2334654,9705605,2104822,1499516,9699422,2607737,9696307,2603345,9703837,2306777,9701747,9706462,2530117,2930230,9701707,9703870,9699183,9699217,9695373,9705602,9706708,2999983,2123431,9702696,2228666,2107840,2063133,9702854,2205460,2166065,9708577,2199711,9702700,2600014,2153318,2181912,2018200,2053845,9695493,9696013,9701862,1872713,2659085,2054351,9698872,9708064,1499567,2063256,9705052,9707911,2141870,9696039,9708097,9705349,1936758,9701994,9699612,9701943,9706794,9694880,1983890,9701787,9705742,2330880,2503963,3264443,2530114,9705317,9694649,9694101,9706429,2204107,1872721,9695717,2920307,9694232,9694672,2054772,9705197,9694083,2200789,9699356,2347764,2430937,9706159,9706445,2671138,2961579,9699889,9702809,9699941,2063628,2076455,9694849,9695093,9708034,2330908,2068151,9701963,9702035,9705846,2054664,9708664,2234425,9705853,3324272,9702191,2205456,1983623,9698580,9698830,1858210,9708447,1781938,9699623,1499419,1872708,2063254,2671273,9693885,2202813,9706573,1829895,1984054,9699584,2347742,9705304,2649299,2355864,9707141,9694235,9703431,9707249,2664976,9695752,9706422,3241322,9699454,9702268,2653376,2930806,9707166,1499420,9705753,9698918,9705569,1848775,2601863,1863357,9706272,9707362,9705355,9698900,9698930,2650802,2089944,9698820,9699083,2426178,2930804,9707017,1853202,2059025,9695506,2575134,9706170,9707363,2312939,9707371,9693902,9706938,9707735,2237210,9706550,9705832,9708326,9699099,2209266,2503953,2648984,2230825,9701833,9701661,1973699,9705847,2053860,2913019,9707135,2653384,2084612,9694670,9708772,2368740,9702873,2664978,9706814,2204850,9693996,9706568,9703065,3029844,9696076,9695098,2137962,9702844,1487896,9694380,9693936,9695724,9701851,9707019,2008046,9701905,9708420,9708038,9708057,1927438,9707496,9707511,3324258,9702298,2174027,1967075,9707046,2035529,1602280,3183157,9699299,9700286,9700403,2228657,2166059,9708088,9702149,2052600,2100123,2077939,2312951,9696329,2648124,9699895,9702850,9708584,9694264,9703027,2250109,9708575,1787555,1858171,2929873,9699582,9699251,2999156,9708305,9702545,9707381,1796493,9695108,9705612,9705015,9699840,9703805,9706269,1984027,9705489,2297669,2109329,9702604,9707147,2570621,3029811,2001629,1863390,2123436,2100720,1983059,2216117,9705727,9706149,9707253,9705168,3461044,9706608,2183226,2084615,9702074,9705057,9704737,9707168,2178689,3029762,9705854,9708277,2966556,9694678,2930786,2172667,9706064,3278646,2555673,2587352,9706821,2570506,2671230,2193706,1935428,9702030,2166051,1968923,9702571,2166036,1756419,2930232,9702159,9702335,9695121,9707898,1851449,1998588,9698997,9706699,2558307,2378257,2183223,3264435,9699928,2503996,9702607,2028974,3030361,2421771,9702519,9706266,9708026,9701899,9707266,2228659,9693959,9698613,9700296,9705584,2378255,9701781,2015362,2030159,2122814,3188200,2608008,3043493,9704655,3030321,2018187,9695151,9699968,2570505,9706158,2603164,9707256,9708604,2056193,2362062,3440950,2607943,2097704,9706077,9706933,9701783,9705845,9708422,9705312,2995805,9695380,9706912,9698576,2123444,2371782,9705344,9703077,1983052,9699106,2389820,3030374,2320713,9705855,9698893,9700348,2930801,9698836,2569765,2603178,9705021,9708480,2205468,9699605,9698793,9705133,9694216,2439287,2109350,2002363,2389851,2321276,1499568,9699265,2059038,9694343,9707261,2603166,3029780,2211916,9698729,9699090,9705023,9708418,2603311,9694658,3043478,2187255,2055893,9707523,9695984,9704269,2225396,2064994,9706556,2693825,9699990,1865741,9694446,2312950,9705446,9707241,2133406,2989724,9702681,9708789,9701871,1983917,9702317,1901425,1967377,2996545,2999101,9699232,9706270,2599995,9705172,2200791,9699386,9694324,9694014,2150383,2053633,3035292,9706570,9707142,9705600,2153492,9705739,9705955,2100130,9694666,2200686,2204825,2103687,9704986,2269181,1997586,1749160,2174034,9707248,9701857,9707130,9705830,2635908,2220434,9699204,9706076,9706917,9707376,2628607,9694298,9702052,9704706,2649011,1798159,9700322,2074685,2273591,9702829,9708297,2002328,9706454,9707924,2109344,9708084,2075198,2675539,2079851,2166330,9696359,1494866,2072843,2126878,9701849,9704257,2074681,2503977,9706260,1866041,9704712,9706470,9694909,9698696,9699342,2150385,2961593,1865733,2110747,2084611,9704227,3029827,9702393,3264393,9699617,2181827,9705310,9706273,2053578,9704248,2347763,9694578,9698627,1888759,9702985,2397737,9699114,9699962,1749110,9708962,9693979,9705494,2204854,2601797,2056220,2068534,2218837,2056028,9699834,2193581,1983048,1781973,9694071,2200684,9705589,9706172,2710468,9708050,3183182,2389779,9708778,9708251,2382623,2653336,2257756,9705041,2985249,9708317,9702698,9707485,9704681,2552457,9707888,9699347,9706702,2018430,1901430,9699987,2053640,9693913,9702874,2200585,9702715,3139816,9694422,2079546,2686039,2930510,2554716,2178501,1487416,2204840,2601864,9694238,2438580,2675559,2086042,2230821,9705951,9698867,2439437,9706567,2389793,9694788,9705306,2371640,9705740,3346745,2256772,9703439,2302237,2929856,2347750,9701593,2312929,2077428,2037431,2930812,9695940,3325147,3043060,9703412,2204796,1506133,2203809,2430006,1844043,9706166,2100335,1863362,9695721,9705729,3030632,9695112,9703803,9693889,2182695,9705049,2290801,9698889,9694335,2250124,9699628,2462815,9706802,9694033,9707021,9694249,9703828,9707692,9707729,2999988,9699177,9694403,9705732,2564459,2675567,9702176,9706792,2225390,9707488,2222385,3183177,9706251,2607937,2059055,2635911,9699277,2063617,9705831,9694362,9702100,2601855,9693940,9705354,9705476,9700324,2998610,2321277,9702994,1870006,2053565,9696036,2153268,1503009,2205492,2129682,9694795,9702869,1844076,3030368,9708486,9696265,9705315,9707676,3274695,2281921,1978748,2653383,9707042,2503995,1979458,9693928,9707373,2587192,2142682,2167400,9704637,1499552,9695970,2710471,9705717,9707145,2146102,2390049,2123588,1495264,2330882,2068526,2930484,2482301,9706051,2109322,9701820,9703447,2053614,2028201,9701752,2401977,9707144,2930472,3141714,9701786,2084618,2056363,9706915,9694089,9706931,9708858,2146121,2487379,9708655,9707398,2439386,2077440,2230830,9706176,2072232,2053851,9708782,2659083,2563627,2204794,9694108,2101778,2220432,9695104,9707273,3226531,2293831,1494322,1830464,2116852,9708028,2578192,2343635,1984038,9702717,9698916,9701607,9705958,2200800,9698608,9706695,1983254,2930798,2053223,9705755,2439384,9706910,2966411,9707246,9708815,9702707,9705431,9695504,2205461,1844066,2996684,9699852,2093846,1849064,9699249,9702411,9701876,9704253,2062339,2601074,2929849,2671275,9694305,1830469,2054361,9698598,3324250,2056366,2068512,2360010,9696024,1901501,9694675,9706691,1866060,9701785,3029825,9707170,2550978,1872707,9699208,9708578,2302377,9704344,2109406,2085120,9701981,9695990,2306458,9699445,9703014,9695065,9698841,9700302,9695187,2142176,9708679,9703481,2653382,2657148,9695734,2693509,9705188,1841770,9699259,9708131,2200527,9694893,9706069,2390144,9703841,9705964,9698783,9694119,9705471,2550783,2068527,2570639,2334001,2653379,2225404,3035278,9707139,9694412,9702000,2556745,2575132,3209022,2228258,9706415,9706714,2587437,2252387,9694233,2619577,9702089,2213087,1983258,2930790,9700320,9700414,3043466,9695483,2204851,9703109,2465981,2402534,9708246,9706710,2061038,9706926,3346742,3139848,1968230,9700336,1872719,9705736,2603280,2358809,3187725,9706075,9705751,2250105,2347738,9701859,9693937,9707386,9698715,3264409,1988484,1843383,9707916,2603175,1502976,9699512,2575342,3349798,2220496,9696249,9708661,2402530,3123297,1983144,9695185,9705942,9707516,9701762,2054799,2025007,9705147,2053571,2123584,1851560,9700309,2233230,9696067,9705193,9699995,9707868,2088719,9707039,2087609,9702347,9707394,9708253,2587182,2995811,2299284)
SELECT
    "projects"."id",
    "projects"."name",
    "projects"."path",
    "projects"."description",
    "projects"."created_at",
    "projects"."updated_at",
    "projects"."creator_id",
    "projects"."namespace_id",
    "projects"."last_activity_at",
    "projects"."import_url",
    "projects"."visibility_level",
    "projects"."archived",
    "projects"."avatar",
    "projects"."merge_requests_template",
    "projects"."star_count",
    "projects"."merge_requests_rebase_enabled",
    "projects"."import_type",
    "projects"."import_source",
    "projects"."approvals_before_merge",
    "projects"."reset_approvals_on_push",
    "projects"."merge_requests_ff_only_enabled",
    "projects"."issues_template",
    "projects"."mirror",
    "projects"."mirror_user_id",
    "projects"."shared_runners_enabled",
    "projects"."runners_token",
    "projects"."build_coverage_regex",
    "projects"."build_allow_git_fetch",
    "projects"."build_timeout",
    "projects"."mirror_trigger_builds",
    "projects"."pending_delete",
    "projects"."public_builds",
    "projects"."last_repository_check_failed",
    "projects"."last_repository_check_at",
    "projects"."only_allow_merge_if_pipeline_succeeds",
    "projects"."has_external_issue_tracker",
    "projects"."repository_storage",
    "projects"."repository_read_only",
    "projects"."request_access_enabled",
    "projects"."has_external_wiki",
    "projects"."ci_config_path",
    "projects"."lfs_enabled",
    "projects"."description_html",
    "projects"."only_allow_merge_if_all_discussions_are_resolved",
    "projects"."repository_size_limit",
    "projects"."printing_merge_request_link_enabled",
    "projects"."auto_cancel_pending_pipelines",
    "projects"."service_desk_enabled",
    "projects"."cached_markdown_version",
    "projects"."delete_error",
    "projects"."last_repository_updated_at",
    "projects"."disable_overriding_approvers_per_merge_request",
    "projects"."storage_version",
    "projects"."resolve_outdated_diff_discussions",
    "projects"."remote_mirror_available_overridden",
    "projects"."only_mirror_protected_branches",
    "projects"."pull_mirror_available_overridden",
    "projects"."jobs_cache_index",
    "projects"."external_authorization_classification_label",
    "projects"."mirror_overwrites_diverged_branches",
    "projects"."pages_https_only",
    "projects"."external_webhook_token",
    "projects"."packages_enabled",
    "projects"."merge_requests_author_approval",
    "projects"."pool_repository_id",
    "projects"."runners_token_encrypted",
    "projects"."bfg_object_map",
    "projects"."detected_repository_languages",
    "projects"."merge_requests_disable_committers_approval",
    "projects"."require_password_to_approve",
    "projects"."emails_disabled",
    "projects"."max_pages_size",
    "projects"."max_artifacts_size",
    "projects"."remove_source_branch_after_merge",
    "projects"."marked_for_deletion_at",
    "projects"."marked_for_deletion_by_user_id",
    "projects"."autoclose_referenced_issues",
    "projects"."suggestion_commit_message",
    "projects"."project_namespace_id"
FROM
    "projects"
WHERE
    "projects"."id" IN (28955390, 16242917)
Query plan

Plan link: https://postgres.ai/console/gitlab/gitlab-production-tunnel-pg12/sessions/8134/commands/28935

 Index Scan using index_ci_runner_projects_on_runner_id on public.ci_runner_projects  (cost=0.43..2209.80 rows=1429 width=8) (actual time=4.485..229.618 rows=1000 loops=1)
   Index Cond: (ci_runner_projects.runner_id = ANY ('{2360014,2200682,2068189,9702979,2146073,9703535,2679097,9699255,9706263,3030334,9705441,3295463,9707285,9699373,9695079,9707932,9704313,9705720,9706696,9704699,2068517,9705576,9704614,2115106,9706793,9704354,9705744,2491812,2619576,2347765,9702839,2220570,2090510,9706914,2106238,9695948,1997583,9705735,9707859,9704240,9704620,9706929,2202532,1872712,2183024,9704295,9708630,2201904,9702666,2055369,2491819,9707672,9708255,2075864,2334654,9705605,2104822,1499516,9699422,2607737,9696307,2603345,9703837,2306777,9701747,9706462,2530117,2930230,9701707,9703870,9699183,9699217,9695373,9705602,9706708,2999983,2123431,9702696,2228666,2107840,2063133,9702854,2205460,2166065,9708577,2199711,9702700,2600014,2153318,2181912,2018200,2053845,9695493,9696013,9701862,1872713,2659085,2054351,9698872,9708064,1499567,2063256,9705052,9707911,2141870,9696039,9708097,9705349,1936758,9701994,9699612,9701943,9706794,9694880,1983890,9701787,9705742,2330880,2503963,3264443,2530114,9705317,9694649,9694101,9706429,2204107,1872721,9695717,2920307,9694232,9694672,2054772,9705197,9694083,2200789,9699356,2347764,2430937,9706159,9706445,2671138,2961579,9699889,9702809,9699941,2063628,2076455,9694849,9695093,9708034,2330908,2068151,9701963,9702035,9705846,2054664,9708664,2234425,9705853,3324272,9702191,2205456,1983623,9698580,9698830,1858210,9708447,1781938,9699623,1499419,1872708,2063254,2671273,9693885,2202813,9706573,1829895,1984054,9699584,2347742,9705304,2649299,2355864,9707141,9694235,9703431,9707249,2664976,9695752,9706422,3241322,9699454,9702268,2653376,2930806,9707166,1499420,9705753,9698918,9705569,1848775,2601863,1863357,9706272,9707362,9705355,9698900,9698930,2650802,2089944,9698820,9699083,2426178,2930804,9707017,1853202,2059025,9695506,2575134,9706170,9707363,2312939,9707371,9693902,9706938,9707735,2237210,9706550,9705832,9708326,9699099,2209266,2503953,2648984,2230825,9701833,9701661,1973699,9705847,2053860,2913019,9707135,2653384,2084612,9694670,9708772,2368740,9702873,2664978,9706814,2204850,9693996,9706568,9703065,3029844,9696076,9695098,2137962,9702844,1487896,9694380,9693936,9695724,9701851,9707019,2008046,9701905,9708420,9708038,9708057,1927438,9707496,9707511,3324258,9702298,2174027,1967075,9707046,2035529,1602280,3183157,9699299,9700286,9700403,2228657,2166059,9708088,9702149,2052600,2100123,2077939,2312951,9696329,2648124,9699895,9702850,9708584,9694264,9703027,2250109,9708575,1787555,1858171,2929873,9699582,9699251,2999156,9708305,9702545,9707381,1796493,9695108,9705612,9705015,9699840,9703805,9706269,1984027,9705489,2297669,2109329,9702604,9707147,2570621,3029811,2001629,1863390,2123436,2100720,1983059,2216117,9705727,9706149,9707253,9705168,3461044,9706608,2183226,2084615,9702074,9705057,9704737,9707168,2178689,3029762,9705854,9708277,2966556,9694678,2930786,2172667,9706064,3278646,2555673,2587352,9706821,2570506,2671230,2193706,1935428,9702030,2166051,1968923,9702571,2166036,1756419,2930232,9702159,9702335,9695121,9707898,1851449,1998588,9698997,9706699,2558307,2378257,2183223,3264435,9699928,2503996,9702607,2028974,3030361,2421771,9702519,9706266,9708026,9701899,9707266,2228659,9693959,9698613,9700296,9705584,2378255,9701781,2015362,2030159,2122814,3188200,2608008,3043493,9704655,3030321,2018187,9695151,9699968,2570505,9706158,2603164,9707256,9708604,2056193,2362062,3440950,2607943,2097704,9706077,9706933,9701783,9705845,9708422,9705312,2995805,9695380,9706912,9698576,2123444,2371782,9705344,9703077,1983052,9699106,2389820,3030374,2320713,9705855,9698893,9700348,2930801,9698836,2569765,2603178,9705021,9708480,2205468,9699605,9698793,9705133,9694216,2439287,2109350,2002363,2389851,2321276,1499568,9699265,2059038,9694343,9707261,2603166,3029780,2211916,9698729,9699090,9705023,9708418,2603311,9694658,3043478,2187255,2055893,9707523,9695984,9704269,2225396,2064994,9706556,2693825,9699990,1865741,9694446,2312950,9705446,9707241,2133406,2989724,9702681,9708789,9701871,1983917,9702317,1901425,1967377,2996545,2999101,9699232,9706270,2599995,9705172,2200791,9699386,9694324,9694014,2150383,2053633,3035292,9706570,9707142,9705600,2153492,9705739,9705955,2100130,9694666,2200686,2204825,2103687,9704986,2269181,1997586,1749160,2174034,9707248,9701857,9707130,9705830,2635908,2220434,9699204,9706076,9706917,9707376,2628607,9694298,9702052,9704706,2649011,1798159,9700322,2074685,2273591,9702829,9708297,2002328,9706454,9707924,2109344,9708084,2075198,2675539,2079851,2166330,9696359,1494866,2072843,2126878,9701849,9704257,2074681,2503977,9706260,1866041,9704712,9706470,9694909,9698696,9699342,2150385,2961593,1865733,2110747,2084611,9704227,3029827,9702393,3264393,9699617,2181827,9705310,9706273,2053578,9704248,2347763,9694578,9698627,1888759,9702985,2397737,9699114,9699962,1749110,9708962,9693979,9705494,2204854,2601797,2056220,2068534,2218837,2056028,9699834,2193581,1983048,1781973,9694071,2200684,9705589,9706172,2710468,9708050,3183182,2389779,9708778,9708251,2382623,2653336,2257756,9705041,2985249,9708317,9702698,9707485,9704681,2552457,9707888,9699347,9706702,2018430,1901430,9699987,2053640,9693913,9702874,2200585,9702715,3139816,9694422,2079546,2686039,2930510,2554716,2178501,1487416,2204840,2601864,9694238,2438580,2675559,2086042,2230821,9705951,9698867,2439437,9706567,2389793,9694788,9705306,2371640,9705740,3346745,2256772,9703439,2302237,2929856,2347750,9701593,2312929,2077428,2037431,2930812,9695940,3325147,3043060,9703412,2204796,1506133,2203809,2430006,1844043,9706166,2100335,1863362,9695721,9705729,3030632,9695112,9703803,9693889,2182695,9705049,2290801,9698889,9694335,2250124,9699628,2462815,9706802,9694033,9707021,9694249,9703828,9707692,9707729,2999988,9699177,9694403,9705732,2564459,2675567,9702176,9706792,2225390,9707488,2222385,3183177,9706251,2607937,2059055,2635911,9699277,2063617,9705831,9694362,9702100,2601855,9693940,9705354,9705476,9700324,2998610,2321277,9702994,1870006,2053565,9696036,2153268,1503009,2205492,2129682,9694795,9702869,1844076,3030368,9708486,9696265,9705315,9707676,3274695,2281921,1978748,2653383,9707042,2503995,1979458,9693928,9707373,2587192,2142682,2167400,9704637,1499552,9695970,2710471,9705717,9707145,2146102,2390049,2123588,1495264,2330882,2068526,2930484,2482301,9706051,2109322,9701820,9703447,2053614,2028201,9701752,2401977,9707144,2930472,3141714,9701786,2084618,2056363,9706915,9694089,9706931,9708858,2146121,2487379,9708655,9707398,2439386,2077440,2230830,9706176,2072232,2053851,9708782,2659083,2563627,2204794,9694108,2101778,2220432,9695104,9707273,3226531,2293831,1494322,1830464,2116852,9708028,2578192,2343635,1984038,9702717,9698916,9701607,9705958,2200800,9698608,9706695,1983254,2930798,2053223,9705755,2439384,9706910,2966411,9707246,9708815,9702707,9705431,9695504,2205461,1844066,2996684,9699852,2093846,1849064,9699249,9702411,9701876,9704253,2062339,2601074,2929849,2671275,9694305,1830469,2054361,9698598,3324250,2056366,2068512,2360010,9696024,1901501,9694675,9706691,1866060,9701785,3029825,9707170,2550978,1872707,9699208,9708578,2302377,9704344,2109406,2085120,9701981,9695990,2306458,9699445,9703014,9695065,9698841,9700302,9695187,2142176,9708679,9703481,2653382,2657148,9695734,2693509,9705188,1841770,9699259,9708131,2200527,9694893,9706069,2390144,9703841,9705964,9698783,9694119,9705471,2550783,2068527,2570639,2334001,2653379,2225404,3035278,9707139,9694412,9702000,2556745,2575132,3209022,2228258,9706415,9706714,2587437,2252387,9694233,2619577,9702089,2213087,1983258,2930790,9700320,9700414,3043466,9695483,2204851,9703109,2465981,2402534,9708246,9706710,2061038,9706926,3346742,3139848,1968230,9700336,1872719,9705736,2603280,2358809,3187725,9706075,9705751,2250105,2347738,9701859,9693937,9707386,9698715,3264409,1988484,1843383,9707916,2603175,1502976,9699512,2575342,3349798,2220496,9696249,9708661,2402530,3123297,1983144,9695185,9705942,9707516,9701762,2054799,2025007,9705147,2053571,2123584,1851560,9700309,2233230,9696067,9705193,9699995,9707868,2088719,9707039,2087609,9702347,9707394,9708253,2587182,2995811,2299284}'::integer[]))
   Buffers: shared hit=2931 read=1040 dirtied=45
   I/O Timings: read=222.233 write=0.000

Plan link: https://postgres.ai/console/gitlab/gitlab-production-tunnel-pg12/sessions/8134/commands/28936

 Index Scan using projects_pkey on public.projects  (cost=0.44..6.63 rows=2 width=585) (actual time=19.327..27.764 rows=2 loops=1)
   Index Cond: (projects.id = ANY ('{28955390,16242917}'::integer[]))
   Buffers: shared hit=4 read=7
   I/O Timings: read=27.624 write=0.000

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Closes #349452 (closed)

Edited by Pedro Pombeiro - OOO from Oct 13-24

Merge request reports