gistfile1.txt

webhookdb::GRAY=> select r.name, count(*) as pr_count from github_repository as r, github_pull_request as pr where r.owner_login = 'edx' and pr.base_repo_id = r.id and pr.state = 'open' group by r.name order by pr_count desc;
             name              | pr_count 
-------------------------------+----------
 edx-platform                  |      137
 configuration                 |       23
 edx-documentation             |       15
 edx-ora2                      |        8
 edx-notifications             |        7
 edx-app-android               |        7
 edx-analytics-pipeline        |        6
 edx-app-ios                   |        5
 edx-analytics-dashboard       |        4
 xqueue                        |        4
 acid-block                    |        3
 XBlock                        |        3
 edx-val                       |        2
 ux-pattern-library            |        2
 xserver                       |        1
 opaque-keys                   |        1
 xblock-sdk                    |        1
 xblock-utils                  |        1
 harprofiler                   |        1
 codejail                      |        1
 edx-analytics-data-api        |        1
 edx-submissions               |        1
 repo-tools                    |        1
 edx-analytics-data-api-client |        1