Query Performance Investigation - Query ID 6769309683899657633 (routes table)
Description
This query is frequently reported as top 10 in total number of calls during the monitoring period.
SELECT "routes".*
FROM "routes"
WHERE "routes"."source_id" = $1 AND "routes"."source_type" = $2
LIMIT $3
--application:web,controller:issues,action:index,correlation_id:tt4UclFKFU9/
Requested Data points
Please provide as many of these fields as possible when submitting a query performance report.
- Queries per second (on average or peak) - 1508
- Number of calls per second and relative to total number of calls
- Query timings (on average or peak)
- Database time relative to total database time
- Source of calls (Sidekiq, WebAPI, etc) - --application:web,controller:issues,action:index,correlation_id:tt4UclFKFU9/
- Query ID -
-6762568461667062238
6769309683899657633
https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/issues/12723
Edited by Thong Kuah