Query Performance Investigation - Query ID 8982366218685844340 (namespaces table)

Description

This query is frequently reported as top 10 in total number of calls during the monitoring period.

SELECT "namespaces".*
FROM "namespaces"
WHERE "namespaces"."type" = $1 AND "namespaces"."id" = $2 AND "namespaces"."type" = $3
LIMIT $4 
--application:web,controller:git_http,action:info_refs,correlation_id:53981118-cbfb-45d0-b8ec-3d3c25b6a308/

See #325335 (comment 534063906)

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) - 471
  • Source of calls (Sidekiq, WebAPI, etc) --application:web,controller:git_http,action:info_refs,correlation_id:53981118-cbfb-45d0-b8ec-3d3c25b6a308/
  • Query ID - 8982366218685844340
Edited by Thong Kuah