Skip to content

Resolve "Improve performance of Search API (Advanced): commits scope"

What does this MR do?

Issue #215708 (closed)

This MR adds some preloading for the Project object returned for each Commit during in Elastic Search results. What made this rather difficult is the fact that Commits are not ActiveRecord objects so the preload method could not work exactly the same.

The following fixes were added:

  1. A new scope in projects to load the required data for the commits scope (there was already some preloading being done in place within the code). That scope had to be passed down through a few methods to be able to be used where the preloading is already happening for the Project model.
  2. Modified CommitCollection accept container for commits -OR- pull the container for each commit in with_latest_pipeline method.
  3. Modified ::Ci::Pipeline latest_pipeline_per_commit to allow caller to specify whether results should also be grouped by a project_id key (and use that in CommitCollection.with_latest_pipeline
  4. Change the last_pipeline in the CommitDetailEntity to use latest_pipeline which will be preloaded.

Global Search - /api/v4/search?scope=commits&search=created

Before

79 queries
Started GET "/api/v4/search?scope=commits&search=created" for 127.0.0.1 at 2020-05-28 14:00:50 -0400
   (0.3ms)  SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp()))::float as lag
   app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
  ApplicationSetting Load (2.7ms)  SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT 1
  ↳ app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
  PersonalAccessToken Load (1.0ms)  SELECT "personal_access_tokens".* FROM "personal_access_tokens" WHERE "personal_access_tokens"."token_digest" = 'R27ZoLo1xAaezTWG/7z4uMnF9M8yUPN1lDKLEh0cQq4=' LIMIT 1
  ↳ app/models/concerns/token_authenticatable_strategies/digest.rb:8:in `find_token_authenticatable'
  User Load (2.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
   lib/gitlab/auth/auth_finders.rb:102:in `find_user_from_access_token'
   (0.4ms)  SELECT "features"."key" FROM "features"
  ↳ lib/feature.rb:13:in `feature_names'
  License Load (0.4ms)  SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT 100
  ↳ ee/app/models/license.rb:264:in `load_license'
  Repository Search (47.5ms) {index: "gitlab-development", type: "doc", body: {query: {bool: {must: {simple_query_string: {fields: ["commit.message^10", "commit.sha^5", "commit.author.name^2", "commit.author.email^2", "commit.committer.name", "commit.committer.email"], query: "created", default_operator: :and}}, filter: [{term: {"type"=>"commit"}}, {has_parent: {parent_type: "project", query: {bool: {should: [{exists: {field: "id"}}, {bool: {filter: [{term: {visibility_level: 20}}, {term: {"repository_access_level"=>20}}]}}, {bool: {filter: [{term: {visibility_level: 10}}, {term: {"repository_access_level"=>20}}]}}], must_not: {term: {"repository_access_level"=>0}}}}}}]}}, size: 20, from: 0, sort: [:_score]}}
  Project Load (2.8ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (3, 71, 73, 5, 8, 69, 77, 2, 78)
   ee/lib/elastic/latest/git_class_proxy.rb:203:in `yield_each_search_result'
  Route Load (0.6ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" IN (5, 71, 2, 3, 78, 77, 69, 8, 73)
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:203:in `yield_each_search_result'
  ProjectFeature Load (0.7ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 3 LIMIT 1
  ↳ app/policies/project_policy.rb:624:in `feature_available?'
  Group Load (1.6ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."type" = 'Group' LIMIT 1
   ee/app/policies/ee/project_policy.rb:333:in `block (2 levels) in <module:ProjectPolicy>'
  Group Load (0.5ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."parent_id" IS NULL LIMIT 1
  ↳ app/models/namespace.rb:285:in `block in root_ancestor'
  SamlProvider Load (0.4ms)  SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 23 LIMIT 1
  ↳ ee/lib/gitlab/auth/group_saml/sso_enforcer.rb:35:in `group_access_restricted?'
  ProjectFeature Load (0.2ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 71 LIMIT 1
   app/policies/project_policy.rb:624:in `feature_available?'
  ProjectFeature Load (0.2ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 5 LIMIT 1
  ↳ app/policies/project_policy.rb:624:in `feature_available?'
  ProjectFeature Load (0.3ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 2 LIMIT 1
  ↳ app/policies/project_policy.rb:624:in `feature_available?'
  ProjectFeature Load (0.2ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 78 LIMIT 1
   app/policies/project_policy.rb:624:in `feature_available?'
  Namespace Load (0.5ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23 LIMIT 1
  ↳ config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.2ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'
  Ci::Pipeline Load (1.9ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '01a1df91fcecac3c8fec9296b3b2df7c848d166a' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '01a1df91fcecac3c8fec9296b3b2df7c848d166a' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'e0452bc896e7043cf4fcbc3657b4d790b823971e' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'e0452bc896e7043cf4fcbc3657b4d790b823971e' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Namespace Load (0.4ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1
  ↳ config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.3ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 71 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '33e0d7613a36b27c8c6eacb4f66d30421666c848' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 71 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '33e0d7613a36b27c8c6eacb4f66d30421666c848' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Namespace Load (0.4ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1
  ↳ config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.3ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1
   app/models/concerns/routable.rb:77:in `full_path'
  ProjectFeature Load (0.4ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 73 LIMIT 1
  ↳ app/models/project.rb:353:in `builds_enabled?'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 73 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '33e0d7613a36b27c8c6eacb4f66d30421666c848' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 73 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '33e0d7613a36b27c8c6eacb4f66d30421666c848' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Namespace Load (0.4ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 25 LIMIT 1
  ↳ config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.3ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 25 AND "routes"."source_type" = 'Namespace' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '7cfd0f9fd7f4fcd464bbda0f5ae408ddd9970b84' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '7cfd0f9fd7f4fcd464bbda0f5ae408ddd9970b84' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '914593226e1f9afd5704cf24d1cefe7d792fa405' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '914593226e1f9afd5704cf24d1cefe7d792fa405' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Namespace Load (0.5ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 28 LIMIT 1
  ↳ config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.2ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 28 AND "routes"."source_type" = 'Namespace' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'
  ProjectFeature Load (0.2ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 8 LIMIT 1
   app/models/project.rb:353:in `builds_enabled?'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 8 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '33e0d7613a36b27c8c6eacb4f66d30421666c848' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 8 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '33e0d7613a36b27c8c6eacb4f66d30421666c848' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'b4074986793796c49f6e98dd9946d466378ea6c7' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (1.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'b4074986793796c49f6e98dd9946d466378ea6c7' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'd4187d16135a18cd19f41cf8281ec9e92a727642' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'd4187d16135a18cd19f41cf8281ec9e92a727642' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'deb157208109d255d84a554010e90d5f01533481' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'deb157208109d255d84a554010e90d5f01533481' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Namespace Load (0.4ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1
   config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.4ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'
  ProjectFeature Load (0.3ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 69 LIMIT 1
  ↳ app/models/project.rb:353:in `builds_enabled?'
  Ci::Pipeline Load (0.8ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 69 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '33e0d7613a36b27c8c6eacb4f66d30421666c848' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 69 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '33e0d7613a36b27c8c6eacb4f66d30421666c848' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Namespace Load (0.4ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1
  ↳ config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.3ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1
   app/models/concerns/routable.rb:77:in `full_path'
  ProjectFeature Load (0.3ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 77 LIMIT 1
  ↳ app/models/project.rb:353:in `builds_enabled?'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 77 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '33e0d7613a36b27c8c6eacb4f66d30421666c848' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 77 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '33e0d7613a36b27c8c6eacb4f66d30421666c848' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 71 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f4cc1f2c5269577f7af68fd5097f5c003f02fc72' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 71 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f4cc1f2c5269577f7af68fd5097f5c003f02fc72' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 73 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f4cc1f2c5269577f7af68fd5097f5c003f02fc72' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 73 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f4cc1f2c5269577f7af68fd5097f5c003f02fc72' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Namespace Load (0.4ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 22 LIMIT 1
  ↳ config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.3ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 22 AND "routes"."source_type" = 'Namespace' LIMIT 1
   app/models/concerns/routable.rb:77:in `full_path'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 2 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '2466b410797e6bcb5821505369820696998c90c0' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 2 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '2466b410797e6bcb5821505369820696998c90c0' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 8 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f4cc1f2c5269577f7af68fd5097f5c003f02fc72' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 8 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f4cc1f2c5269577f7af68fd5097f5c003f02fc72' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (1.1ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '93e4f492712ba309ce6789e675cffb61154d6575' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 5 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '93e4f492712ba309ce6789e675cffb61154d6575' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.8ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 77 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f4cc1f2c5269577f7af68fd5097f5c003f02fc72' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (1.1ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 77 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f4cc1f2c5269577f7af68fd5097f5c003f02fc72' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 69 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f4cc1f2c5269577f7af68fd5097f5c003f02fc72' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 69 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f4cc1f2c5269577f7af68fd5097f5c003f02fc72' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Namespace Load (0.5ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1
  ↳ config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.4ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1
   app/models/concerns/routable.rb:77:in `full_path'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 78 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '0dfc35403e35abe0ae332d3e894f4d19f230f1b4' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 78 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '0dfc35403e35abe0ae332d3e894f4d19f230f1b4' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'

After

19 queries
Started GET "/api/v4/search?scope=commits&search=*" for 127.0.0.1 at 2020-06-01 10:45:51 -0400
   (1.0ms)  SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp()))::float as lag
   app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
  ApplicationSetting Load (3.0ms)  SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT 1
  ↳ app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
  PersonalAccessToken Load (1.1ms)  SELECT "personal_access_tokens".* FROM "personal_access_tokens" WHERE "personal_access_tokens"."token_digest" = 'R27ZoLo1xAaezTWG/7z4uMnF9M8yUPN1lDKLEh0cQq4=' LIMIT 1
  ↳ app/models/concerns/token_authenticatable_strategies/digest.rb:8:in `find_token_authenticatable'
  User Load (2.1ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
   lib/gitlab/auth/auth_finders.rb:102:in `find_user_from_access_token'
  Feature::FlipperGate Load (0.4ms)  SELECT "feature_gates".* FROM "feature_gates" WHERE "feature_gates"."feature_key" = 'user_mode_in_session'
  ↳ lib/feature.rb:65:in `enabled?'
   (0.3ms)  SELECT "features"."key" FROM "features"
  ↳ lib/feature.rb:13:in `feature_names'
  License Load (0.3ms)  SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT 100
   ee/app/models/license.rb:264:in `load_license'
  Repository Search (9.1ms) {index: "gitlab-development", type: "doc", body: {query: {bool: {must: {simple_query_string: {fields: ["commit.message^10", "commit.sha^5", "commit.author.name^2", "commit.author.email^2", "commit.committer.name", "commit.committer.email"], query: "*", default_operator: :and}}, filter: [{term: {"type"=>"commit"}}, {has_parent: {parent_type: "project", query: {bool: {should: [{exists: {field: "id"}}, {bool: {filter: [{term: {visibility_level: 20}}, {term: {"repository_access_level"=>20}}]}}, {bool: {filter: [{term: {visibility_level: 10}}, {term: {"repository_access_level"=>20}}]}}], must_not: {term: {"repository_access_level"=>0}}}}}}]}}, size: 20, from: 0, sort: [:_score]}}
  Project Load (3.2ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  ProjectFeature Load (0.5ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 3
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Route Load (0.5ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 3
   ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Group Load (1.3ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."type" = 'Group' AND "namespaces"."id" = 23
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Route Load (0.2ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" = 23
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Namespace Load (0.3ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23
   ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Route Load (0.3ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" = 23
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Group Load (0.5ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."parent_id" IS NULL LIMIT 1
  ↳ app/models/namespace.rb:285:in `block in root_ancestor'
  SamlProvider Load (0.4ms)  SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 23 LIMIT 1
   ee/lib/gitlab/auth/group_saml/sso_enforcer.rb:35:in `group_access_restricted?'
  Ci::Pipeline Load (2.1ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" IN ('e0452bc896e7043cf4fcbc3657b4d790b823971e', 'fe2249735f4e82d2cfd83507b065d0f4b55d1e91', 'f3ccd6ffff967d9a4d2aeef0bc1fcf7ce296f790', '95c640e6926ceff93cadf6de1f54a18376d3a950', '17e9f9ee8698f017fd8de36414322a02d9fd48c8', 'aa61766dfc2fe3b23b90ba841aa6dcac09c7821a', '407c59cfe8a5e37eca6af8f05fc2d68855c61ee5', 'c049bb0655f7d535f23e692449d77a243f985466', 'e16fbdb5fb82b049a2c01fa1860c63bdaa77fb18', 'f24c8d8b08d587542c2f06f9b206892c72296d2e', '4e83457d789ecb4315cbcd937810d1119a10f8c7', '3cf32c48285000db20c84c2e3293956d630dde31', 'c6b25b6374f506b0a2eeb9e89263345bf951befa', '7d8c5054469cd920b1943589c606bd9ccaf64ba8', 'e65965d901aacb0dbd55849d459f92b2eafc464e', '16eef372eae551ba918035e9d548e3cc768daf07', '08981087df8f8f66d2f46e9ad570165866ec5b62', '8bbed94375f240a2a9a1c5d62df3d857c39fb217', 'd23bf4e54d5530bb4477148f3a381d07b8ad9d08', '342e3a49479d5cb5f2d9ddc4644cb862cceefb46') AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" IN ('e0452bc896e7043cf4fcbc3657b4d790b823971e', 'fe2249735f4e82d2cfd83507b065d0f4b55d1e91', 'f3ccd6ffff967d9a4d2aeef0bc1fcf7ce296f790', '95c640e6926ceff93cadf6de1f54a18376d3a950', '17e9f9ee8698f017fd8de36414322a02d9fd48c8', 'aa61766dfc2fe3b23b90ba841aa6dcac09c7821a', '407c59cfe8a5e37eca6af8f05fc2d68855c61ee5', 'c049bb0655f7d535f23e692449d77a243f985466', 'e16fbdb5fb82b049a2c01fa1860c63bdaa77fb18', 'f24c8d8b08d587542c2f06f9b206892c72296d2e', '4e83457d789ecb4315cbcd937810d1119a10f8c7', '3cf32c48285000db20c84c2e3293956d630dde31', 'c6b25b6374f506b0a2eeb9e89263345bf951befa', '7d8c5054469cd920b1943589c606bd9ccaf64ba8', 'e65965d901aacb0dbd55849d459f92b2eafc464e', '16eef372eae551ba918035e9d548e3cc768daf07', '08981087df8f8f66d2f46e9ad570165866ec5b62', '8bbed94375f240a2a9a1c5d62df3d857c39fb217', 'd23bf4e54d5530bb4477148f3a381d07b8ad9d08', '342e3a49479d5cb5f2d9ddc4644cb862cceefb46') AND "ci_pipelines"."project_id" = 3
  ↳ lib/gitlab/commit_metadata.rb:30:in `metadata_for_commit'
  GeoNode Exists? (0.3ms)  SELECT 1 AS one FROM "geo_nodes" LIMIT 1
   ee/lib/gitlab/geo.rb:36:in `block in enabled?'

Project Search - /api/v4/projects/3/search?scope=commits&search=test

Before

59 queries
Started GET "/api/v4/projects/3/search?scope=commits&search=test" for 127.0.0.1 at 2020-05-28 13:52:45 -0400
   (0.3ms)  SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp()))::float as lag
   app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
  ApplicationSetting Load (2.4ms)  SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT 1
  ↳ app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
  PersonalAccessToken Load (0.9ms)  SELECT "personal_access_tokens".* FROM "personal_access_tokens" WHERE "personal_access_tokens"."token_digest" = 'R27ZoLo1xAaezTWG/7z4uMnF9M8yUPN1lDKLEh0cQq4=' LIMIT 1
  ↳ app/models/concerns/token_authenticatable_strategies/digest.rb:8:in `find_token_authenticatable'
  User Load (1.9ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
   lib/gitlab/auth/auth_finders.rb:102:in `find_user_from_access_token'
   (0.4ms)  SELECT "features"."key" FROM "features"
  ↳ lib/feature.rb:13:in `feature_names'
  License Load (0.3ms)  SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT 100
  ↳ ee/app/models/license.rb:264:in `load_license'
  Project Load (2.7ms)  SELECT "projects".* FROM "projects" WHERE "projects"."pending_delete" = FALSE AND "projects"."id" = 3 LIMIT 1
   lib/api/helpers.rb:109:in `find_project'
  Group Load (1.3ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."type" = 'Group' LIMIT 1
  ↳ ee/app/policies/ee/project_policy.rb:337:in `block (2 levels) in <module:ProjectPolicy>'
  IpRestriction Load (0.4ms)  SELECT "ip_restrictions".* FROM "ip_restrictions" WHERE "ip_restrictions"."group_id" = 23
  ↳ ee/lib/gitlab/ip_restriction/enforcer.rb:31:in `allows_address?'
  Group Load (0.4ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."parent_id" IS NULL LIMIT 1
   app/models/namespace.rb:285:in `block in root_ancestor'
  SamlProvider Load (0.4ms)  SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 23 LIMIT 1
  ↳ ee/lib/gitlab/auth/group_saml/sso_enforcer.rb:35:in `group_access_restricted?'
  Project Load (0.6ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1
  ↳ app/services/search_service.rb:22:in `project'
  Route Load (0.7ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 3 AND "routes"."source_type" = 'Project' LIMIT 1
   app/models/concerns/routable.rb:77:in `full_path'
  ProjectFeature Load (0.8ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 3 LIMIT 1
  ↳ app/policies/project_policy.rb:624:in `feature_available?'
  Repository Search (10.1ms) {index: "gitlab-development", type: "doc", body: {query: {bool: {must: {simple_query_string: {fields: ["commit.message^10", "commit.sha^5", "commit.author.name^2", "commit.author.email^2", "commit.committer.name", "commit.committer.email"], query: "test", default_operator: :and}}, filter: [{term: {"type"=>"commit"}}, {terms: {"commit.rid"=>[3]}}]}}, size: 20, from: 0, sort: [:_score]}, routing: "project_3"}
  GeoNode Exists? (0.8ms)  SELECT 1 AS one FROM "geo_nodes" LIMIT 1
  ↳ ee/lib/gitlab/geo.rb:36:in `block in enabled?'
  Namespace Load (0.4ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23 LIMIT 1
   config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.3ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'
  ProjectFeature Load (0.2ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 3 LIMIT 1
  ↳ app/models/project.rb:353:in `builds_enabled?'
  Ci::Pipeline Load (1.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '5d7253357034cc196bca17e7a0bb833b6900589e' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '5d7253357034cc196bca17e7a0bb833b6900589e' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '6473ed5894258d864959a4fd3f156ad3cf6aaead' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '6473ed5894258d864959a4fd3f156ad3cf6aaead' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '08156e2a10b77cc12664e8228564a2a06fc08e64' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '08156e2a10b77cc12664e8228564a2a06fc08e64' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'd07ebfcf8912564a7e223dba2a1a4b0e4871a340' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'd07ebfcf8912564a7e223dba2a1a4b0e4871a340' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '38f577ebaa2f1fbf42e60b33c0ad2c976a4111a8' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '38f577ebaa2f1fbf42e60b33c0ad2c976a4111a8' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '595e78c83b60dd501986a5cfb025dc1e18f80ad9' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '595e78c83b60dd501986a5cfb025dc1e18f80ad9' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '5645e709a27f98aef4527480e713d991bac95cc0' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '5645e709a27f98aef4527480e713d991bac95cc0' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'ebca6049b1ccf474c971637306e18ce16bfce92e' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'ebca6049b1ccf474c971637306e18ce16bfce92e' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'a1fdeef3ae6c98a24be3c4fc4c5639a704f8bba9' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'a1fdeef3ae6c98a24be3c4fc4c5639a704f8bba9' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'fa600c4f048f2580e8c9f52aac207c4b9491b207' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'fa600c4f048f2580e8c9f52aac207c4b9491b207' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '4a186f1732b2bd82452630d21faf1d6c8c17916f' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '4a186f1732b2bd82452630d21faf1d6c8c17916f' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'bcf7d315bf5a0d35fce3b2b1d365d9601c9da17f' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'bcf7d315bf5a0d35fce3b2b1d365d9601c9da17f' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'b25dace6bd4241af9186cded09dbd35cde458418' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'b25dace6bd4241af9186cded09dbd35cde458418' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f517050a096e7beaf18547fb5237dd29af94877c' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f517050a096e7beaf18547fb5237dd29af94877c' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '0c5f786756ff7d92d6ce90abcf56895e85233a32' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '0c5f786756ff7d92d6ce90abcf56895e85233a32' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'efebf302a8a8c76b3ed1fdb2604f51fc4c25df1c' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'efebf302a8a8c76b3ed1fdb2604f51fc4c25df1c' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'cd21cbcd74c4a7dffdee1d6111f7fc0baf411df1' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'cd21cbcd74c4a7dffdee1d6111f7fc0baf411df1' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '2faffa4f763af9e4d1aa11711c20fc73b812df6c' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '2faffa4f763af9e4d1aa11711c20fc73b812df6c' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'a9c509898befea709c11715185e95c2a11cb0649' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'a9c509898befea709c11715185e95c2a11cb0649' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'e31d0ad429f0dcfa6fac217138829248f99794da' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'e31d0ad429f0dcfa6fac217138829248f99794da' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Route Load (0.2ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 3 AND "routes"."source_type" = 'Project' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'

After

16 queries
Started GET "/api/v4/projects/82/search?scope=commits&search=test" for 127.0.0.1 at 2020-06-01 10:46:38 -0400
Gitlab::Metrics::Samplers::DatabaseSampler: A copy of EE::Gitlab::Metrics::Samplers::DatabaseSampler has been removed from the module tree but is still active!, stopping
Creating scope :of_projects. Overwriting existing method MergeRequest.of_projects.
Creating scope :join_project. Overwriting existing method MergeRequest.join_project.
Creating scope :references_project. Overwriting existing method MergeRequest.references_project.
Creating scope :system. Overwriting existing method Note.system.
Creating scope :group_view_details. Overwriting existing method User.group_view_details.
Creating scope :without_statuses. Overwriting existing method CommitStatus.without_statuses.
Creating scope :opened. Overwriting existing method Epic.opened.
Creating scope :closed. Overwriting existing method Epic.closed.
An enum element in Ci::Runner uses the prefix 'not_'. This will cause a conflict with auto generated negative scopes.
Creating scope :with_files_stored_remotely. Overwriting existing method Ci::JobArtifact.with_files_stored_remotely.
Creating scope :order_created_desc. Overwriting existing method Packages::Package.order_created_desc.
Creating scope :order_name_desc. Overwriting existing method Packages::Package.order_name_desc.
   (0.3ms)  SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp()))::float as lag
   app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
  ApplicationSetting Load (2.3ms)  SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT 1
  ↳ app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
  PersonalAccessToken Load (0.9ms)  SELECT "personal_access_tokens".* FROM "personal_access_tokens" WHERE "personal_access_tokens"."token_digest" = 'R27ZoLo1xAaezTWG/7z4uMnF9M8yUPN1lDKLEh0cQq4=' LIMIT 1
  ↳ app/models/concerns/token_authenticatable_strategies/digest.rb:8:in `find_token_authenticatable'
  User Load (2.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
   lib/gitlab/auth/auth_finders.rb:102:in `find_user_from_access_token'
   (0.5ms)  SELECT "features"."key" FROM "features"
  ↳ lib/feature.rb:13:in `feature_names'
  License Load (0.6ms)  SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT 100
  ↳ ee/app/models/license.rb:264:in `load_license'
  Project Load (3.5ms)  SELECT "projects".* FROM "projects" WHERE "projects"."pending_delete" = FALSE AND "projects"."id" = 82 LIMIT 1
   lib/api/helpers.rb:109:in `find_project'
  Group Load (1.3ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 1 AND "namespaces"."type" = 'Group' LIMIT 1
  ↳ ee/app/policies/ee/project_policy.rb:337:in `block (2 levels) in <module:ProjectPolicy>'
  Project Load (0.7ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" = 82 LIMIT 1
  ↳ app/services/search_service.rb:22:in `project'
  Route Load (0.8ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 82 AND "routes"."source_type" = 'Project' LIMIT 1
   app/models/concerns/routable.rb:77:in `full_path'
  ProjectFeature Load (0.8ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 82 LIMIT 1
  ↳ app/policies/project_policy.rb:624:in `feature_available?'
  Repository Search (39.6ms) {index: "gitlab-development", type: "doc", body: {query: {bool: {must: {simple_query_string: {fields: ["commit.message^10", "commit.sha^5", "commit.author.name^2", "commit.author.email^2", "commit.committer.name", "commit.committer.email"], query: "test", default_operator: :and}}, filter: [{term: {"type"=>"commit"}}, {terms: {"commit.rid"=>[82]}}]}}, size: 20, from: 0, sort: [:_score]}, routing: "project_82"}
Creating scope :without_statuses. Overwriting existing method Ci::Pipeline.without_statuses.
  Ci::Pipeline Load (2.8ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" IN ('f3a94f5f6ece93b752209630f722f52fec881cca', '6af1777227bc3f0a3a09e83265d80c60625dc8a6', 'b6761011fced116fd5237e8d0047c915ada69a59', 'cf2ee8e826a01ae429e6d01b91cb76dd27f9cda7', 'bea990b340cc34a9dd99fef84f84a4dfaccd80ae', '2b69bde02496a66d5f6c6502b2ca1c066748773c', '29fd4124f47ac30de19f5700129efe17e6f69895', 'e75f023662342a429435300255095b6b2c713aa2', '10fb130e761138d29fc800ad60f41583ad148e5a', '5ee99abc348cfc9a6867a5b1966911a519247e59', '2acb0c81fd27c91cb5b86525ccfadbea89b113af', '0a80ebafd0d06d291890a9d397956e7e98348629', '0ca2bc2f5545d7cd913a70e74e7dc1711ebcca24', '3c2aac800170996e900203aba33f81bdc2679597', '9d127a2c82f03145078bc19574bede8b6018b370', 'ef83a0481ed39ae10fecfaa8fda7450b162fceb7', '2fedc604cc989fa3b352ac6b213ff110dfde1fd7', 'e10e662a48f51486ca10e56180e21be832aa47d9', 'eb091e9f8039bec38b61d37ff67f652f6b602b9c', '768a15235f572339c409996cb12dd52130de8d80') AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" IN ('f3a94f5f6ece93b752209630f722f52fec881cca', '6af1777227bc3f0a3a09e83265d80c60625dc8a6', 'b6761011fced116fd5237e8d0047c915ada69a59', 'cf2ee8e826a01ae429e6d01b91cb76dd27f9cda7', 'bea990b340cc34a9dd99fef84f84a4dfaccd80ae', '2b69bde02496a66d5f6c6502b2ca1c066748773c', '29fd4124f47ac30de19f5700129efe17e6f69895', 'e75f023662342a429435300255095b6b2c713aa2', '10fb130e761138d29fc800ad60f41583ad148e5a', '5ee99abc348cfc9a6867a5b1966911a519247e59', '2acb0c81fd27c91cb5b86525ccfadbea89b113af', '0a80ebafd0d06d291890a9d397956e7e98348629', '0ca2bc2f5545d7cd913a70e74e7dc1711ebcca24', '3c2aac800170996e900203aba33f81bdc2679597', '9d127a2c82f03145078bc19574bede8b6018b370', 'ef83a0481ed39ae10fecfaa8fda7450b162fceb7', '2fedc604cc989fa3b352ac6b213ff110dfde1fd7', 'e10e662a48f51486ca10e56180e21be832aa47d9', 'eb091e9f8039bec38b61d37ff67f652f6b602b9c', '768a15235f572339c409996cb12dd52130de8d80') AND "ci_pipelines"."project_id" = 82
   lib/gitlab/commit_metadata.rb:30:in `metadata_for_commit'
  Namespace Load (0.8ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1
  ↳ config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.4ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'
  Route Load (0.5ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 82 AND "routes"."source_type" = 'Project' LIMIT 1
   app/models/concerns/routable.rb:77:in `full_path'

Group Search - /api/v4/groups/23/search?scope=commits&search=*

Before

65 queries
Started GET "/api/v4/groups/23/search?scope=commits&search=*" for 127.0.0.1 at 2020-05-28 13:46:06 -0400
Creating scope :of_projects. Overwriting existing method MergeRequest.of_projects.
Creating scope :join_project. Overwriting existing method MergeRequest.join_project.
Creating scope :references_project. Overwriting existing method MergeRequest.references_project.
Creating scope :system. Overwriting existing method Note.system.
Creating scope :group_view_details. Overwriting existing method User.group_view_details.
Creating scope :without_statuses. Overwriting existing method CommitStatus.without_statuses.
Creating scope :opened. Overwriting existing method Epic.opened.
Creating scope :closed. Overwriting existing method Epic.closed.
An enum element in Ci::Runner uses the prefix 'not_'. This will cause a conflict with auto generated negative scopes.
Creating scope :with_files_stored_remotely. Overwriting existing method Ci::JobArtifact.with_files_stored_remotely.
Creating scope :order_created_desc. Overwriting existing method Packages::Package.order_created_desc.
Creating scope :order_name_desc. Overwriting existing method Packages::Package.order_name_desc.
   (0.3ms)  SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp()))::float as lag
   app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
  ApplicationSetting Load (2.4ms)  SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT 1
  ↳ app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
  PersonalAccessToken Load (1.0ms)  SELECT "personal_access_tokens".* FROM "personal_access_tokens" WHERE "personal_access_tokens"."token_digest" = 'R27ZoLo1xAaezTWG/7z4uMnF9M8yUPN1lDKLEh0cQq4=' LIMIT 1
  ↳ app/models/concerns/token_authenticatable_strategies/digest.rb:8:in `find_token_authenticatable'
  User Load (2.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
   lib/gitlab/auth/auth_finders.rb:102:in `find_user_from_access_token'
   (0.5ms)  SELECT "features"."key" FROM "features"
  ↳ lib/feature.rb:13:in `feature_names'
  License Load (0.4ms)  SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT 100
  ↳ ee/app/models/license.rb:264:in `load_license'
  Group Load (1.8ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 LIMIT 1
   lib/api/helpers.rb:129:in `find_group'
  IpRestriction Load (0.5ms)  SELECT "ip_restrictions".* FROM "ip_restrictions" WHERE "ip_restrictions"."group_id" = 23
  ↳ ee/lib/gitlab/ip_restriction/enforcer.rb:31:in `allows_address?'
  Group Load (0.6ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 LIMIT 1
  ↳ app/services/search_service.rb:36:in `group'
  Route Load (0.7ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1
   app/models/concerns/routable.rb:77:in `full_path'
   (4.7ms)  SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (0,10,20)) AND "projects"."archived" = FALSE AND (rs.path LIKE 'gnuwget/%') ORDER BY "projects"."id" DESC
  ↳ ee/app/services/ee/search/group_service.rb:15:in `elastic_projects'
   (1.2ms)  SELECT "projects"."id" FROM "projects" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."id" = 3 AND ("project_features"."repository_access_level" > 0 OR "project_features"."repository_access_level" IS NULL) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (0,10,20))
  ↳ app/models/application_record.rb:21:in `pluck_primary_key'
  Repository Search (24.1ms) {index: "gitlab-development", type: "doc", body: {query: {bool: {must: {simple_query_string: {fields: ["commit.message^10", "commit.sha^5", "commit.author.name^2", "commit.author.email^2", "commit.committer.name", "commit.committer.email"], query: "*", default_operator: :and}}, filter: [{term: {"type"=>"commit"}}, {has_parent: {parent_type: "project", query: {bool: {should: [{terms: {id: [3]}}], must_not: {term: {"repository_access_level"=>0}}}}}}]}}, size: 20, from: 0, sort: [:_score]}, routing: "project_3"}
  Project Load (0.9ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3
   ee/lib/elastic/latest/git_class_proxy.rb:203:in `yield_each_search_result'
  Route Load (0.4ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 3
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:203:in `yield_each_search_result'
  ProjectFeature Load (0.6ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 3 LIMIT 1
  ↳ app/policies/project_policy.rb:624:in `feature_available?'
  Group Load (0.5ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."type" = 'Group' LIMIT 1
   ee/app/policies/ee/project_policy.rb:333:in `block (2 levels) in <module:ProjectPolicy>'
  Group Load (0.6ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."parent_id" IS NULL LIMIT 1
  ↳ app/models/namespace.rb:285:in `block in root_ancestor'
  SamlProvider Load (0.5ms)  SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 23 LIMIT 1
  ↳ ee/lib/gitlab/auth/group_saml/sso_enforcer.rb:35:in `group_access_restricted?'
  GeoNode Exists? (0.7ms)  SELECT 1 AS one FROM "geo_nodes" LIMIT 1
   ee/lib/gitlab/geo.rb:36:in `block in enabled?'
  Namespace Load (0.5ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23 LIMIT 1
  ↳ config/application.rb:310:in `block (4 levels) in <class:Application>'
  Route Load (0.2ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'
Creating scope :without_statuses. Overwriting existing method Ci::Pipeline.without_statuses.
  License Load (0.2ms)  SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT $1  [["LIMIT", 100]]
   ee/app/models/license.rb:264:in `load_license'
  Ci::Pipeline Load (1.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'e0452bc896e7043cf4fcbc3657b4d790b823971e' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'e0452bc896e7043cf4fcbc3657b4d790b823971e' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.8ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'fe2249735f4e82d2cfd83507b065d0f4b55d1e91' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'fe2249735f4e82d2cfd83507b065d0f4b55d1e91' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f3ccd6ffff967d9a4d2aeef0bc1fcf7ce296f790' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f3ccd6ffff967d9a4d2aeef0bc1fcf7ce296f790' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '95c640e6926ceff93cadf6de1f54a18376d3a950' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '95c640e6926ceff93cadf6de1f54a18376d3a950' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '17e9f9ee8698f017fd8de36414322a02d9fd48c8' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '17e9f9ee8698f017fd8de36414322a02d9fd48c8' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'aa61766dfc2fe3b23b90ba841aa6dcac09c7821a' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'aa61766dfc2fe3b23b90ba841aa6dcac09c7821a' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '407c59cfe8a5e37eca6af8f05fc2d68855c61ee5' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '407c59cfe8a5e37eca6af8f05fc2d68855c61ee5' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'c049bb0655f7d535f23e692449d77a243f985466' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'c049bb0655f7d535f23e692449d77a243f985466' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'e16fbdb5fb82b049a2c01fa1860c63bdaa77fb18' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'e16fbdb5fb82b049a2c01fa1860c63bdaa77fb18' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f24c8d8b08d587542c2f06f9b206892c72296d2e' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'f24c8d8b08d587542c2f06f9b206892c72296d2e' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '4e83457d789ecb4315cbcd937810d1119a10f8c7' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '4e83457d789ecb4315cbcd937810d1119a10f8c7' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '3cf32c48285000db20c84c2e3293956d630dde31' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '3cf32c48285000db20c84c2e3293956d630dde31' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'c6b25b6374f506b0a2eeb9e89263345bf951befa' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'c6b25b6374f506b0a2eeb9e89263345bf951befa' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '7d8c5054469cd920b1943589c606bd9ccaf64ba8' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '7d8c5054469cd920b1943589c606bd9ccaf64ba8' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'e65965d901aacb0dbd55849d459f92b2eafc464e' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'e65965d901aacb0dbd55849d459f92b2eafc464e' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.7ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '16eef372eae551ba918035e9d548e3cc768daf07' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '16eef372eae551ba918035e9d548e3cc768daf07' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '08981087df8f8f66d2f46e9ad570165866ec5b62' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '08981087df8f8f66d2f46e9ad570165866ec5b62' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '8bbed94375f240a2a9a1c5d62df3d857c39fb217' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '8bbed94375f240a2a9a1c5d62df3d857c39fb217' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
   app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'd23bf4e54d5530bb4477148f3a381d07b8ad9d08' AND "ci_pipelines_2"."id" IS NULL
  ↳ app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.3ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = 'd23bf4e54d5530bb4477148f3a381d07b8ad9d08' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Ci::Pipeline Load (0.5ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '342e3a49479d5cb5f2d9ddc4644cb862cceefb46' AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 3 AND ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" = '342e3a49479d5cb5f2d9ddc4644cb862cceefb46' ORDER BY "ci_pipelines"."id" DESC LIMIT 1
  ↳ app/models/commit_with_pipeline.rb:17:in `block in last_pipeline'
  Route Load (0.3ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'

After

23 queries
Started GET "/api/v4/groups/23/search?scope=commits&search=*" for 127.0.0.1 at 2020-06-01 10:47:46 -0400
  PersonalAccessToken Load (0.3ms)  SELECT "personal_access_tokens".* FROM "personal_access_tokens" WHERE "personal_access_tokens"."token_digest" = 'R27ZoLo1xAaezTWG/7z4uMnF9M8yUPN1lDKLEh0cQq4=' LIMIT 1
   app/models/concerns/token_authenticatable_strategies/digest.rb:8:in `find_token_authenticatable'
  User Load (0.5ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  ↳ lib/gitlab/auth/auth_finders.rb:102:in `find_user_from_access_token'
  License Load (0.2ms)  SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT 100
  ↳ ee/app/models/license.rb:264:in `load_license'
  Group Load (0.4ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 LIMIT 1
   lib/api/helpers.rb:129:in `find_group'
  IpRestriction Load (0.4ms)  SELECT "ip_restrictions".* FROM "ip_restrictions" WHERE "ip_restrictions"."group_id" = 23
  ↳ ee/lib/gitlab/ip_restriction/enforcer.rb:31:in `allows_address?'
  Group Load (0.3ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 LIMIT 1
  ↳ app/services/search_service.rb:36:in `group'
  Route Load (0.2ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1
   app/models/concerns/routable.rb:77:in `full_path'
   (2.0ms)  SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (0,10,20)) AND "projects"."archived" = FALSE AND (rs.path LIKE 'gnuwget/%') ORDER BY "projects"."id" DESC
  ↳ ee/app/services/ee/search/group_service.rb:15:in `elastic_projects'
   (0.7ms)  SELECT "projects"."id" FROM "projects" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."id" = 3 AND ("project_features"."repository_access_level" > 0 OR "project_features"."repository_access_level" IS NULL) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (0,10,20))
  ↳ app/models/application_record.rb:21:in `pluck_primary_key'
  Repository Search (14.3ms) {index: "gitlab-development", type: "doc", body: {query: {bool: {must: {simple_query_string: {fields: ["commit.message^10", "commit.sha^5", "commit.author.name^2", "commit.author.email^2", "commit.committer.name", "commit.committer.email"], query: "*", default_operator: :and}}, filter: [{term: {"type"=>"commit"}}, {has_parent: {parent_type: "project", query: {bool: {should: [{terms: {id: [3]}}], must_not: {term: {"repository_access_level"=>0}}}}}}]}}, size: 20, from: 0, sort: [:_score]}, routing: "project_3"}
  Project Load (0.7ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3
   ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  ProjectFeature Load (0.2ms)  SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 3
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Route Load (0.3ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 3
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Group Load (0.3ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."type" = 'Group' AND "namespaces"."id" = 23
   ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Route Load (0.2ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" = 23
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Namespace Load (0.3ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23
  ↳ ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Route Load (0.2ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" = 23
   ee/lib/elastic/latest/git_class_proxy.rb:205:in `yield_each_search_result'
  Group Load (0.6ms)  SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."parent_id" IS NULL LIMIT 1
  ↳ app/models/namespace.rb:285:in `block in root_ancestor'
  SamlProvider Load (0.5ms)  SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 23 LIMIT 1
  ↳ ee/lib/gitlab/auth/group_saml/sso_enforcer.rb:35:in `group_access_restricted?'
  Ci::Pipeline Load (0.6ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" LEFT OUTER JOIN "ci_pipelines" "ci_pipelines_2" ON "ci_pipelines"."sha" = "ci_pipelines_2"."sha" AND "ci_pipelines"."project_id" = "ci_pipelines_2"."project_id" AND "ci_pipelines"."id" < "ci_pipelines_2"."id" WHERE ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" IN ('e0452bc896e7043cf4fcbc3657b4d790b823971e', 'fe2249735f4e82d2cfd83507b065d0f4b55d1e91', 'f3ccd6ffff967d9a4d2aeef0bc1fcf7ce296f790', '95c640e6926ceff93cadf6de1f54a18376d3a950', '17e9f9ee8698f017fd8de36414322a02d9fd48c8', 'aa61766dfc2fe3b23b90ba841aa6dcac09c7821a', '407c59cfe8a5e37eca6af8f05fc2d68855c61ee5', 'c049bb0655f7d535f23e692449d77a243f985466', 'e16fbdb5fb82b049a2c01fa1860c63bdaa77fb18', 'f24c8d8b08d587542c2f06f9b206892c72296d2e', '4e83457d789ecb4315cbcd937810d1119a10f8c7', '3cf32c48285000db20c84c2e3293956d630dde31', 'c6b25b6374f506b0a2eeb9e89263345bf951befa', '7d8c5054469cd920b1943589c606bd9ccaf64ba8', 'e65965d901aacb0dbd55849d459f92b2eafc464e', '16eef372eae551ba918035e9d548e3cc768daf07', '08981087df8f8f66d2f46e9ad570165866ec5b62', '8bbed94375f240a2a9a1c5d62df3d857c39fb217', 'd23bf4e54d5530bb4477148f3a381d07b8ad9d08', '342e3a49479d5cb5f2d9ddc4644cb862cceefb46') AND "ci_pipelines_2"."id" IS NULL
   app/models/ci/pipeline.rb:346:in `each_with_object'
  Ci::Pipeline Load (0.4ms)  SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE ("ci_pipelines"."config_source" IN (1, 2, 4, 5) OR "ci_pipelines"."config_source" IS NULL) AND "ci_pipelines"."sha" IN ('e0452bc896e7043cf4fcbc3657b4d790b823971e', 'fe2249735f4e82d2cfd83507b065d0f4b55d1e91', 'f3ccd6ffff967d9a4d2aeef0bc1fcf7ce296f790', '95c640e6926ceff93cadf6de1f54a18376d3a950', '17e9f9ee8698f017fd8de36414322a02d9fd48c8', 'aa61766dfc2fe3b23b90ba841aa6dcac09c7821a', '407c59cfe8a5e37eca6af8f05fc2d68855c61ee5', 'c049bb0655f7d535f23e692449d77a243f985466', 'e16fbdb5fb82b049a2c01fa1860c63bdaa77fb18', 'f24c8d8b08d587542c2f06f9b206892c72296d2e', '4e83457d789ecb4315cbcd937810d1119a10f8c7', '3cf32c48285000db20c84c2e3293956d630dde31', 'c6b25b6374f506b0a2eeb9e89263345bf951befa', '7d8c5054469cd920b1943589c606bd9ccaf64ba8', 'e65965d901aacb0dbd55849d459f92b2eafc464e', '16eef372eae551ba918035e9d548e3cc768daf07', '08981087df8f8f66d2f46e9ad570165866ec5b62', '8bbed94375f240a2a9a1c5d62df3d857c39fb217', 'd23bf4e54d5530bb4477148f3a381d07b8ad9d08', '342e3a49479d5cb5f2d9ddc4644cb862cceefb46') AND "ci_pipelines"."project_id" = 3
  ↳ lib/gitlab/commit_metadata.rb:30:in `metadata_for_commit'
  Route Load (0.4ms)  SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1
  ↳ app/models/concerns/routable.rb:77:in `full_path'

Screenshots

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Security

If this MR contains changes to processing or storing of credentials or tokens, authorization and authentication methods and other items described in the security review guidelines:

  • [-] 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
Edited by 🤖 GitLab Bot 🤖

Merge request reports

Loading