Skip to content

Add metrics of redundant github_repo_stat rows #223

Description

@iakunin

Add metrics for the following query:

select grs.github_repo_id, grs.type, count(grs.id) from github_repo_stat grs
where grs.id not in (
    select forks_up_result.github_repo_stat_id from forks_up_result
) and grs.id not in (
    select stars_up_result.github_repo_stat_id from stars_up_result
) and grs.id not in (
    select too_many_stars_result.github_repo_stat_id from too_many_stars_result
) and grs.id not in (
    select too_small_result.github_repo_stat_id from too_small_result
)
group by grs.github_repo_id, grs.type
having count(grs.id) > 2
order by count(grs.id) desc

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    dev-opsDevOps issuesinfraIssues dealing with an infrastructure

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions