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