Attempting to retrieve 100 GitLab CE issues results in an error due to a statement timeout. https://sentry.gitlap.com/gitlab/gitlabcom/issues/118185/ ``` PG::QueryCanceled: ERROR: canceling statement due to statement timeout lib/api/helpers/pagination.rb:15:in `add_pagination_headers' header 'X-Total', paginated_data.total_count.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/v3/issues.rb:112:in `block (2 levels) in <class:Issues>' present paginate(issues), with: ::API::V3::Entities::Issue, current_user: current_user, project: user_project ... (138 additional frame(s) were not displayed) ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout : SELECT COUNT(DISTINCT "issues"."id") FROM "issues" LEFT OUTER JOIN "notes" ON "notes"."noteable_id" = "issues"."id" AND "notes"."noteable_type" = 'Issue' LEFT OUTER JOIN "projects" ON "projects"."id" = "notes"."project_id" LEFT OUTER JOIN "users" ON "users"."id" = "notes"."author_id" LEFT OUTER JOIN "award_emoji" ON "award_emoji"."awardable_id" = "notes"."id" AND "award_emoji"."awardable_type" = 'Note' WHERE "issues"."deleted_at" IS NULL AND "issues"."project_id" = 13083 ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout : SELECT COUNT(DISTINCT "issues"."id") FROM "issues" LEFT OUTER JOIN "notes" ON "notes"."noteable_id" = "issues"."id" AND "notes"."noteable_type" = 'Issue' LEFT OUTER JOIN "projects" ON "projects"."id" = "notes"."project_id" LEFT OUTER JOIN "users" ON "users"."id" = "notes"."author_id" LEFT OUTER JOIN "award_emoji" ON "award_emoji"."awardable_id" = "notes"."id" AND "award_emoji"."awardable_type" = 'Note' WHERE "issues"."deleted_at" IS NULL AND "issues"."project_id" = 13083 ```