[DevopsAdoption] Add dependency scanning to Devops Adoption API (!64624) · Merge requests · GitLab.org / GitLab

Pavel Shutsin requested to merge 326146-add-dependency-scanning-to-adoption-table into master Jun 22, 2021

What does this MR do?

Adds new metric to Devops Adoption API

Migration output

== 20210621111747 AddCiArtifactsDevopsAdoptionIndex: reverting ================
-- transaction_open?()
   -> 0.0000s
-- indexes(:ci_job_artifacts)
   -> 0.0241s
-- remove_index(:ci_job_artifacts, {:algorithm=>:concurrently, :name=>"index_ci_job_artifacts_on_file_type_for_devops_adoption"})
   -> 0.0037s
== 20210621111747 AddCiArtifactsDevopsAdoptionIndex: reverted (0.0896s) =======

== 20210621091830 AddDevopsAdoptionSnapshotDependencyScanning: reverting ======
-- remove_column(:analytics_devops_adoption_snapshots, :dependency_scanning_enabled_count, :integer)
   -> 0.0075s
== 20210621091830 AddDevopsAdoptionSnapshotDependencyScanning: reverted (0.0100s)

== 20210621091830 AddDevopsAdoptionSnapshotDependencyScanning: migrating ======
-- add_column(:analytics_devops_adoption_snapshots, :dependency_scanning_enabled_count, :integer)
   -> 0.0088s
== 20210621091830 AddDevopsAdoptionSnapshotDependencyScanning: migrated (0.0089s)

== 20210621111747 AddCiArtifactsDevopsAdoptionIndex: migrating ================
-- transaction_open?()
   -> 0.0000s
-- index_exists?(:ci_job_artifacts, [:file_type, :project_id, :created_at], {:name=>"index_ci_job_artifacts_on_file_type_for_devops_adoption", :where=>"file_type IN (5,6,8,23)", :algorithm=>:concurrently})
   -> 0.0193s
-- add_index(:ci_job_artifacts, [:file_type, :project_id, :created_at], {:name=>"index_ci_job_artifacts_on_file_type_for_devops_adoption", :where=>"file_type IN (5,6,8,23)", :algorithm=>:concurrently})
   -> 0.0097s
== 20210621111747 AddCiArtifactsDevopsAdoptionIndex: migrated (0.0888s) =======

Affected queries

DAST

 Aggregate  (cost=1976.43..1976.44 rows=1 width=8) (actual time=19.120..19.122 rows=1 loops=1)
   Buffers: shared hit=11869
   I/O Timings: read=0.000 write=0.000
   ->  Merge Semi Join  (cost=0.99..1976.42 rows=1 width=0) (actual time=0.607..19.109 rows=12 loops=1)
         Merge Cond: (projects.id = ci_job_artifacts.project_id)
         Buffers: shared hit=11869
         I/O Timings: read=0.000 write=0.000
         ->  Index Only Scan using idx_projects_on_repository_storage_last_repository_updated_at on public.projects  (cost=0.56..1365.73 rows=654 width=4) (actual time=0.163..3.574 rows=652 loops=1)
               Index Cond: (projects.id = ANY ('{278964,11520423,11574953,13348998,13664986,14097509,14645774,14921629,15477483,15572444,15662771,15704782,16239404,16513043,16700143,17181705,17210811,17743501,18925373,18977208,19042106,19402176,19532875,20401626,20867992,21224328,21483460,21734866,21740210,22133520,22907418,23601234,23944319,24134396,24200638,24763979,25534115,26630862,24693199,25567144,13083,13764,14022,14288,14289,16648,19776,20085,20086,20699,23081,27468,27470,27726,29286,32732,36743,72724,74823,83282,95156,98024,116212,140724,143237,145205,150440,227582,250324,250833,278964,280425,375711,387896,430285,443787,444821,455030,480929,554859,593728,629054,629060,684698,730448,734943,747741,766015,818896,876090,887372,928825,931715,998792,1075790,1120019,1209837,1265999,1329047,1379171,1441932,1470839,1507906,1533158,1777822,1794617,1911766,1990920,2009901,2127625,2317465,2337675,2347063,2383700,2651596,2670515,2694799,2725567,2890326,2903741,2953390,3010986,3010998,3094319,3101096,3305972,3362933,3430480,3466815,3588247,3605985,3631141,3651684,3662568,3662668,3674569,3698388,3871132,3871556,3885956,3885980,3933206,3933372,3991945,4108541,4121724,4149988,4157550,4176070,4186738,4186742,4262096,4341757,4382108,4534254,4542834,4562632,4870361,4921652,4949400,5019307,5261717,5420758,5647182,5981322,6043225,6043227,6092883,6185025,6457868,6466002,7071551,7540679,7602162,7792567,7937396,8343284,8362868,8671969,8987255,9134345,9149724,9359704,9438583,9492132,9780400,9927571,10024275,10614162,10619765,10786772,10947578,11047304,11067315,11080193,11261137,11446522,11997420,12051824,12104213,12212610,12274094,12425329,13015884,13053017,13284652,13368043,13453461,13473820,13683636,13831684,13942461,13997108,14018700,14025202,14071101,14146123,14217204,14290884,14378900,14520336,14694517,14707715,14771920,14785608,14850988,15032634,15158038,15297693,15363819,15420077,15445353,15447440,15461649,15502498,15687385,15815706,15816248,15943672,16110032,16505341,16573099,16603968,16732333,16842968,17039597,17113313,17133307,17318793,17334694,17345914,17429946,17522813,17661412,17930014,18060348,18307741,18307889,18331927,18594323,18594390,18629149,18741849,18776356,18860383,18863350,18893322,18912995,18943607,19031064,19461377,19657914,19861191,20059805,20326496,20468480,20510065,20904766,21250701,21439066,21479995,21565866,21751536,21751817,21808150,21819002,21967079,21967100,22217400,22363055,22795840,22874770,23105702,23156104,23176166,23617987,23627092,23838512,23854438,24467497,24671550,24873101,25031023,25033712,25205782,25312761,25398815,25402115,25416006,25417540,25418438,25837735,25847700,25861038,25981420,26130408,26250592,26576566,26744820,27244047,27490309,22351703,9281155,16302012,17843116,15114652,19722963,19969997,20352787,15065439,16552062,16706750,17192985,19533665,20376798,4359271,7682093,14588374,19310217,20085049,8377576,10071001,10071132,19974437,22438483,25691329,17349153,13017970,13017990,13018017,16488249,16756957,18641703,22414284,19922160,13815397,21324924,21628863,23544263,5677844,10523039,14402567,15962657,16297627,19551890,20842531,22850480,24345542,9184510,10400718,11688089,14404642,15828516,19019153,21764500,22517790,15019630,21635031,22487050,23203100,23344605,23586678,10747057,13142177,21055520,18256369,21055609,9237774,12558964,13017629,16863027,17616536,18256375,25838334,25839455,25840330,25840667,27079314,19043830,21731412,21731462,22046463,22070439,22382594,22408078,22409005,22413375,25944737,19890267,23069693,23069956,23070140,23070164,23070377,23070395,23176783,23176971,23505725,23599168,24302484,24313398,24313598,24317064,24460210,24542363,24544020,24544330,25230764,25298439,25537666,25538517,25560556,25829938,26217586,26217656,26549908,26598766,26638651,26808701,26808774,26882341,26882878,26997949,21055409,3828396,6329679,7453181,11915984,14372596,15393051,16590122,17253921,18439881,18663049,18991900,21525059,23495190,21055344,19800404,21055767,20209910,22215226,22336999,22390221,20110067,20744986,15412762,15499610,19936368,13490286,13672316,13672681,13673582,13673632,13673686,13673757,13673934,13674085,13674136,13675927,13675979,13676002,13676032,13676096,13676142,13676188,13676249,13676309,13676350,13824926,16613296,16622651,16819118,16819125,16819131,16819134,16819140,16819151,16819248,17023897,17043690,17134833,17530059,17821569,17823896,18770944,18789638,18792504,19290493,19290857,19315261,20498312,23508645,17863546,19209142,19245461,17257555,21824450,24339834,20466430,17584993,24470059,16816732,17311004,17433833,18759998,18760252,19265543,19536993,20516845,20747799,20791019,20916876,21573386,21796485,22249364,22566258,22637103,23597027,23690656,23730491,23916841,24300893,24451242,24501533,25158783,25247374,26079419,26584477,26815390,27209445,19843335,20623750,22679171,22734535,26566881,27214210,27219974,27226337,27227767,27229445,6374580,6374588,6374596,22810929,22810940,22811022,23928229,17245095,17990319,18208929,18766749,18976211,19279270,19568296,19655424,19993243,20081132,20630561,20839085,21649753,22847718,23512541,23526204,25969582,18855526,27051617,27051800,27286937,27484836,27484846,27484871,24907469,25216298,27494514,26615930,26615960,26616051,26616061,26616069,26698878,26699071,26699200,26710947,27209463,27220296,27221011,27456355,27456706,27456810,27457647,18899486,27260823,27261025,21573444,23101765,23740056,27213646,27327788,18256394,13954053,14130725,16549277,21486653,18899500,22848448,9172481,10947320,12507547,15486630,15926775,20360386,14392833,16913647,18156681,18875792,19028203,19720958,22130851,22433156,23345837,12138769,12959103,13327609,13437682,15710326,16466244,17966464,20107267,25891188,18406509,18922546,18650560,18766720}'::integer[]))
               Heap Fetches: 76
               Buffers: shared hit=3298
               I/O Timings: read=0.000 write=0.000
         ->  Index Only Scan using tmp_index on public.ci_job_artifacts  (cost=0.43..606.94 rows=1680 width=4) (actual time=0.249..14.610 rows=7529 loops=1)
               Index Cond: ((ci_job_artifacts.file_type = 8) AND (ci_job_artifacts.created_at >= '2021-06-01 00:00:00+00'::timestamp with time zone) AND (ci_job_artifacts.created_at <= '2021-06-30 23:59:59.999999+00'::timestamp with time zone))
               Heap Fetches: 3440
               Buffers: shared hit=8571
               I/O Timings: read=0.000 write=0.000

SAST

Aggregate  (cost=2706.08..2706.09 rows=1 width=8) (actual time=28.143..28.145 rows=1 loops=1)
   Buffers: shared hit=4773 read=546 dirtied=6
   I/O Timings: read=14.023 write=0.000
   ->  Nested Loop Semi Join  (cost=0.99..2706.07 rows=5 width=0) (actual time=0.435..28.113 rows=49 loops=1)
         Buffers: shared hit=4773 read=546 dirtied=6
         I/O Timings: read=14.023 write=0.000
         ->  Index Only Scan using idx_projects_on_repository_storage_last_repository_updated_at on public.projects  (cost=0.56..1365.73 rows=654 width=4) (actual time=0.164..10.839 rows=652 loops=1)
               Index Cond: (projects.id = ANY ('{278964,11520423,11574953,13348998,13664986,14097509,14645774,14921629,15477483,15572444,15662771,15704782,16239404,16513043,16700143,17181705,17210811,17743501,18925373,18977208,19042106,19402176,19532875,20401626,20867992,21224328,21483460,21734866,21740210,22133520,22907418,23601234,23944319,24134396,24200638,24763979,25534115,26630862,24693199,25567144,13083,13764,14022,14288,14289,16648,19776,20085,20086,20699,23081,27468,27470,27726,29286,32732,36743,72724,74823,83282,95156,98024,116212,140724,143237,145205,150440,227582,250324,250833,278964,280425,375711,387896,430285,443787,444821,455030,480929,554859,593728,629054,629060,684698,730448,734943,747741,766015,818896,876090,887372,928825,931715,998792,1075790,1120019,1209837,1265999,1329047,1379171,1441932,1470839,1507906,1533158,1777822,1794617,1911766,1990920,2009901,2127625,2317465,2337675,2347063,2383700,2651596,2670515,2694799,2725567,2890326,2903741,2953390,3010986,3010998,3094319,3101096,3305972,3362933,3430480,3466815,3588247,3605985,3631141,3651684,3662568,3662668,3674569,3698388,3871132,3871556,3885956,3885980,3933206,3933372,3991945,4108541,4121724,4149988,4157550,4176070,4186738,4186742,4262096,4341757,4382108,4534254,4542834,4562632,4870361,4921652,4949400,5019307,5261717,5420758,5647182,5981322,6043225,6043227,6092883,6185025,6457868,6466002,7071551,7540679,7602162,7792567,7937396,8343284,8362868,8671969,8987255,9134345,9149724,9359704,9438583,9492132,9780400,9927571,10024275,10614162,10619765,10786772,10947578,11047304,11067315,11080193,11261137,11446522,11997420,12051824,12104213,12212610,12274094,12425329,13015884,13053017,13284652,13368043,13453461,13473820,13683636,13831684,13942461,13997108,14018700,14025202,14071101,14146123,14217204,14290884,14378900,14520336,14694517,14707715,14771920,14785608,14850988,15032634,15158038,15297693,15363819,15420077,15445353,15447440,15461649,15502498,15687385,15815706,15816248,15943672,16110032,16505341,16573099,16603968,16732333,16842968,17039597,17113313,17133307,17318793,17334694,17345914,17429946,17522813,17661412,17930014,18060348,18307741,18307889,18331927,18594323,18594390,18629149,18741849,18776356,18860383,18863350,18893322,18912995,18943607,19031064,19461377,19657914,19861191,20059805,20326496,20468480,20510065,20904766,21250701,21439066,21479995,21565866,21751536,21751817,21808150,21819002,21967079,21967100,22217400,22363055,22795840,22874770,23105702,23156104,23176166,23617987,23627092,23838512,23854438,24467497,24671550,24873101,25031023,25033712,25205782,25312761,25398815,25402115,25416006,25417540,25418438,25837735,25847700,25861038,25981420,26130408,26250592,26576566,26744820,27244047,27490309,22351703,9281155,16302012,17843116,15114652,19722963,19969997,20352787,15065439,16552062,16706750,17192985,19533665,20376798,4359271,7682093,14588374,19310217,20085049,8377576,10071001,10071132,19974437,22438483,25691329,17349153,13017970,13017990,13018017,16488249,16756957,18641703,22414284,19922160,13815397,21324924,21628863,23544263,5677844,10523039,14402567,15962657,16297627,19551890,20842531,22850480,24345542,9184510,10400718,11688089,14404642,15828516,19019153,21764500,22517790,15019630,21635031,22487050,23203100,23344605,23586678,10747057,13142177,21055520,18256369,21055609,9237774,12558964,13017629,16863027,17616536,18256375,25838334,25839455,25840330,25840667,27079314,19043830,21731412,21731462,22046463,22070439,22382594,22408078,22409005,22413375,25944737,19890267,23069693,23069956,23070140,23070164,23070377,23070395,23176783,23176971,23505725,23599168,24302484,24313398,24313598,24317064,24460210,24542363,24544020,24544330,25230764,25298439,25537666,25538517,25560556,25829938,26217586,26217656,26549908,26598766,26638651,26808701,26808774,26882341,26882878,26997949,21055409,3828396,6329679,7453181,11915984,14372596,15393051,16590122,17253921,18439881,18663049,18991900,21525059,23495190,21055344,19800404,21055767,20209910,22215226,22336999,22390221,20110067,20744986,15412762,15499610,19936368,13490286,13672316,13672681,13673582,13673632,13673686,13673757,13673934,13674085,13674136,13675927,13675979,13676002,13676032,13676096,13676142,13676188,13676249,13676309,13676350,13824926,16613296,16622651,16819118,16819125,16819131,16819134,16819140,16819151,16819248,17023897,17043690,17134833,17530059,17821569,17823896,18770944,18789638,18792504,19290493,19290857,19315261,20498312,23508645,17863546,19209142,19245461,17257555,21824450,24339834,20466430,17584993,24470059,16816732,17311004,17433833,18759998,18760252,19265543,19536993,20516845,20747799,20791019,20916876,21573386,21796485,22249364,22566258,22637103,23597027,23690656,23730491,23916841,24300893,24451242,24501533,25158783,25247374,26079419,26584477,26815390,27209445,19843335,20623750,22679171,22734535,26566881,27214210,27219974,27226337,27227767,27229445,6374580,6374588,6374596,22810929,22810940,22811022,23928229,17245095,17990319,18208929,18766749,18976211,19279270,19568296,19655424,19993243,20081132,20630561,20839085,21649753,22847718,23512541,23526204,25969582,18855526,27051617,27051800,27286937,27484836,27484846,27484871,24907469,25216298,27494514,26615930,26615960,26616051,26616061,26616069,26698878,26699071,26699200,26710947,27209463,27220296,27221011,27456355,27456706,27456810,27457647,18899486,27260823,27261025,21573444,23101765,23740056,27213646,27327788,18256394,13954053,14130725,16549277,21486653,18899500,22848448,9172481,10947320,12507547,15486630,15926775,20360386,14392833,16913647,18156681,18875792,19028203,19720958,22130851,22433156,23345837,12138769,12959103,13327609,13437682,15710326,16466244,17966464,20107267,25891188,18406509,18922546,18650560,18766720}'::integer[]))
               Heap Fetches: 76
               Buffers: shared hit=3298
               I/O Timings: read=0.000 write=0.000
         ->  Index Only Scan using tmp_index on public.ci_job_artifacts  (cost=0.43..2.05 rows=1 width=4) (actual time=0.026..0.026 rows=0 loops=652)
               Index Cond: ((ci_job_artifacts.file_type = 5) AND (ci_job_artifacts.project_id = projects.id) AND (ci_job_artifacts.created_at >= '2021-06-01 00:00:00+00'::timestamp with time zone) AND (ci_job_artifacts.created_at <= '2021-06-30 23:59:59.999999+00'::timestamp with time zone))
               Heap Fetches: 25
               Buffers: shared hit=1475 read=546 dirtied=6
               I/O Timings: read=14.023 write=0.000

Dependency scanning

 Aggregate  (cost=2707.47..2707.48 rows=1 width=8) (actual time=25.195..25.197 rows=1 loops=1)
   Buffers: shared hit=4827 read=458 dirtied=4
   I/O Timings: read=16.121 write=0.000
   ->  Nested Loop Semi Join  (cost=0.99..2707.47 rows=3 width=0) (actual time=0.330..25.164 rows=32 loops=1)
         Buffers: shared hit=4827 read=458 dirtied=4
         I/O Timings: read=16.121 write=0.000
         ->  Index Only Scan using idx_projects_on_repository_storage_last_repository_updated_at on public.projects  (cost=0.56..1365.73 rows=654 width=4) (actual time=0.150..5.901 rows=652 loops=1)
               Index Cond: (projects.id = ANY ('{278964,11520423,11574953,13348998,13664986,14097509,14645774,14921629,15477483,15572444,15662771,15704782,16239404,16513043,16700143,17181705,17210811,17743501,18925373,18977208,19042106,19402176,19532875,20401626,20867992,21224328,21483460,21734866,21740210,22133520,22907418,23601234,23944319,24134396,24200638,24763979,25534115,26630862,24693199,25567144,13083,13764,14022,14288,14289,16648,19776,20085,20086,20699,23081,27468,27470,27726,29286,32732,36743,72724,74823,83282,95156,98024,116212,140724,143237,145205,150440,227582,250324,250833,278964,280425,375711,387896,430285,443787,444821,455030,480929,554859,593728,629054,629060,684698,730448,734943,747741,766015,818896,876090,887372,928825,931715,998792,1075790,1120019,1209837,1265999,1329047,1379171,1441932,1470839,1507906,1533158,1777822,1794617,1911766,1990920,2009901,2127625,2317465,2337675,2347063,2383700,2651596,2670515,2694799,2725567,2890326,2903741,2953390,3010986,3010998,3094319,3101096,3305972,3362933,3430480,3466815,3588247,3605985,3631141,3651684,3662568,3662668,3674569,3698388,3871132,3871556,3885956,3885980,3933206,3933372,3991945,4108541,4121724,4149988,4157550,4176070,4186738,4186742,4262096,4341757,4382108,4534254,4542834,4562632,4870361,4921652,4949400,5019307,5261717,5420758,5647182,5981322,6043225,6043227,6092883,6185025,6457868,6466002,7071551,7540679,7602162,7792567,7937396,8343284,8362868,8671969,8987255,9134345,9149724,9359704,9438583,9492132,9780400,9927571,10024275,10614162,10619765,10786772,10947578,11047304,11067315,11080193,11261137,11446522,11997420,12051824,12104213,12212610,12274094,12425329,13015884,13053017,13284652,13368043,13453461,13473820,13683636,13831684,13942461,13997108,14018700,14025202,14071101,14146123,14217204,14290884,14378900,14520336,14694517,14707715,14771920,14785608,14850988,15032634,15158038,15297693,15363819,15420077,15445353,15447440,15461649,15502498,15687385,15815706,15816248,15943672,16110032,16505341,16573099,16603968,16732333,16842968,17039597,17113313,17133307,17318793,17334694,17345914,17429946,17522813,17661412,17930014,18060348,18307741,18307889,18331927,18594323,18594390,18629149,18741849,18776356,18860383,18863350,18893322,18912995,18943607,19031064,19461377,19657914,19861191,20059805,20326496,20468480,20510065,20904766,21250701,21439066,21479995,21565866,21751536,21751817,21808150,21819002,21967079,21967100,22217400,22363055,22795840,22874770,23105702,23156104,23176166,23617987,23627092,23838512,23854438,24467497,24671550,24873101,25031023,25033712,25205782,25312761,25398815,25402115,25416006,25417540,25418438,25837735,25847700,25861038,25981420,26130408,26250592,26576566,26744820,27244047,27490309,22351703,9281155,16302012,17843116,15114652,19722963,19969997,20352787,15065439,16552062,16706750,17192985,19533665,20376798,4359271,7682093,14588374,19310217,20085049,8377576,10071001,10071132,19974437,22438483,25691329,17349153,13017970,13017990,13018017,16488249,16756957,18641703,22414284,19922160,13815397,21324924,21628863,23544263,5677844,10523039,14402567,15962657,16297627,19551890,20842531,22850480,24345542,9184510,10400718,11688089,14404642,15828516,19019153,21764500,22517790,15019630,21635031,22487050,23203100,23344605,23586678,10747057,13142177,21055520,18256369,21055609,9237774,12558964,13017629,16863027,17616536,18256375,25838334,25839455,25840330,25840667,27079314,19043830,21731412,21731462,22046463,22070439,22382594,22408078,22409005,22413375,25944737,19890267,23069693,23069956,23070140,23070164,23070377,23070395,23176783,23176971,23505725,23599168,24302484,24313398,24313598,24317064,24460210,24542363,24544020,24544330,25230764,25298439,25537666,25538517,25560556,25829938,26217586,26217656,26549908,26598766,26638651,26808701,26808774,26882341,26882878,26997949,21055409,3828396,6329679,7453181,11915984,14372596,15393051,16590122,17253921,18439881,18663049,18991900,21525059,23495190,21055344,19800404,21055767,20209910,22215226,22336999,22390221,20110067,20744986,15412762,15499610,19936368,13490286,13672316,13672681,13673582,13673632,13673686,13673757,13673934,13674085,13674136,13675927,13675979,13676002,13676032,13676096,13676142,13676188,13676249,13676309,13676350,13824926,16613296,16622651,16819118,16819125,16819131,16819134,16819140,16819151,16819248,17023897,17043690,17134833,17530059,17821569,17823896,18770944,18789638,18792504,19290493,19290857,19315261,20498312,23508645,17863546,19209142,19245461,17257555,21824450,24339834,20466430,17584993,24470059,16816732,17311004,17433833,18759998,18760252,19265543,19536993,20516845,20747799,20791019,20916876,21573386,21796485,22249364,22566258,22637103,23597027,23690656,23730491,23916841,24300893,24451242,24501533,25158783,25247374,26079419,26584477,26815390,27209445,19843335,20623750,22679171,22734535,26566881,27214210,27219974,27226337,27227767,27229445,6374580,6374588,6374596,22810929,22810940,22811022,23928229,17245095,17990319,18208929,18766749,18976211,19279270,19568296,19655424,19993243,20081132,20630561,20839085,21649753,22847718,23512541,23526204,25969582,18855526,27051617,27051800,27286937,27484836,27484846,27484871,24907469,25216298,27494514,26615930,26615960,26616051,26616061,26616069,26698878,26699071,26699200,26710947,27209463,27220296,27221011,27456355,27456706,27456810,27457647,18899486,27260823,27261025,21573444,23101765,23740056,27213646,27327788,18256394,13954053,14130725,16549277,21486653,18899500,22848448,9172481,10947320,12507547,15486630,15926775,20360386,14392833,16913647,18156681,18875792,19028203,19720958,22130851,22433156,23345837,12138769,12959103,13327609,13437682,15710326,16466244,17966464,20107267,25891188,18406509,18922546,18650560,18766720}'::integer[]))
               Heap Fetches: 76
               Buffers: shared hit=3298
               I/O Timings: read=0.000 write=0.000
         ->  Index Only Scan using tmp_index on public.ci_job_artifacts  (cost=0.43..2.05 rows=1 width=4) (actual time=0.029..0.029 rows=0 loops=652)
               Index Cond: ((ci_job_artifacts.file_type = 6) AND (ci_job_artifacts.project_id = projects.id) AND (ci_job_artifacts.created_at >= '2021-06-01 00:00:00+00'::timestamp with time zone) AND (ci_job_artifacts.created_at <= '2021-06-30 23:59:59.999999+00'::timestamp with time zone))
               Heap Fetches: 8
               Buffers: shared hit=1529 read=458 dirtied=4
               I/O Timings: read=16.121 write=0.000

Screenshots (strongly suggested)

Does this MR meet the acceptance criteria?

Conformity

I have included changelog trailers, or none are needed. (Does this MR need a changelog?)
I have added/updated documentation, or it's not needed. (Is documentation required?)
I have properly separated EE content from FOSS, or this MR is FOSS only. (Where should EE code go?)
I have added information for database reviewers in the MR description, or it's not needed. (Does this MR have database related changes?)
I have self-reviewed this MR per code review guidelines.
This MR does not harm performance, or I have asked a reviewer to help assess the performance impact. (Merge request performance guidelines)
I have followed the style guides.
This change is backwards compatible across updates, or this does not apply.

Availability and Testing

I have added/updated tests following the Testing Guide, or it's not needed. (Consider all test levels. See the Test Planning Process.)
I have tested this MR in all supported browsers, or it's not needed.
I have informed the Infrastructure department of a default or new setting change per definition of done, or it's not needed.

Security

Does this MR contain changes to processing or storing of credentials or tokens, authorization and authentication methods or other items described in the security review guidelines? If not, then delete this Security section.

Label as security and @ mention @gitlab-com/gl-security/appsec
The MR includes necessary changes to maintain consistency between UI, API, email, or other methods
Security reports checked/validated by a reviewer from the AppSec team

Related to #326146 (closed)

Edited Jul 02, 2021 by Pavel Shutsin

[DevopsAdoption] Add dependency scanning to Devops Adoption API