Slow response from PipelinesController#show.json

ZD: https://gitlab.zendesk.com/agent/tickets/113459, https://gitlab.zendesk.com/agent/tickets/112439

Breakdown

  • 16% getting Ci::Pipeline#legacy_stages (profiling overhead is part of this):

image

  • 11% preloading Ci::Pipeline relations:

image

  • 10% generating paths:

image

  • 7% checking BuildActionEntity#playable?:

image

  • 3% due to repeated Gitaly FindCommit calls:

image

  • 3% rendering JSON (can we switch to Oj instead of ActiveSupport?):

image

Edited by 🤖 GitLab Bot 🤖