Query Performance Investigation - Query ID 2128753358500210093 (internal_ids table)

Description

This query is frequently reported as top 10 in total time taken during the monitoring period.

SELECT "internal_ids".* 
FROM "internal_ids" 
WHERE "internal_ids"."id" = $1 
LIMIT $2 FOR UPDATE 
--application:web,controller:creations,action:create,correlation_id:01EW6S1V7H9EZC2S0GZZDNAHZ1/  

Link to report https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/issues/12889#note_533513454

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)
• 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)
• Query ID - 2128753358500210093
• % of Total time