Performance issue, slow page loading on "project1/-/issues/1" page on GitLab 14.10.2 fresh install

Hi,

I run a fresh, empty GitLab sameersbn/gitlab:14.10.2 instance on this host:

• Intel® NUC 11 Performance kit - NUC11PAHi7
  • Intel® Core™ i7-1165G7 Processor (12M Cache, up to 4.70 GHz)
  • Crucial 32GB Kit (2 x 16GB) DDR4-3200 SODIMM CT2K16G4SFRA32A
  • WD_BLACK™ SN850 NVMe™ SSD - 1To

I use this docker-compose.yml configuration (it is a test instance on my local desktop):

version: '3.9'
services:
  postgres:
    image: index.docker.io/postgres:12.4-alpine
    command: >
      -c shared_buffers=2000MB
      -c maintenance_work_mem=150MB
      -c work_mem=50MB
      -c seq_page_cost=0.8
      -c random_page_cost=1.1
      -c effective_io_concurrency=200
    environment:
      POSTGRES_PASSWORD: password
      POSTGRES_USER: gitlab
      POSTGRES_DB: gitlabhq_production
    volumes:
      - ./volumes/postgresql:/var/lib/postgresql/data

...

  gitlab:
    image: sameersbn/gitlab:14.10.2
    ports:
      - "9922:22"
      - 80:80
    environment:
      ....
      PUMA_WORKERS: 32
      PUMA_THREADS_MIN: 1
      PUMA_THREADS_MAX: 16
      PUMA_PER_WORKER_MAX_MEMORY_MB: 8048
      PUMA_MASTER_MAX_MEMORY_MB: 8048
      ...

I created empty issue: http://127.0.0.1/gitlab-instance-71f415c6/project1/-/issues/1

Here is the performance of http://127.0.0.1/gitlab-instance-71f415c6/project1/-/issues/1 page:

This page take 857ms, sometime1070ms. 3800ms if I count all page dependencies loading.

This is the HAR file issue1.har, I excluded notes and realtime_changes requests.

This is the performance bar flamegraph in wall mode (issues_1_perf_bar_1653215576325.json) :

Do you have any idea why this page is so slow to load? Do you have a solution or is it a real GitLab implementation problem?

Start with the docker-compose.yml configuration and reproduce the empty issue page at the reported GitLab URL. Compare issue1.har with the performance-bar flamegraph to isolate the slow request or dependency; done means a reproducible cause and a documented fix or clear evidence that the problem belongs upstream.