Query Investigation - Query ID 2190760212461566500 (ci_builds table)

Description

This query is frequently reported as top 15 in total time taken during the monitoring period. The queries were taken from this report https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/snippets/2090600#postgres-checkup_K003

SELECT "ci_builds".* 
FROM "ci_builds" 
WHERE "ci_builds"."type" = $1 
AND "ci_builds"."token_encrypted" = $2 LIMIT $3

image

More Data https://log.gprd.gitlab.net/goto/f1f5f1b349d6a1ee03677066338a4ed2

Row 10 in this report https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/snippets/2090600#k003-top-15-queries-by-total_time

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)
    • 464,867 total
    • 243.42/sec
  • Number of calls per second and relative to total number of calls
  • Query timings (on average or peak)
    • 248,252.45 ms
    • 129.995 ms/sec
    • 0.534 ms/call