Improve environments queries for performance

Signed-off-by: Takuya Noguchi <takninnovationresearch@gmail.com>
137 jobs for 58660-projects-environments-json-performance in 77 minutes and 34 seconds (queued for 26 seconds)
latest
Status Job ID Name Coverage
  Prepare
passed #176798132
gitlab-org
compile-assets

00:07:06

passed #176798131
gitlab-org
retrieve-tests-metadata

00:00:24

passed #176798134
gitlab-org
setup-test-env

00:08:02

 
  Test
passed #176798353
allowed to fail
code_quality

00:09:53

passed #176798320
gitlab-org
db:check-schema-pg

00:05:02

passed #176798319
gitlab-org
db:migrate:reset-mysql

00:13:32

passed #176798318
gitlab-org
db:migrate:reset-pg

00:05:46

passed #176798326
gitlab-org
db:rollback-mysql

00:06:27

passed #176798323
gitlab-org
db:rollback-pg

00:04:00

passed #176798355
allowed to fail
dependency_scanning

00:04:26

passed #176798315
gitlab-org
docs lint

00:02:08

passed #176798316
gitlab-org
downtime_check

00:04:44

passed #176798317
gitlab-org
ee_compat_check

00:05:42

passed #176798335
gitlab-org
gitlab:setup-mysql

00:06:24

passed #176798333
gitlab-org
gitlab:setup-pg

00:07:46

passed #176798338
gitlab-org allowed to fail
gitlab:ui:visual

00:04:45

passed #176798364
gitlab-org
gitlab_git_test

00:00:31

passed #176798351
gitlab-org
jest

00:09:32

passed #176798346
gitlab-org
karma

00:14:03

58.71%
passed #176798322
gitlab-org
migration:path-mysql

00:13:56

passed #176798321
gitlab-org
migration:path-pg

00:12:19

passed #176798362
gitlab-org
qa-frontend-node:10

00:08:15

passed #176798360
gitlab-org
qa-frontend-node:8

00:08:06

passed #176798363
gitlab-org allowed to fail
qa-frontend-node:latest

00:13:55

passed #176798356
gitlab-org
qa:internal

00:04:14

passed #176798357
gitlab-org
qa:selectors

00:04:10

passed #176798253
gitlab-org
rspec-mysql 1/50

00:17:28

passed #176798262
gitlab-org
rspec-mysql 10/50

00:25:08

passed #176814840
gitlab-org
rspec-mysql 11/50

00:24:56

passed #176798264
gitlab-org
rspec-mysql 12/50

00:17:59

passed #176798265
gitlab-org
rspec-mysql 13/50

00:17:22

passed #176798266
gitlab-org
rspec-mysql 14/50

00:17:34

passed #176798267
gitlab-org
rspec-mysql 15/50

00:19:24

passed #176798268
gitlab-org
rspec-mysql 16/50

00:19:37

passed #176798269
gitlab-org
rspec-mysql 17/50

00:19:20

passed #176798270
gitlab-org
rspec-mysql 18/50

00:18:16

passed #176798271
gitlab-org
rspec-mysql 19/50

00:21:32

passed #176798254
gitlab-org
rspec-mysql 2/50

00:16:13

passed #176798272
gitlab-org
rspec-mysql 20/50

00:23:56

passed #176798273
gitlab-org
rspec-mysql 21/50

00:21:16

passed #176798274
gitlab-org
rspec-mysql 22/50

00:17:20

passed #176798275
gitlab-org
rspec-mysql 23/50

00:21:04

passed #176798276
gitlab-org
rspec-mysql 24/50

00:19:02

passed #176798277
gitlab-org
rspec-mysql 25/50

00:17:47

passed #176798278
gitlab-org
rspec-mysql 26/50

00:20:51

passed #176798280
gitlab-org
rspec-mysql 27/50

00:19:44

passed #176798282
gitlab-org
rspec-mysql 28/50

00:21:09

passed #176798284
gitlab-org
rspec-mysql 29/50

00:19:09

passed #176798255
gitlab-org
rspec-mysql 3/50

00:16:00

passed #176798286
gitlab-org
rspec-mysql 30/50

00:19:08

passed #176798287
gitlab-org
rspec-mysql 31/50

00:17:39

passed #176798288
gitlab-org
rspec-mysql 32/50

00:20:15

passed #176798289
gitlab-org
rspec-mysql 33/50

00:16:19

passed #176798290
gitlab-org
rspec-mysql 34/50

00:17:32

passed #176798291
gitlab-org
rspec-mysql 35/50

00:18:56

passed #176798292
gitlab-org
rspec-mysql 36/50

00:15:48

passed #176798293
gitlab-org
rspec-mysql 37/50

00:20:38

passed #176798294
gitlab-org
rspec-mysql 38/50

00:21:06

passed #176798295
gitlab-org
rspec-mysql 39/50

00:17:21

passed #176798256
gitlab-org
rspec-mysql 4/50

00:16:30

passed #176798296
gitlab-org
rspec-mysql 40/50

00:18:25

passed #176798297
gitlab-org
rspec-mysql 41/50

00:19:14

passed #176798299
gitlab-org
rspec-mysql 42/50

00:25:10

passed #176798300
gitlab-org
rspec-mysql 43/50

00:19:59

passed #176798301
gitlab-org
rspec-mysql 44/50

00:16:51

passed #176798303
gitlab-org
rspec-mysql 45/50

00:21:40

passed #176798305
gitlab-org
rspec-mysql 46/50

00:20:43

passed #176798306
gitlab-org
rspec-mysql 47/50

00:24:04

passed #176798308
gitlab-org
rspec-mysql 48/50

00:16:52

passed #176798309
gitlab-org
rspec-mysql 49/50

00:17:41

passed #176798257
gitlab-org
rspec-mysql 5/50

00:15:39

passed #176798310
gitlab-org
rspec-mysql 50/50

00:22:06

passed #176798258
gitlab-org
rspec-mysql 6/50

00:26:27

passed #176798259
gitlab-org
rspec-mysql 7/50

00:18:18

passed #176798260
gitlab-org
rspec-mysql 8/50

00:15:02

passed #176798261
gitlab-org
rspec-mysql 9/50

00:22:26

passed #176798312
gitlab-org allowed to fail
rspec-mysql-quarantine

00:09:02

passed #176798137
gitlab-org
rspec-pg 1/50

00:21:10

passed #176798154
gitlab-org
rspec-pg 10/50

00:28:33

passed #176798155
gitlab-org
rspec-pg 11/50

00:27:42

passed #176798156
gitlab-org
rspec-pg 12/50

00:19:55

passed #176798158
gitlab-org
rspec-pg 13/50

00:18:34

passed #176798160
gitlab-org
rspec-pg 14/50

00:17:18

passed #176798162
gitlab-org
rspec-pg 15/50

00:17:57

passed #176798164
gitlab-org
rspec-pg 16/50

00:16:29

passed #176798165
gitlab-org
rspec-pg 17/50

00:20:37

passed #176798166
gitlab-org
rspec-pg 18/50

00:17:40

passed #176798167
gitlab-org
rspec-pg 19/50

00:22:57

passed #176798139
gitlab-org
rspec-pg 2/50

00:18:02

passed #176798168
gitlab-org
rspec-pg 20/50

00:21:29

passed #176798169
gitlab-org
rspec-pg 21/50

00:19:37

passed #176798171
gitlab-org
rspec-pg 22/50

00:16:59

passed #176798178
gitlab-org
rspec-pg 23/50

00:19:01

passed #176798182
gitlab-org
rspec-pg 24/50

00:19:21

passed #176798185
gitlab-org
rspec-pg 25/50

00:19:58

passed #176798194
gitlab-org
rspec-pg 26/50

00:18:35

passed #176798199
gitlab-org
rspec-pg 27/50

00:21:45

passed #176798203
gitlab-org
rspec-pg 28/50

00:18:24

passed #176798207
gitlab-org
rspec-pg 29/50

00:17:49

passed #176798142
gitlab-org
rspec-pg 3/50

00:14:14

passed #176798209
gitlab-org
rspec-pg 30/50

00:21:48

passed #176798210
gitlab-org
rspec-pg 31/50

00:19:42

passed #176798211
gitlab-org
rspec-pg 32/50

00:20:15

passed #176798214
gitlab-org
rspec-pg 33/50

00:18:14

passed #176798215
gitlab-org
rspec-pg 34/50

00:17:02

passed #176798217
gitlab-org
rspec-pg 35/50

00:21:37

passed #176798219
gitlab-org
rspec-pg 36/50

00:16:07

passed #176798220
gitlab-org
rspec-pg 37/50

00:17:16

passed #176798221
gitlab-org
rspec-pg 38/50

00:22:01

passed #176798222
gitlab-org
rspec-pg 39/50

00:23:03

passed #176798144
gitlab-org
rspec-pg 4/50

00:15:28

passed #176798223
gitlab-org
rspec-pg 40/50

00:17:59

passed #176798226
gitlab-org
rspec-pg 41/50

00:20:50

passed #176798229
gitlab-org
rspec-pg 42/50

00:20:40

passed #176798234
gitlab-org
rspec-pg 43/50

00:20:48

passed #176798243
gitlab-org
rspec-pg 44/50

00:18:14

passed #176798245
gitlab-org
rspec-pg 45/50

00:21:22

passed #176798246
gitlab-org
rspec-pg 46/50

00:20:42

passed #176798248
gitlab-org
rspec-pg 47/50

00:21:07

passed #176798250
gitlab-org
rspec-pg 48/50

00:20:21

passed #176798251
gitlab-org
rspec-pg 49/50

00:19:33

passed #176798145
gitlab-org
rspec-pg 5/50

00:14:49

passed #176798252
gitlab-org
rspec-pg 50/50

00:23:03

passed #176798146
gitlab-org
rspec-pg 6/50

00:24:49

passed #176798147
gitlab-org
rspec-pg 7/50

00:15:57

passed #176798151
gitlab-org
rspec-pg 8/50

00:17:05

passed #176798153
gitlab-org
rspec-pg 9/50

00:19:46

passed #176798311
gitlab-org allowed to fail
rspec-pg-quarantine

00:11:44

failed #176913396
allowed to fail
sast

00:25:01

passed #176798313
gitlab-org
static-analysis

00:12:24

failed #176798263
gitlab-org
rspec-mysql 11/50

00:05:45

failed #176798354
allowed to fail
sast

00:24:35

failed #176864591
allowed to fail
sast

00:24:53

 
  Post Test
passed #176798367
gitlab-org
coverage

00:06:30

95.22%
passed #176798365
gitlab-org allowed to fail
flaky-examples-check

00:01:53

passed #176798370
gitlab-org
jsdoc

00:04:40

passed #176798369
gitlab-org
lint:javascript:report

00:04:01

 
Name Stage Failure
failed
sast Test
2019/03/13 14:32:18 Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?
2019/03/13 14:32:18 Timeout when running the analyzer
Running after script...
$ date
Wed Mar 13 14:32:21 UTC 2019
Uploading artifacts...
WARNING: gl-sast-report.json: no matching files
ERROR: No files to upload
ERROR: Job failed: exit code 1