GET /projects/:id/jobs timeouts with `ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout`

https://sentry.gitlap.com/gitlab/gitlabcom/issues/142847/

PG::QueryCanceled: ERROR:  canceling statement due to statement timeout

  lib/api/helpers/pagination.rb:17:in `add_pagination_headers'
    header 'X-Next-Page',   paginated_data.next_page.to_s
  lib/api/helpers/pagination.rb:8:in `block in paginate'
    add_pagination_headers(data)
  lib/api/helpers/pagination.rb:7:in `tap'
    relation.page(params[:page]).per(params[:per_page]).tap do |data|
  lib/api/helpers/pagination.rb:7:in `paginate'
    relation.page(params[:page]).per(params[:per_page]).tap do |data|
  lib/api/jobs.rb:42:in `block (2 levels) in <class:Jobs>'
    present paginate(builds), with: Entities::Job
...
(159 additional frame(s) were not displayed)

ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR:  canceling statement due to statement timeout
: SELECT COUNT(*) FROM "ci_builds" WHERE "ci_builds"."type" IN ('Ci::Build') AND "ci_builds"."project_id" = 13083 AND "ci_builds"."status" = 'failed'

ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR:  canceling statement due to statement timeout
: SELECT COUNT(*) FROM "ci_builds" WHERE "ci_builds"."type" IN ('Ci::Build') AND "ci_builds"."project_id" = 13083 AND "ci_builds"."status" = 'failed'