[go: up one dir, main page]
Skip to content

N+1 queries looking up environments in PipelinesController#stage.json

From https://gitlab.com/gitlab-org/gitlab/pipelines/102932353/stage.json?stage=test:

image

[
  "ee/app/models/ee/project.rb:589:in `protected_environment_by_name'",
  "ee/app/models/ee/project.rb:581:in `protected_environment_accessible_to?'",
  "ee/app/policies/ee/ci/build_policy.rb:46:in `deployable_by_user?'",
  "ee/app/policies/ee/ci/build_policy.rb:8:in `block (2 levels) in <module:BuildPolicy>'",
  "lib/declarative_policy/condition.rb:23:in `instance_eval'",
  "lib/declarative_policy/condition.rb:23:in `compute'",
  "lib/declarative_policy/condition.rb:44:in `block in pass?'",
  "lib/declarative_policy/base.rb:282:in `cache'",
  "lib/declarative_policy/condition.rb:44:in `pass?'",
  "lib/declarative_policy/rule.rb:81:in `pass?'",
  "lib/declarative_policy/rule.rb:292:in `pass?'",
  "lib/declarative_policy/step.rb:81:in `pass?'",
  "lib/declarative_policy/runner.rb:100:in `block in run'",
  "lib/declarative_policy/runner.rb:179:in `block in steps_by_score'",
  "lib/declarative_policy/runner.rb:148:in `loop'",
  "lib/declarative_policy/runner.rb:148:in `steps_by_score'",
  "lib/declarative_policy/runner.rb:81:in `run'",
  "lib/declarative_policy/runner.rb:59:in `pass?'",
  "lib/declarative_policy/base.rb:217:in `block in allowed?'",
  "lib/declarative_policy/base.rb:217:in `all?'",
  "lib/declarative_policy/base.rb:217:in `allowed?'",
  "lib/declarative_policy/base.rb:209:in `can?'",
  "app/models/ability.rb:72:in `allowed?'",
  "lib/gitlab/allowable.rb:6:in `can?'",
  "app/serializers/job_entity.rb:54:in `retryable?'",
  "app/serializers/job_entity.rb:16:in `block in <class:JobEntity>'",
  "app/serializers/base_serializer.rb:16:in `represent'",
  "app/serializers/concerns/with_pagination.rb:21:in `represent'",
  "app/controllers/projects/pipelines_controller.rb:107:in `stage'",
  "ee/lib/gitlab/ip_address_state.rb:10:in `with'",
  "ee/app/controllers/ee/application_controller.rb:43:in `set_current_ip_address'",
  "lib/gitlab/session.rb:11:in `with_session'",
  "app/controllers/application_controller.rb:462:in `set_session_storage'",
  "app/controllers/application_controller.rb:456:in `set_locale'",
  "ee/lib/omni_auth/strategies/group_saml.rb:41:in `other_phase'",
  "ee/lib/gitlab/jira/middleware.rb:19:in `call'"
]