SQL definition for `template_repositories`
SQL definition for template_repositories
@kathleentam
By(Oct/Jan) for template_reporsitories it looks like there are two SQL statements in one
:template_repositories: SELECT COUNT("projects"."id") FROM "projects" WHERE "projects"."namespace_id"
IS NULLSELECT COUNT("projects"."id") FROM "projects" INNER JOIN namespaces ON
projects.namespace_id = namespaces.custom_project_templates_group_id
Reason
Somehow the metric sums two queries in Ruby
template_repositories: count(::Project.with_repos_templates) + count(::Project.with_groups_level_repos_templates)
Approach
- Do the summation in SQL
- Do the summation after a union
- Modify the exporter
Edited by Alper Akgun