8.x threshold issues by component, using data from around 2013-05-01.

d8_threshold_issues_by_component

mysql> select count(pic.nid) as issues, pic.component
    -> from project_issue_comments pic
    -> inner join project_issues pi on pic.comment_number = pi.last_comment_id and pi.nid = pic.nid
    -> where pic.pid=3060 -- core
    -> and pic.sid in(1, 4, 8, 13, 14)  -- active, postponed, NR, NW, RTBC
    -> and pic.priority in(1, 4) -- critical, major
    -> and pic.category in ('bug', 'task') 
    -> and pic.rid=572834 -- 8.x
    -> group by pic.component
    -> order by issues desc
    -> ;
+--------+-----------------------------+
| issues | component                   |
+--------+-----------------------------+
|     49 | base system                 | 
|     23 | entity system               | 
|     20 | theme system                | 
|     17 | configuration system        | 
|     13 | block.module                | 
|     11 | menu system                 | 
|     11 | field system                | 
|     10 | routing system              | 
|      9 | node system                 | 
|      9 | views.module                | 
|      8 | documentation               | 
|      7 | markup                      | 
|      6 | install system              | 
|      6 | views_ui.module             | 
|      6 | file system                 | 
|      5 | database update system      | 
|      5 | other                       | 
|      5 | user.module                 | 
|      5 | javascript                  | 
|      5 | user system                 | 
|      5 | configuration entity system | 
|      5 | forms system                | 
|      5 | update.module               | 
|      5 | toolbar.module              | 
|      5 | database system             | 
|      5 | edit.module                 | 
|      5 | simpletest.module           | 
|      5 | contextual.module           | 
|      4 | filter.module               | 
|      4 | file.module                 | 
|      4 | ckeditor.module             | 
|      4 | cache system                | 
|      3 | image system                | 
|      3 | plugin system               | 
|      3 | path.module                 | 
|      3 | overlay.module              | 
|      3 | entity_reference.module     | 
|      3 | system.module               | 
|      2 | Bartik theme                | 
|      2 | search.module               | 
|      2 | ajax system                 | 
|      2 | language.module             | 
|      2 | field_ui.module             | 
|      2 | editor.module               | 
|      2 | taxonomy.module             | 
|      2 | translation_entity.module   | 
|      2 | rest.module                 | 
|      2 | comment.module              | 
|      2 | image.module                | 
|      2 | node.module                 | 
|      2 | postgresql database         | 
|      2 | menu.module                 | 
|      2 | menu_link.module            | 
|      1 | locale.module               | 
|      1 | layout.module               | 
|      1 | dblog.module                | 
|      1 | picture.module              | 
|      1 | CSS                         | 
|      1 | token system                | 
|      1 | shortcut.module             | 
|      1 | language system             | 
|      1 | forum.module                | 
|      1 | rdf.module                  | 
|      1 | link.module                 | 
|      1 | watchdog.module             | 
|      1 | contact.module              | 
|      1 | config.module               | 
|      1 | sqlite database             | 
|      1 | options.module              | 
|      1 | cron system                 | 
+--------+-----------------------------+