Skip to content

GraphQL: Add groups property to CiRunner type

Pedro Pombeiro (OOO from July 16th till Aug 7th) requested to merge pedropombeiro/349897-graphql-add-groups-to-runner-type into master

What does this MR do and why?

Describe in detail what your merge request does and why.

This MR adds a groups property to the Ci::RunnerType GraphQL type, so that the user can determine which groups are associated with a given CI runner. The groups property will be null if the runner is not a group 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 getRunnersGroups {
  runners {
    nodes {
      id
      runnerType
      groups {
        nodes {
          fullName
        }
      }
    }
  }
}
Expected output 
{
  "data": {
    "runners": {
      "nodes": [
        {
          "id": "gid://gitlab/Ci::Runner/102",
          "groups": {
            "nodes": [
              {
                "fullName": "H5bp"
              }
            ]
          }
        },
        {
          "id": "gid://gitlab/Ci::Runner/101",
          "groups": {
            "nodes": [] # not a group runner
          }
        }
      ]
    }
  }
}

Database query plans

I selected a namespace that contains a large number of runners (id: 38109) and used the respective runner_ids for the query to simulate a GraphQL query where we select all the runners from the 38109 group and in each runner ask in turn for the parent groups.

SQL queries 
SELECT
    "ci_runner_namespaces"."runner_id",
    "ci_runner_namespaces"."namespace_id"
FROM
    "ci_runner_namespaces"
WHERE
    "ci_runner_namespaces"."runner_id" IN (12523509,12520773,12199298,10939997,10939994,10939991,10939990,10939987,10939983,10939978,10939973,10939965,10939961,10939958,10939955,10939951,10939949,10939944,10939941,10939937,10939931,10939926,10939922,10939918,10939914,10939910,10939905,10939901,10939897,10939894,10939891,10939888,10939883,10939762,10939759,10939756,10939751,10939749,10939747,10939743,10939730,10939726,10939723,10939716,10939710,10939707,10939698,10939694,10939690,10939687,10939684,10939680,10939674,10939672,10939668,10939667,10939662,10939658,10939656,10939652,10939649,10939647,10939645,10939548,10939546,10939543,10939540,10939537,10939534,10939531,10939529,10939526,10939522,10939521,10939519,10939517,10939515,10939511,10939509,10939506,10939504,10939500,10939499,10939497,10939495,10939493,10939491,10939489,10939487,10939485,10939483,10939481,10939478,10939340,10938882,10938879,10938875,10938870,10938868,10938865,10938861,10938859,10938857,10938856,10938854,10938849,10938847,10938845,10938843,10938842,10938840,10938838,10938835,10938706,10938703,10938700,10938698,10938696,10938692,10938690,10938689,10938686,10938683,10938680,10938678,10938676,10938671,10938667,10938665,10938657,10938651,10938646,10938643,10938641,10938638,10938632,10938630,10938627,10938621,10938619,10938616,10938613,10938610,10938477,10938474,10938472,10938468,10938466,10938448,10938444,10938442,10938439,10938433,10938431,10938427,10938424,10938421,10938419,10938415,10938414,10938412,10938407,10938405,10938399,10938396,10938394,10938392,10938390,10938388,10938384,10938380,10938378,10938376,10938222,10938220,10938217,10938213,10938211,10938207,10938204,10938199,10938196,10938194,10938187,10938184,10938182,10938177,10938172,10938170,10938167,10938165,10938163,10938161,10938158,10938155,10938153,10938152,10938150,10938148,10938145,10938142,10938140,10938137,10938009,10938006,10938002,10938000,10937998,10937997,10937995,10937992,10937990,10937983,10937980,10937978,10937976,10937974,10937971,10937969,10937967,10937965,10937962,10937960,10937956,10937955,10937952,10937950,10937948,10937946,10937943,10937940,10937935,10937932,10937740,10937737,10937736,10937731,10937727,10937722,10937719,10937717,10937715,10937713,10937711,10937708,10937705,10937701,10937696,10937694,10937692,10937690,10937688,10937684,10937682,10937679,10937676,10937673,10937671,10937663,10937658,10937651,10937646,10937639,10937497,10937495,10937492,10937489,10937487,10937485,10937482,10937480,10937477,10937475,10937473,10937471,10937467,10937465,10937464,10937462,10937460,10937456,10937454,10937452,10937450,10937448,10937445,10937444,10937439,10937437,10937435,10937433,10937431,10937429,10937282,10937278,10937275,10937273,10937270,10937262,10937260,10937258,10937255,10937253,10937250,10937248,10937246,10937244,10937241,10937239,10937238,10937236,10937234,10937232,10937229,10937227,10937223,10937221,10937219,10937216,10937214,10937209,10937075,10937073,10937068,10937066,10937063,10937060,10937058,10937055,10937053,10937051,10937049,10937046,10937043,10937041,10937039,10937036,10937034,10937032,10937030,10937028,10937026,10937024,10937021,10937020,10937018,10937014,10937012,10937007,10937004,10937002,10936887,10936885,10936883,10936882,10936878,10936874,10936870,10936868,10936866,10936862,10936860,10936857,10936855,10936853,10936851,10936849,10936847,10936845,10939337,10939335,10939333,10939331,10939328,10939326,10939324,10939322,10939320,10939319,10939317,10939315,10939311,10939309,10939307,10939305,10939303,10939300,10939298,10939294,10939292,10939289,10939285,10939283,10939279,10939277,10939276,10939274,10939272,10939118,10939109,10939105,10939101,10939099,10939097,10939095,10939092,10939091,10939089,10939085,10939082,10939078,10939076,10939072,10939068,10939064,10939060,10939058,10939056,10939053,10939050,10939048,10939046,10939043,10939041,10939039,10939037,10939035,10939033,10938914,10938911,10938909,10938906,10938904,10938903,10938899,10938896,10938893,10938890,10938886,10936841,10936837,10936835,10936833,10936831,10936828,10936825,10936822,10936818,10936816,10936815,10936813,10936694,10936692,10936689,10936687,10936685,10936683,10936681,10936680,10936677,10936672,10936669,10936667,10936665,10936662,10936658,10936656,10936654,10936651,10936648,10936646,10936643,10936640,10936639,10936637,10936633,10936631,10936628,10936625,10936622,10936619,10936494,10936492,10936490,10936487,10936485,10936481,10936477,10936475,10936474,10936471,10936468,10936466,10936463,10936461,10936459,10936457,10936456,10936454,10936452,10936450,10936448,10936444,10936441,10936438,10936435,10936431,10936428,10936426,10936424,10936421,10936292,10936289,10936287,10936284,10936282,10936280,10936275,10936274,10936272,10936268,10936266,10936263,10936261,10936259,10936257,10936255,10936253,10936251,10936249,10936247,10936245,10936242,10936238,10936237,10936235,10936232,10936230,10936227,10936225,10936223,10936074,10936072,10936069,10936066,10936063,10936059,10936055,10936050,10936047,10936045,10936043,10936037,10936034,10936031,10936029,10936022,10935997,10935995,10935993,10935990,10935987,10935982,10935978,10935976,10935974,10935971,10935967,10935964,10935961,10935959,10935837,10935783,10935781,10935779,10935777,10935774,10935769,10935766,10935761,10935757,10935630,10935627,10935625,10935623,10935621,10935619,10935617,10935615,10935612,10935610,10935608,10935604,10935602,10935599,10935596,10935594,10935593,10935591,10935589,10935587,10935583,10935581,10935575,10935572,10935571,10935569,10935567,10935565,10935562,10935560,10935427,10935424,10935423,10935421,10935417,10935413,10935411,10935409,10935406,10935403,10935401,10935400,10935396,10935393,10935390,10935387,10935384,10935379,10935376,10935373,10935370,10935365,10935363,10935361,10935359,10935355,10935352,10935350,10935348,10935346,10935191,10935189,10937268,10937264,10935187,10935185,10935183,10935181,10935178,10935173,10935171,10935169,10935167,10935165,10935162,10935160,10935157,10935154,10935151,10935149,10935146,10935143,10935140,10935133,10935132,10935130,10935127,10935121,10935116,10935113,10935111,10935109,10934974,10934972,10934970,10934968,10934966,10934963,10934962,10934959,10934957,10934950,10934946,10934944,10934940,10934938,10934937,10934930,10934928,10934925,10934923,10934915,10934910,10934906,10934904,10934902,10934899,10934898,10934894,10934892,10934890,10934887,10934745,10934743,10934741,10934739,10934737,10934735,10934732,10934729,10934727,10934724,10934722,10934720,10934717,10934714,10934712,10934709,10934707,10934703,10934700,10934692,10934688,10934685,10934682,10934678,10934675,10934670,10934665,10934662,10934656,10934651,10934477,10934474,10934472,10934469,10934466,10934462,10934458,10934455,10934453,10934450,10934448,10934446,10934444,10934442,10934440,10934437,10934435,10934433,10934430,10934428,10934424,10934420,10934417,10934413,10934411,10934409,10934407,10934404,10934401,10934395,10934281,10934278,10934275,10934272,10934268,10934264,10934260,10934257,10934253,10934249,10934246,10934242,10934239,10934234,10934229,10934226,10934222,10934219,10934215,10934213,10934209,10934206,10934202,10934199,10934196,10934191,10934187,10934184,10934180,10934177,10934146,10934143,10934141,10934139,10934136,10934134,10934130,10934127,10934124,10934122,10934120,10934118,10934116,10934113,10934110,10934108,10934106,10934104,10934101,10934098,10934094,10934090,10934087,10934083,10934081,10934079,10934076,10934072,10934068,10934060,10934037,10934033,10934030,10934027,10934024,10934017,10934012,10934011,10934007,10934003,10934000,10933997,10933994,10933990,10933987,10933984,10933981,10933975,10933972,10933968,10933964,10933959,10933956,10933953,10933949,10933946,10935835,10935832,10935830,10935828,10935825,10935823,10935821,10935819,10935815,10935814,10935811,10935809,10935802,10935800,10935797,10935794,10935792,10935790,10935788,10935786,10933943,10933939,10933932,10933926,10933919,10933917,10933915,10933913,10933911,10933906,10933905,10933902,10933900,10933898,10933895,10933891,10933887,10933885,10933883,10933881,10933878,10933876,10933871,10933866,10933861,10933857,10933856,10933854,10933852,10933849,10933846,10933844,10933841,10933839,10933832,10933830,10933828,10933826,10933824,10933822,10933819,10933818,10933816,10933814,10933811,10933808,10933806,10933803,10933801,10933800,10933797,10933794,10933791,10933788,10933785,10933780,10933775,10933772,10933768,10933766,10933763,10933760,10933756,10933753,10933751,10933747,10933743,10933740,10933736,10933734,10933731,10933728,10933725,10933722,10933718,10933715,10933712,10933709,10933705,10933702,10933698,10933695,10933691,10933688,10933686,10933685,10933683,10933679,10933677,10933675,10933672,10933670,10933667,10933664,10445856,10074131,9929840,9922720,9922608,9907728,9907557,9874189,9857369,9856494,9832218,9478797,9458104,9456477,9259405,9191384,9146337,9068954,9068773,8992718,8964860,8962928,8961301,8960938,8941478,8890653,8888968,8837342,8782727,8738780,8600523,8597773,8287082,8234777,8179438,7643378,7643059,7600709,7547318,7511745,7255377,7255159,7220904,7214731,7165305,7165160,7161104,6929523,6900068,6587474,6587084,6586292,6584696,6370914,6356661,6315879,6310317,6261410,6254872,6219622,6217337,6212840,5955145,5913489,5799798,5772734,5768588,5767294,5675172,5675031,5666124,5665155,5498376,5497830,5443852,5312087,5196769,5190978,5190440,5165457,5160179,5156158,4946378,4923326,4897367,4896086,4892202,4865062,4840477,4840398,4840142,4839246,4768994,4768633,4768123,4766246,4745571,4733218,4448210,4448181,4150880,4125613,2549546,2549545,2191781,2191780,2029015,2028434,2028246)
SELECT
    "namespaces"."id",
    "namespaces"."name",
    "namespaces"."path",
    "namespaces"."owner_id",
    "namespaces"."created_at",
    "namespaces"."updated_at",
    "namespaces"."type",
    "namespaces"."description",
    "namespaces"."avatar",
    "namespaces"."membership_lock",
    "namespaces"."share_with_group_lock",
    "namespaces"."visibility_level",
    "namespaces"."request_access_enabled",
    "namespaces"."ldap_sync_status",
    "namespaces"."ldap_sync_error",
    "namespaces"."ldap_sync_last_update_at",
    "namespaces"."ldap_sync_last_successful_update_at",
    "namespaces"."ldap_sync_last_sync_at",
    "namespaces"."description_html",
    "namespaces"."lfs_enabled",
    "namespaces"."parent_id",
    "namespaces"."shared_runners_minutes_limit",
    "namespaces"."repository_size_limit",
    "namespaces"."require_two_factor_authentication",
    "namespaces"."two_factor_grace_period",
    "namespaces"."cached_markdown_version",
    "namespaces"."project_creation_level",
    "namespaces"."runners_token",
    "namespaces"."file_template_project_id",
    "namespaces"."saml_discovery_token",
    "namespaces"."runners_token_encrypted",
    "namespaces"."custom_project_templates_group_id",
    "namespaces"."auto_devops_enabled",
    "namespaces"."extra_shared_runners_minutes_limit",
    "namespaces"."last_ci_minutes_notification_at",
    "namespaces"."last_ci_minutes_usage_notification_level",
    "namespaces"."subgroup_creation_level",
    "namespaces"."emails_disabled",
    "namespaces"."max_pages_size",
    "namespaces"."max_artifacts_size",
    "namespaces"."mentions_disabled",
    "namespaces"."default_branch_protection",
    "namespaces"."unlock_membership_to_ldap",
    "namespaces"."max_personal_access_token_lifetime",
    "namespaces"."push_rule_id",
    "namespaces"."shared_runners_enabled",
    "namespaces"."allow_descendants_override_disabled_shared_runners",
    "namespaces"."traversal_ids"
FROM
    "namespaces"
WHERE
    "namespaces"."type" = 'Group'
    AND "namespaces"."id" IN (38109)
Query plan

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

 Index Only Scan using index_ci_runner_namespaces_on_runner_id_and_namespace_id on public.ci_runner_namespaces  (cost=0.43..2426.78 rows=1072 width=8) (actual time=0.248..3.220 rows=1072 loops=1)
   Index Cond: (ci_runner_namespaces.runner_id = ANY ('{12523509,12520773,12199298,10939997,10939994,10939991,10939990,10939987,10939983,10939978,10939973,10939965,10939961,10939958,10939955,10939951,10939949,10939944,10939941,10939937,10939931,10939926,10939922,10939918,10939914,10939910,10939905,10939901,10939897,10939894,10939891,10939888,10939883,10939762,10939759,10939756,10939751,10939749,10939747,10939743,10939730,10939726,10939723,10939716,10939710,10939707,10939698,10939694,10939690,10939687,10939684,10939680,10939674,10939672,10939668,10939667,10939662,10939658,10939656,10939652,10939649,10939647,10939645,10939548,10939546,10939543,10939540,10939537,10939534,10939531,10939529,10939526,10939522,10939521,10939519,10939517,10939515,10939511,10939509,10939506,10939504,10939500,10939499,10939497,10939495,10939493,10939491,10939489,10939487,10939485,10939483,10939481,10939478,10939340,10938882,10938879,10938875,10938870,10938868,10938865,10938861,10938859,10938857,10938856,10938854,10938849,10938847,10938845,10938843,10938842,10938840,10938838,10938835,10938706,10938703,10938700,10938698,10938696,10938692,10938690,10938689,10938686,10938683,10938680,10938678,10938676,10938671,10938667,10938665,10938657,10938651,10938646,10938643,10938641,10938638,10938632,10938630,10938627,10938621,10938619,10938616,10938613,10938610,10938477,10938474,10938472,10938468,10938466,10938448,10938444,10938442,10938439,10938433,10938431,10938427,10938424,10938421,10938419,10938415,10938414,10938412,10938407,10938405,10938399,10938396,10938394,10938392,10938390,10938388,10938384,10938380,10938378,10938376,10938222,10938220,10938217,10938213,10938211,10938207,10938204,10938199,10938196,10938194,10938187,10938184,10938182,10938177,10938172,10938170,10938167,10938165,10938163,10938161,10938158,10938155,10938153,10938152,10938150,10938148,10938145,10938142,10938140,10938137,10938009,10938006,10938002,10938000,10937998,10937997,10937995,10937992,10937990,10937983,10937980,10937978,10937976,10937974,10937971,10937969,10937967,10937965,10937962,10937960,10937956,10937955,10937952,10937950,10937948,10937946,10937943,10937940,10937935,10937932,10937740,10937737,10937736,10937731,10937727,10937722,10937719,10937717,10937715,10937713,10937711,10937708,10937705,10937701,10937696,10937694,10937692,10937690,10937688,10937684,10937682,10937679,10937676,10937673,10937671,10937663,10937658,10937651,10937646,10937639,10937497,10937495,10937492,10937489,10937487,10937485,10937482,10937480,10937477,10937475,10937473,10937471,10937467,10937465,10937464,10937462,10937460,10937456,10937454,10937452,10937450,10937448,10937445,10937444,10937439,10937437,10937435,10937433,10937431,10937429,10937282,10937278,10937275,10937273,10937270,10937262,10937260,10937258,10937255,10937253,10937250,10937248,10937246,10937244,10937241,10937239,10937238,10937236,10937234,10937232,10937229,10937227,10937223,10937221,10937219,10937216,10937214,10937209,10937075,10937073,10937068,10937066,10937063,10937060,10937058,10937055,10937053,10937051,10937049,10937046,10937043,10937041,10937039,10937036,10937034,10937032,10937030,10937028,10937026,10937024,10937021,10937020,10937018,10937014,10937012,10937007,10937004,10937002,10936887,10936885,10936883,10936882,10936878,10936874,10936870,10936868,10936866,10936862,10936860,10936857,10936855,10936853,10936851,10936849,10936847,10936845,10939337,10939335,10939333,10939331,10939328,10939326,10939324,10939322,10939320,10939319,10939317,10939315,10939311,10939309,10939307,10939305,10939303,10939300,10939298,10939294,10939292,10939289,10939285,10939283,10939279,10939277,10939276,10939274,10939272,10939118,10939109,10939105,10939101,10939099,10939097,10939095,10939092,10939091,10939089,10939085,10939082,10939078,10939076,10939072,10939068,10939064,10939060,10939058,10939056,10939053,10939050,10939048,10939046,10939043,10939041,10939039,10939037,10939035,10939033,10938914,10938911,10938909,10938906,10938904,10938903,10938899,10938896,10938893,10938890,10938886,10936841,10936837,10936835,10936833,10936831,10936828,10936825,10936822,10936818,10936816,10936815,10936813,10936694,10936692,10936689,10936687,10936685,10936683,10936681,10936680,10936677,10936672,10936669,10936667,10936665,10936662,10936658,10936656,10936654,10936651,10936648,10936646,10936643,10936640,10936639,10936637,10936633,10936631,10936628,10936625,10936622,10936619,10936494,10936492,10936490,10936487,10936485,10936481,10936477,10936475,10936474,10936471,10936468,10936466,10936463,10936461,10936459,10936457,10936456,10936454,10936452,10936450,10936448,10936444,10936441,10936438,10936435,10936431,10936428,10936426,10936424,10936421,10936292,10936289,10936287,10936284,10936282,10936280,10936275,10936274,10936272,10936268,10936266,10936263,10936261,10936259,10936257,10936255,10936253,10936251,10936249,10936247,10936245,10936242,10936238,10936237,10936235,10936232,10936230,10936227,10936225,10936223,10936074,10936072,10936069,10936066,10936063,10936059,10936055,10936050,10936047,10936045,10936043,10936037,10936034,10936031,10936029,10936022,10935997,10935995,10935993,10935990,10935987,10935982,10935978,10935976,10935974,10935971,10935967,10935964,10935961,10935959,10935837,10935783,10935781,10935779,10935777,10935774,10935769,10935766,10935761,10935757,10935630,10935627,10935625,10935623,10935621,10935619,10935617,10935615,10935612,10935610,10935608,10935604,10935602,10935599,10935596,10935594,10935593,10935591,10935589,10935587,10935583,10935581,10935575,10935572,10935571,10935569,10935567,10935565,10935562,10935560,10935427,10935424,10935423,10935421,10935417,10935413,10935411,10935409,10935406,10935403,10935401,10935400,10935396,10935393,10935390,10935387,10935384,10935379,10935376,10935373,10935370,10935365,10935363,10935361,10935359,10935355,10935352,10935350,10935348,10935346,10935191,10935189,10937268,10937264,10935187,10935185,10935183,10935181,10935178,10935173,10935171,10935169,10935167,10935165,10935162,10935160,10935157,10935154,10935151,10935149,10935146,10935143,10935140,10935133,10935132,10935130,10935127,10935121,10935116,10935113,10935111,10935109,10934974,10934972,10934970,10934968,10934966,10934963,10934962,10934959,10934957,10934950,10934946,10934944,10934940,10934938,10934937,10934930,10934928,10934925,10934923,10934915,10934910,10934906,10934904,10934902,10934899,10934898,10934894,10934892,10934890,10934887,10934745,10934743,10934741,10934739,10934737,10934735,10934732,10934729,10934727,10934724,10934722,10934720,10934717,10934714,10934712,10934709,10934707,10934703,10934700,10934692,10934688,10934685,10934682,10934678,10934675,10934670,10934665,10934662,10934656,10934651,10934477,10934474,10934472,10934469,10934466,10934462,10934458,10934455,10934453,10934450,10934448,10934446,10934444,10934442,10934440,10934437,10934435,10934433,10934430,10934428,10934424,10934420,10934417,10934413,10934411,10934409,10934407,10934404,10934401,10934395,10934281,10934278,10934275,10934272,10934268,10934264,10934260,10934257,10934253,10934249,10934246,10934242,10934239,10934234,10934229,10934226,10934222,10934219,10934215,10934213,10934209,10934206,10934202,10934199,10934196,10934191,10934187,10934184,10934180,10934177,10934146,10934143,10934141,10934139,10934136,10934134,10934130,10934127,10934124,10934122,10934120,10934118,10934116,10934113,10934110,10934108,10934106,10934104,10934101,10934098,10934094,10934090,10934087,10934083,10934081,10934079,10934076,10934072,10934068,10934060,10934037,10934033,10934030,10934027,10934024,10934017,10934012,10934011,10934007,10934003,10934000,10933997,10933994,10933990,10933987,10933984,10933981,10933975,10933972,10933968,10933964,10933959,10933956,10933953,10933949,10933946,10935835,10935832,10935830,10935828,10935825,10935823,10935821,10935819,10935815,10935814,10935811,10935809,10935802,10935800,10935797,10935794,10935792,10935790,10935788,10935786,10933943,10933939,10933932,10933926,10933919,10933917,10933915,10933913,10933911,10933906,10933905,10933902,10933900,10933898,10933895,10933891,10933887,10933885,10933883,10933881,10933878,10933876,10933871,10933866,10933861,10933857,10933856,10933854,10933852,10933849,10933846,10933844,10933841,10933839,10933832,10933830,10933828,10933826,10933824,10933822,10933819,10933818,10933816,10933814,10933811,10933808,10933806,10933803,10933801,10933800,10933797,10933794,10933791,10933788,10933785,10933780,10933775,10933772,10933768,10933766,10933763,10933760,10933756,10933753,10933751,10933747,10933743,10933740,10933736,10933734,10933731,10933728,10933725,10933722,10933718,10933715,10933712,10933709,10933705,10933702,10933698,10933695,10933691,10933688,10933686,10933685,10933683,10933679,10933677,10933675,10933672,10933670,10933667,10933664,10445856,10074131,9929840,9922720,9922608,9907728,9907557,9874189,9857369,9856494,9832218,9478797,9458104,9456477,9259405,9191384,9146337,9068954,9068773,8992718,8964860,8962928,8961301,8960938,8941478,8890653,8888968,8837342,8782727,8738780,8600523,8597773,8287082,8234777,8179438,7643378,7643059,7600709,7547318,7511745,7255377,7255159,7220904,7214731,7165305,7165160,7161104,6929523,6900068,6587474,6587084,6586292,6584696,6370914,6356661,6315879,6310317,6261410,6254872,6219622,6217337,6212840,5955145,5913489,5799798,5772734,5768588,5767294,5675172,5675031,5666124,5665155,5498376,5497830,5443852,5312087,5196769,5190978,5190440,5165457,5160179,5156158,4946378,4923326,4897367,4896086,4892202,4865062,4840477,4840398,4840142,4839246,4768994,4768633,4768123,4766246,4745571,4733218,4448210,4448181,4150880,4125613,2549546,2549545,2191781,2191780,2029015,2028434,2028246}'::integer[]))
   Heap Fetches: 384
   Buffers: shared hit=3602
   I/O Timings: read=0.000 write=0.000

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

 Index Scan using namespaces_pkey on public.namespaces  (cost=0.43..3.46 rows=1 width=357) (actual time=0.036..0.037 rows=1 loops=1)
   Index Cond: (namespaces.id = 38109)
   Filter: ((namespaces.type)::text = 'Group'::text)
   Rows Removed by Filter: 0
   Buffers: shared hit=4
   I/O Timings: read=0.000 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 #349897 (closed)

Edited by Pedro Pombeiro (OOO from July 16th till Aug 7th)

Merge request reports