From e5c2c6e4889bdaa7e24dff4300b40bd4f721e5d4 Mon Sep 17 00:00:00 2001 From: Thong Kuah Date: Thu, 20 Jun 2019 14:03:21 +1200 Subject: Add failing test showing N+1 We have an N+1 problem where N is environments. --- spec/controllers/projects/merge_requests_controller_spec.rb | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/spec/controllers/projects/merge_requests_controller_spec.rb b/spec/controllers/projects/merge_requests_controller_spec.rb index 34cbf0c8723..9bf2c5c676d 100644 --- a/spec/controllers/projects/merge_requests_controller_spec.rb +++ b/spec/controllers/projects/merge_requests_controller_spec.rb @@ -878,6 +878,18 @@ describe Projects::MergeRequestsController do expect(control_count).to be <= 137 end + it 'has no N+1 issues for environments', :request_store do + # First run to insert test data from lets, which does take up some 30 queries + get_ci_environments_status + + control_count = ActiveRecord::QueryRecorder.new(skip_cached: false) { get_ci_environments_status }.count + + environment2 = create(:environment, project: forked) + create(:deployment, :succeed, environment: environment2, sha: sha, ref: 'master', deployable: build) + + expect { get_ci_environments_status }.not_to exceed_all_query_limit(control_count) + end + def get_ci_environments_status(extra_params = {}) params = { namespace_id: merge_request.project.namespace.to_param, -- cgit v1.2.1