N+1 queries in UsersController#contributed
As seen in https://log.gitlab.net/goto/9f875ec11da8db6e61b6b5942036a5af, UsersController#contributed
can generate hundreds/thousands of Gitaly requests:
lib/gitlab/gitaly_client/commit_service.rb:461:in `call_find_commit'
lib/gitlab/gitaly_client/commit_service.rb:287:in `find_commit'
lib/gitlab/git/commit.rb:75:in `block in find_commit'
lib/gitlab/git/wraps_gitaly_errors.rb:7:in `wrapped_gitaly_errors'
lib/gitlab/git/commit.rb:74:in `find_commit'
lib/gitlab/git/rugged_impl/commit.rb:41:in `find_commit'
lib/gitlab/git/commit.rb:66:in `find'
app/models/repository.rb:1123:in `find_commit'
app/models/repository.rb:113:in `commit'
app/models/project.rb:712:in `commit'
lib/gitlab/cache/ci/project_pipeline_status.rb:118:in `block in commit'
lib/gitlab/utils/strong_memoize.rb:30:in `strong_memoize'
lib/gitlab/cache/ci/project_pipeline_status.rb:117:in `commit'
lib/gitlab/cache/ci/project_pipeline_status.rb:52:in `load_status'
lib/gitlab/cache/ci/project_pipeline_status.rb:23:in `block in load_in_batch_for_projects'
lib/gitlab/cache/ci/project_pipeline_status.rb:21:in `load_in_batch_for_projects'
app/helpers/projects_helper.rb:201:in `load_pipeline_status'
app/views/shared/projects/_list.html.haml:37:in `_app_views_shared_projects__list_html_haml___1053257278642813021_69948628885460'
app/controllers/application_controller.rb:317:in `pager_json'
app/controllers/users_controller.rb:83:in `block (2 levels) in present_projects'
app/controllers/users_controller.rb:80:in `present_projects'
app/controllers/users_controller.rb:66:in `contributed'
Edited by Stan Hu