Skip to content

Add metrics of redundant github_repo_stat rows #223

Open
@iakunin

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

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