Cache License#load_license
One of the most commonly used queries is loading the license:
calls | query
---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2094959 | SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = ? AND "routes"."source_type" = ? LIMIT ?
1853499 | SELECT ?
1308545 | SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT ?
1229963 | SELECT "projects".* FROM "projects" INNER JOIN "routes" ON "routes"."source_id" = "projects"."id" AND "routes"."source_type" = ? WHERE ((LOWER(routes.path) = LOWER(?))) ORDER BY (CASE WHEN routes.path = ? THEN ? ELSE ? END) LIMIT ?
1044930 | SELECT "projects".* FROM "projects" WHERE "projects"."id" = ? LIMIT ?
990408 | SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN (?) AND "namespaces"."id" = ? AND "namespaces"."type" = ? LIMIT ?
956293 | SET application_name='unicorn worker[0] -D -E produc...service/gitlab-rails/config.ru';
943764 | SET application_name='unicorn worker[15] -D -E produ...service/gitlab-rails/config.ru';
940737 | SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?
937807 | SET application_name='unicorn worker[5] -D -E produc...service/gitlab-rails/config.ru';
(10 rows)
This appears here:
