GET /api/:version/projects/:id/packages/pypi/simple has excessive primary DB queries
See https://log.gprd.gitlab.net/app/r/s/AFTAT and https://log.gprd.gitlab.net/app/r/s/maQhi
p95: 755 primary queries, max: 756 primary queries, samples 1072 Feature Category: package_registry
Action items
-
Investigate if we can place any limits / pagination -
Investigate why this is not using a read replica (it's a GET endpoint) -
Investigate if there's any N+1 query
Edited by Thong Kuah