View source for AllHands/BugzillaMetrics

Last year, dmose asked for various metrics with respect to outstanding patches in Bugzilla; here are the results obtained in mid-December 2005.

How many [patches] are there with what distributions of age / patch size / module?

* How many outstanding patches?

 SELECT count(attach_id) as count FROM attachments INNER JOIN bugs ON 
 attachments.bug_id = bugs.bug_id WHERE ispatch = 1 AND isobsolete = 0 AND 
 resolution = "";

7713

* Distribution of age?

 SELECT (((YEAR(attachments.creation_ts) * 12) + MONTH(attachments.creation_ts)) 
 / 12) AS period, count(bugs.bug_id) AS count FROM attachments INNER JOIN bugs 
 ON attachments.bug_id = bugs.bug_id WHERE ispatch = 1 AND isobsolete = 0 AND 
 resolution = "" GROUP BY period;

<table border="1">
<tr><th> period  </th><th> count </th></tr>
<tr><td> 1999.75 </td><td>     7 </td></tr>
<tr><td> 1999.83 </td><td>     2 </td></tr>
<tr><td> 1999.92 </td><td>     2 </td></tr>
<tr><td> 2000.00 </td><td>     3 </td></tr>
<tr><td> 2000.08 </td><td>     2 </td></tr>
<tr><td> 2000.17 </td><td>     9 </td></tr>
<tr><td> 2000.25 </td><td>    14 </td></tr>
<tr><td> 2000.33 </td><td>     4 </td></tr>
<tr><td> 2000.42 </td><td>     2 </td></tr>
<tr><td> 2000.50 </td><td>    24 </td></tr>
<tr><td> 2000.58 </td><td>    19 </td></tr>
<tr><td> 2000.67 </td><td>    26 </td></tr>
<tr><td> 2000.75 </td><td>    51 </td></tr>
<tr><td> 2000.83 </td><td>    53 </td></tr>
<tr><td> 2000.92 </td><td>    33 </td></tr>
<tr><td> 2001.00 </td><td>    48 </td></tr>
<tr><td> 2001.08 </td><td>    66 </td></tr>
<tr><td> 2001.17 </td><td>    65 </td></tr>
<tr><td> 2001.25 </td><td>    76 </td></tr>
<tr><td> 2001.33 </td><td>    89 </td></tr>
<tr><td> 2001.42 </td><td>   129 </td></tr>
<tr><td> 2001.50 </td><td>    95 </td></tr>
<tr><td> 2001.58 </td><td>    93 </td></tr>
<tr><td> 2001.67 </td><td>    91 </td></tr>
<tr><td> 2001.75 </td><td>    71 </td></tr>
<tr><td> 2001.83 </td><td>   120 </td></tr>
<tr><td> 2001.92 </td><td>    71 </td></tr>
<tr><td> 2002.00 </td><td>    91 </td></tr>
<tr><td> 2002.08 </td><td>   112 </td></tr>
<tr><td> 2002.17 </td><td>   122 </td></tr>
<tr><td> 2002.25 </td><td>   100 </td></tr>
<tr><td> 2002.33 </td><td>    98 </td></tr>
<tr><td> 2002.42 </td><td>    70 </td></tr>
<tr><td> 2002.50 </td><td>    79 </td></tr>
<tr><td> 2002.58 </td><td>   108 </td></tr>
<tr><td> 2002.67 </td><td>   111 </td></tr>
<tr><td> 2002.75 </td><td>    81 </td></tr>
<tr><td> 2002.83 </td><td>   100 </td></tr>
<tr><td> 2002.92 </td><td>    88 </td></tr>
<tr><td> 2003.00 </td><td>    83 </td></tr>
<tr><td> 2003.08 </td><td>    77 </td></tr>
<tr><td> 2003.17 </td><td>    57 </td></tr>
<tr><td> 2003.25 </td><td>    86 </td></tr>
<tr><td> 2003.33 </td><td>   103 </td></tr>
<tr><td> 2003.42 </td><td>   102 </td></tr>
<tr><td> 2003.50 </td><td>   105 </td></tr>
<tr><td> 2003.58 </td><td>    94 </td></tr>
<tr><td> 2003.67 </td><td>    74 </td></tr>
<tr><td> 2003.75 </td><td>    73 </td></tr>
<tr><td> 2003.83 </td><td>    77 </td></tr>
<tr><td> 2003.92 </td><td>    69 </td></tr>
<tr><td> 2004.00 </td><td>    71 </td></tr>
<tr><td> 2004.08 </td><td>    77 </td></tr>
<tr><td> 2004.17 </td><td>   111 </td></tr>
<tr><td> 2004.25 </td><td>   128 </td></tr>
<tr><td> 2004.33 </td><td>   117 </td></tr>
<tr><td> 2004.42 </td><td>   120 </td></tr>
<tr><td> 2004.50 </td><td>    93 </td></tr>
<tr><td> 2004.58 </td><td>   112 </td></tr>
<tr><td> 2004.67 </td><td>   123 </td></tr>
<tr><td> 2004.75 </td><td>   131 </td></tr>
<tr><td> 2004.83 </td><td>   156 </td></tr>
<tr><td> 2004.92 </td><td>   128 </td></tr>
<tr><td> 2005.00 </td><td>   123 </td></tr>
<tr><td> 2005.08 </td><td>   168 </td></tr>
<tr><td> 2005.17 </td><td>   141 </td></tr>
<tr><td> 2005.25 </td><td>   227 </td></tr>
<tr><td> 2005.33 </td><td>   161 </td></tr>
<tr><td> 2005.42 </td><td>   153 </td></tr>
<tr><td> 2005.50 </td><td>   153 </td></tr>
<tr><td> 2005.58 </td><td>   226 </td></tr>
<tr><td> 2005.67 </td><td>   260 </td></tr>
<tr><td> 2005.75 </td><td>   286 </td></tr>
<tr><td> 2005.83 </td><td>   349 </td></tr>
<tr><td> 2005.92 </td><td>   502 </td></tr>
<tr><td> 2006.00 </td><td>   172 </td></tr>
</table>

* Distribution of size?

 SELECT TRUNCATE(LENGTH(thedata) / 1000, 0) AS sizek, count(attach_id) AS count 
 FROM attachments INNER JOIN bugs ON attachments.bug_id = bugs.bug_id WHERE 
 ispatch = 1 AND isobsolete = 0 AND resolution = "" GROUP BY sizek;
 <i>(b.m.o. version; it would be different on a tip install)</i>

1k divisions:

<table border="1">
<tr><th> sizek </th><th> count </th></tr>
<tr><td>     0 </td><td>  1159 </td></tr>
<tr><td>     1 </td><td>  1433 </td></tr>
<tr><td>     2 </td><td>   866 </td></tr>
<tr><td>     3 </td><td>   588 </td></tr>
<tr><td>     4 </td><td>   420 </td></tr>
<tr><td>     5 </td><td>   319 </td></tr>
<tr><td>     6 </td><td>   257 </td></tr>
<tr><td>     7 </td><td>   228 </td></tr>
<tr><td>     8 </td><td>   196 </td></tr>
<tr><td>     9 </td><td>   162 </td></tr>
<tr><td>    10 </td><td>   135 </td></tr>
<tr><td>    11 </td><td>   127 </td></tr>
<tr><td>    12 </td><td>   120 </td></tr>
<tr><td>    13 </td><td>    99 </td></tr>
<tr><td>    14 </td><td>    94 </td></tr>
<tr><td>    15 </td><td>    79 </td></tr>
<tr><td>    16 </td><td>    63 </td></tr>
<tr><td>    17 </td><td>    73 </td></tr>
<tr><td>    18 </td><td>    55 </td></tr>
<tr><td>    19 </td><td>    51 </td></tr>
<tr><td>    20 </td><td>    39 </td></tr>
<tr><td>    21 </td><td>    47 </td></tr>
<tr><td>    22 </td><td>    54 </td></tr>
<tr><td>    23 </td><td>    46 </td></tr>
<tr><td>    24 </td><td>    46 </td></tr>
<tr><td>    25 </td><td>    40 </td></tr>
<tr><td>    26 </td><td>    39 </td></tr>
<tr><td>    27 </td><td>    27 </td></tr>
<tr><td>    28 </td><td>    27 </td></tr>
<tr><td>    29 </td><td>    35 </td></tr>
<tr><td>    30 </td><td>    21 </td></tr>
<tr><td>    31 </td><td>    24 </td></tr>
<tr><td>    32 </td><td>    19 </td></tr>
<tr><td>    33 </td><td>    38 </td></tr>
<tr><td>    34 </td><td>    20 </td></tr>
<tr><td>    35 </td><td>    15 </td></tr>
<tr><td>    36 </td><td>    23 </td></tr>
<tr><td>    37 </td><td>     8 </td></tr>
<tr><td>    38 </td><td>    16 </td></tr>
<tr><td>    39 </td><td>     9 </td></tr>
<tr><td>    40 </td><td>    13 </td></tr>
<tr><td>    41 </td><td>    13 </td></tr>
<tr><td>    42 </td><td>    18 </td></tr>
<tr><td>    43 </td><td>    20 </td></tr>
<tr><td>    44 </td><td>    15 </td></tr>
<tr><td>    45 </td><td>    16 </td></tr>
<tr><td>    46 </td><td>    10 </td></tr>
<tr><td>    47 </td><td>    17 </td></tr>
<tr><td>    48 </td><td>    12 </td></tr>
<tr><td>    49 </td><td>     8 </td></tr>
<tr><td>    50 </td><td>     6 </td></tr>
<tr><td>    51 </td><td>    10 </td></tr>
<tr><td>    52 </td><td>     7 </td></tr>
<tr><td>    53 </td><td>     8 </td></tr>
<tr><td>    54 </td><td>     6 </td></tr>
<tr><td>    55 </td><td>    10 </td></tr>
<tr><td>    56 </td><td>    10 </td></tr>
<tr><td>    57 </td><td>     8 </td></tr>
<tr><td>    58 </td><td>     6 </td></tr>
<tr><td>    59 </td><td>    13 </td></tr>
<tr><td>    60 </td><td>     3 </td></tr>
<tr><td>    61 </td><td>     8 </td></tr>
<tr><td>    62 </td><td>     8 </td></tr>
<tr><td>    63 </td><td>    12 </td></tr>
<tr><td>    64 </td><td>     6 </td></tr>
<tr><td>    65 </td><td>     8 </td></tr>
<tr><td>    66 </td><td>     4 </td></tr>
<tr><td>    67 </td><td>     4 </td></tr>
<tr><td>    68 </td><td>     5 </td></tr>
<tr><td>    69 </td><td>     6 </td></tr>
<tr><td>    70 </td><td>     2 </td></tr>
<tr><td>    71 </td><td>     7 </td></tr>
<tr><td>    72 </td><td>     6 </td></tr>
<tr><td>    73 </td><td>     2 </td></tr>
<tr><td>    74 </td><td>     3 </td></tr>
<tr><td>    75 </td><td>     4 </td></tr>
<tr><td>    76 </td><td>     2 </td></tr>
<tr><td>    77 </td><td>     2 </td></tr>
<tr><td>    78 </td><td>     2 </td></tr>
<tr><td>    79 </td><td>     6 </td></tr>
<tr><td>    80 </td><td>     5 </td></tr>
<tr><td>    81 </td><td>     5 </td></tr>
<tr><td>    82 </td><td>     5 </td></tr>
<tr><td>    83 </td><td>     5 </td></tr>
<tr><td>    84 </td><td>     7 </td></tr>
<tr><td>    85 </td><td>    10 </td></tr>
<tr><td>    86 </td><td>     5 </td></tr>
<tr><td>    87 </td><td>     3 </td></tr>
<tr><td>    88 </td><td>     6 </td></tr>
<tr><td>    89 </td><td>     4 </td></tr>
<tr><td>    90 </td><td>     2 </td></tr>
<tr><td>    91 </td><td>     4 </td></tr>
<tr><td>    92 </td><td>     1 </td></tr>
<tr><td>    93 </td><td>     3 </td></tr>
<tr><td>    94 </td><td>     1 </td></tr>
<tr><td>    95 </td><td>     2 </td></tr>
<tr><td>    96 </td><td>     2 </td></tr>
<tr><td>    98 </td><td>     5 </td></tr>
<tr><td>   100 </td><td>     1 </td></tr>
<tr><td>   101 </td><td>     4 </td></tr>
<tr><td>   102 </td><td>     2 </td></tr>
<tr><td>   103 </td><td>     1 </td></tr>
<tr><td>   104 </td><td>     4 </td></tr>
<tr><td>   105 </td><td>     4 </td></tr>
<tr><td>   106 </td><td>     1 </td></tr>
<tr><td>   107 </td><td>     4 </td></tr>
<tr><td>   108 </td><td>     3 </td></tr>
<tr><td>   110 </td><td>     5 </td></tr>
<tr><td>   111 </td><td>     3 </td></tr>
<tr><td>   112 </td><td>     1 </td></tr>
<tr><td>   113 </td><td>     1 </td></tr>
<tr><td>   114 </td><td>     2 </td></tr>
<tr><td>   115 </td><td>     1 </td></tr>
<tr><td>   116 </td><td>     5 </td></tr>
<tr><td>   117 </td><td>     2 </td></tr>
<tr><td>   118 </td><td>     2 </td></tr>
<tr><td>   119 </td><td>     1 </td></tr>
<tr><td>   120 </td><td>     3 </td></tr>
<tr><td>   122 </td><td>     1 </td></tr>
<tr><td>   123 </td><td>     1 </td></tr>
<tr><td>   124 </td><td>     4 </td></tr>
<tr><td>   125 </td><td>     1 </td></tr>
<tr><td>   127 </td><td>     2 </td></tr>
<tr><td>   130 </td><td>     2 </td></tr>
<tr><td>   131 </td><td>     2 </td></tr>
<tr><td>   132 </td><td>     4 </td></tr>
<tr><td>   133 </td><td>     3 </td></tr>
<tr><td>   134 </td><td>     2 </td></tr>
<tr><td>   138 </td><td>     1 </td></tr>
<tr><td>   139 </td><td>     2 </td></tr>
<tr><td>   140 </td><td>     1 </td></tr>
<tr><td>   141 </td><td>     1 </td></tr>
<tr><td>   142 </td><td>     1 </td></tr>
<tr><td>   143 </td><td>     1 </td></tr>
<tr><td>   144 </td><td>     2 </td></tr>
<tr><td>   149 </td><td>     3 </td></tr>
<tr><td>   150 </td><td>     2 </td></tr>
<tr><td>   152 </td><td>     3 </td></tr>
<tr><td>   153 </td><td>     1 </td></tr>
<tr><td>   157 </td><td>     2 </td></tr>
<tr><td>   160 </td><td>     1 </td></tr>
<tr><td>   162 </td><td>     2 </td></tr>
<tr><td>   163 </td><td>     4 </td></tr>
<tr><td>   164 </td><td>     3 </td></tr>
<tr><td>   165 </td><td>     2 </td></tr>
<tr><td>   166 </td><td>     1 </td></tr>
<tr><td>   168 </td><td>     3 </td></tr>
<tr><td>   170 </td><td>     2 </td></tr>
<tr><td>   171 </td><td>     3 </td></tr>
<tr><td>   175 </td><td>     2 </td></tr>
<tr><td>   176 </td><td>     1 </td></tr>
<tr><td>   177 </td><td>     1 </td></tr>
<tr><td>   180 </td><td>     1 </td></tr>
<tr><td>   184 </td><td>     1 </td></tr>
<tr><td>   185 </td><td>     2 </td></tr>
<tr><td>   187 </td><td>     1 </td></tr>
<tr><td>   188 </td><td>     1 </td></tr>
<tr><td>   189 </td><td>     1 </td></tr>
<tr><td>   190 </td><td>     1 </td></tr>
<tr><td>   195 </td><td>     1 </td></tr>
<tr><td>   199 </td><td>     2 </td></tr>
<tr><td>   200 </td><td>     1 </td></tr>
<tr><td>   202 </td><td>     1 </td></tr>
<tr><td>   203 </td><td>     2 </td></tr>
<tr><td>   204 </td><td>     2 </td></tr>
<tr><td>   209 </td><td>     1 </td></tr>
<tr><td>   212 </td><td>     2 </td></tr>
<tr><td>   213 </td><td>     1 </td></tr>
<tr><td>   214 </td><td>     1 </td></tr>
<tr><td>   218 </td><td>     1 </td></tr>
<tr><td>   219 </td><td>     3 </td></tr>
<tr><td>   222 </td><td>     1 </td></tr>
<tr><td>   224 </td><td>     1 </td></tr>
<tr><td>   227 </td><td>     1 </td></tr>
<tr><td>   233 </td><td>     1 </td></tr>
<tr><td>   234 </td><td>     1 </td></tr>
<tr><td>   235 </td><td>     1 </td></tr>
<tr><td>   236 </td><td>     2 </td></tr>
<tr><td>   237 </td><td>     1 </td></tr>
<tr><td>   241 </td><td>     1 </td></tr>
<tr><td>   256 </td><td>     1 </td></tr>
<tr><td>   259 </td><td>     1 </td></tr>
<tr><td>   263 </td><td>     2 </td></tr>
<tr><td>   267 </td><td>     1 </td></tr>
<tr><td>   271 </td><td>     1 </td></tr>
<tr><td>   274 </td><td>     1 </td></tr>
<tr><td>   276 </td><td>     1 </td></tr>
<tr><td>   282 </td><td>     2 </td></tr>
<tr><td>   283 </td><td>     1 </td></tr>
<tr><td>   285 </td><td>     1 </td></tr>
<tr><td>   289 </td><td>     1 </td></tr>
<tr><td>   299 </td><td>     1 </td></tr>
<tr><td>   312 </td><td>     1 </td></tr>
<tr><td>   316 </td><td>     1 </td></tr>
<tr><td>   336 </td><td>     1 </td></tr>
<tr><td>   340 </td><td>     1 </td></tr>
<tr><td>   344 </td><td>     1 </td></tr>
<tr><td>   348 </td><td>     1 </td></tr>
<tr><td>   349 </td><td>     1 </td></tr>
<tr><td>   353 </td><td>     2 </td></tr>
<tr><td>   364 </td><td>     1 </td></tr>
<tr><td>   386 </td><td>     1 </td></tr>
<tr><td>   389 </td><td>     1 </td></tr>
<tr><td>   417 </td><td>     1 </td></tr>
<tr><td>   430 </td><td>     1 </td></tr>
<tr><td>   434 </td><td>     1 </td></tr>
<tr><td>   436 </td><td>     1 </td></tr>
<tr><td>   440 </td><td>     1 </td></tr>
<tr><td>   449 </td><td>     1 </td></tr>
<tr><td>   457 </td><td>     1 </td></tr>
<tr><td>   462 </td><td>     1 </td></tr>
<tr><td>   466 </td><td>     1 </td></tr>
<tr><td>   510 </td><td>     1 </td></tr>
<tr><td>   630 </td><td>     1 </td></tr>
<tr><td>   665 </td><td>     1 </td></tr>
<tr><td>   672 </td><td>     1 </td></tr>
<tr><td>   700 </td><td>     1 </td></tr>
<tr><td>   707 </td><td>     1 </td></tr>
<tr><td>   817 </td><td>     1 </td></tr>
<tr><td>   916 </td><td>     1 </td></tr>
</table>

5k divisions:

<table border="1">
<tr><th> sizek </th><th> count </th></tr>
<tr><td>     0 </td><td>  4466 </td></tr>
<tr><td>     1 </td><td>  1162 </td></tr>
<tr><td>     2 </td><td>   575 </td></tr>
<tr><td>     3 </td><td>   321 </td></tr>
<tr><td>     4 </td><td>   232 </td></tr>
<tr><td>     5 </td><td>   168 </td></tr>
<tr><td>     6 </td><td>   122 </td></tr>
<tr><td>     7 </td><td>    71 </td></tr>
<tr><td>     8 </td><td>    79 </td></tr>
<tr><td>     9 </td><td>    63 </td></tr>
<tr><td>    10 </td><td>    37 </td></tr>
<tr><td>    11 </td><td>    47 </td></tr>
<tr><td>    12 </td><td>    37 </td></tr>
<tr><td>    13 </td><td>    27 </td></tr>
<tr><td>    14 </td><td>    20 </td></tr>
<tr><td>    15 </td><td>    16 </td></tr>
<tr><td>    16 </td><td>    27 </td></tr>
<tr><td>    17 </td><td>    28 </td></tr>
<tr><td>    18 </td><td>    11 </td></tr>
<tr><td>    19 </td><td>     9 </td></tr>
<tr><td>    20 </td><td>    12 </td></tr>
<tr><td>    21 </td><td>    12 </td></tr>
<tr><td>    22 </td><td>    12 </td></tr>
<tr><td>    23 </td><td>    11 </td></tr>
<tr><td>    24 </td><td>     9 </td></tr>
<tr><td>    25 </td><td>     3 </td></tr>
<tr><td>    26 </td><td>    13 </td></tr>
<tr><td>    27 </td><td>     3 </td></tr>
<tr><td>    28 </td><td>     6 </td></tr>
<tr><td>    29 </td><td>     3 </td></tr>
<tr><td>    30 </td><td>     6 </td></tr>
<tr><td>    31 </td><td>     2 </td></tr>
<tr><td>    32 </td><td>    10 </td></tr>
<tr><td>    33 </td><td>     6 </td></tr>
<tr><td>    34 </td><td>     5 </td></tr>
<tr><td>    35 </td><td>     4 </td></tr>
<tr><td>    36 </td><td>     2 </td></tr>
<tr><td>    37 </td><td>     5 </td></tr>
<tr><td>    38 </td><td>     1 </td></tr>
<tr><td>    39 </td><td>     3 </td></tr>
<tr><td>    40 </td><td>     6 </td></tr>
<tr><td>    41 </td><td>     1 </td></tr>
<tr><td>    42 </td><td>     4 </td></tr>
<tr><td>    43 </td><td>     4 </td></tr>
<tr><td>    44 </td><td>     2 </td></tr>
<tr><td>    45 </td><td>     1 </td></tr>
<tr><td>    46 </td><td>     2 </td></tr>
<tr><td>    47 </td><td>     4 </td></tr>
<tr><td>    48 </td><td>     1 </td></tr>
<tr><td>    51 </td><td>     2 </td></tr>
<tr><td>    52 </td><td>     2 </td></tr>
<tr><td>    53 </td><td>     1 </td></tr>
<tr><td>    54 </td><td>     2 </td></tr>
<tr><td>    55 </td><td>     1 </td></tr>
<tr><td>    56 </td><td>     3 </td></tr>
<tr><td>    57 </td><td>     2 </td></tr>
<tr><td>    59 </td><td>     1 </td></tr>
<tr><td>    62 </td><td>     1 </td></tr>
<tr><td>    63 </td><td>     1 </td></tr>
<tr><td>    67 </td><td>     1 </td></tr>
<tr><td>    68 </td><td>     2 </td></tr>
<tr><td>    69 </td><td>     2 </td></tr>
<tr><td>    70 </td><td>     2 </td></tr>
<tr><td>    72 </td><td>     1 </td></tr>
<tr><td>    77 </td><td>     2 </td></tr>
<tr><td>    83 </td><td>     1 </td></tr>
<tr><td>    86 </td><td>     2 </td></tr>
<tr><td>    87 </td><td>     1 </td></tr>
<tr><td>    88 </td><td>     1 </td></tr>
<tr><td>    89 </td><td>     1 </td></tr>
<tr><td>    91 </td><td>     1 </td></tr>
<tr><td>    92 </td><td>     1 </td></tr>
<tr><td>    93 </td><td>     1 </td></tr>
<tr><td>   102 </td><td>     1 </td></tr>
<tr><td>   126 </td><td>     1 </td></tr>
<tr><td>   133 </td><td>     1 </td></tr>
<tr><td>   134 </td><td>     1 </td></tr>
<tr><td>   140 </td><td>     1 </td></tr>
<tr><td>   141 </td><td>     1 </td></tr>
<tr><td>   163 </td><td>     1 </td></tr>
<tr><td>   183 </td><td>     1 </td></tr>
</table>

* Distribution of module?

 SELECT components.name, count(attach_id) AS count FROM attachments INNER JOIN 
 bugs ON attachments.bug_id = bugs.bug_id INNER JOIN components ON 
 bugs.component_id = components.id WHERE ispatch = 1 AND isobsolete = 0 AND 
 resolution = "" GROUP BY component_id ORDER BY count DESC;

<table border="1">
<tr><th> name                                     </th><th> count </th></tr>
<tr><td> XPCOM                                    </td><td>   266 </td></tr>
<tr><td> XP Toolkit/Widgets                       </td><td>   233 </td></tr>
<tr><td> MailNews: Main Mail Window               </td><td>   216 </td></tr>
<tr><td> Build Config                             </td><td>   192 </td></tr>
<tr><td> Internationalization                     </td><td>   174 </td></tr>
<tr><td> General                                  </td><td>   141 </td></tr>
<tr><td> Libraries                                </td><td>   135 </td></tr>
<tr><td> XP Toolkit/Widgets: XUL                  </td><td>   125 </td></tr>
<tr><td> JavaScript Engine                        </td><td>   122 </td></tr>
<tr><td> XP Apps: GUI Features                    </td><td>   121 </td></tr>
<tr><td> Bugzilla-General                         </td><td>   121 </td></tr>
<tr><td> Layout                                   </td><td>   111 </td></tr>
<tr><td> NSPR                                     </td><td>   110 </td></tr>
<tr><td> MailNews: Backend                        </td><td>   103 </td></tr>
<tr><td> Plug-ins                                 </td><td>    96 </td></tr>
<tr><td> Networking                               </td><td>    93 </td></tr>
<tr><td> General                                  </td><td>    90 </td></tr>
<tr><td> XPConnect                                </td><td>    89 </td></tr>
<tr><td> Editor                                   </td><td>    88 </td></tr>
<tr><td> MailNews: Composition                    </td><td>    86 </td></tr>
<tr><td> String                                   </td><td>    81 </td></tr>
<tr><td> XP Apps                                  </td><td>    79 </td></tr>
<tr><td> DOM                                      </td><td>    79 </td></tr>
<tr><td> Creating/Changing Bugs                   </td><td>    77 </td></tr>
<tr><td> Mail Window Front End                    </td><td>    77 </td></tr>
<tr><td> ImageLib                                 </td><td>    71 </td></tr>
<tr><td> Sunbird and Calendar-Extension Front End </td><td>    70 </td></tr>
<tr><td> Query/Bug List                           </td><td>    69 </td></tr>
<tr><td> Build Config                             </td><td>    65 </td></tr>
<tr><td> Preferences                              </td><td>    62 </td></tr>
<tr><td> Themes                                   </td><td>    60 </td></tr>
<tr><td> Style System (CSS)                       </td><td>    58 </td></tr>
<tr><td> User Interface                           </td><td>    57 </td></tr>
<tr><td> Printing                                 </td><td>    57 </td></tr>
<tr><td> XForms                                   </td><td>    56 </td></tr>
<tr><td> Embedding: APIs                          </td><td>    55 </td></tr>
<tr><td> Composer                                 </td><td>    53 </td></tr>
<tr><td> Security: UI                             </td><td>    52 </td></tr>
<tr><td> SVG                                      </td><td>    52 </td></tr>
<tr><td> Administration                           </td><td>    51 </td></tr>
<tr><td> Bookmarks                                </td><td>    51 </td></tr>
<tr><td> XP Toolkit/Widgets: Trees                </td><td>    50 </td></tr>
<tr><td> File Handling                            </td><td>    50 </td></tr>
<tr><td> Layout: Misc Code                        </td><td>    49 </td></tr>
<tr><td> General                                  </td><td>    49 </td></tr>
<tr><td> Layout: Form Controls                    </td><td>    48 </td></tr>
<tr><td> Bookmarks                                </td><td>    47 </td></tr>
<tr><td> MailNews: Address Book                   </td><td>    46 </td></tr>
<tr><td> Other                                    </td><td>    45 </td></tr>
<tr><td> Toolbars                                 </td><td>    45 </td></tr>
<tr><td> GFX                                      </td><td>    42 </td></tr>
<tr><td> Tabbed Browser                           </td><td>    42 </td></tr>
<tr><td> GFX: Gtk                                 </td><td>    41 </td></tr>
<tr><td> Layout: Tables                           </td><td>    41 </td></tr>
<tr><td> webmaster@mozilla.org                    </td><td>    40 </td></tr>
<tr><td> Web Developer                            </td><td>    40 </td></tr>
<tr><td> HTML: Parser                             </td><td>    40 </td></tr>
<tr><td> Networking: HTTP                         </td><td>    39 </td></tr>
<tr><td> MailNews: Account Manager                </td><td>    39 </td></tr>
<tr><td> Embedding: Docshell                      </td><td>    38 </td></tr>
<tr><td> XP Toolkit/Widgets: Menus                </td><td>    37 </td></tr>
<tr><td> MailNews: MIME                           </td><td>    37 </td></tr>
<tr><td> Keyboard: Navigation                     </td><td>    35 </td></tr>
<tr><td> Event Handling                           </td><td>    35 </td></tr>
<tr><td> Networking: IMAP                         </td><td>    34 </td></tr>
<tr><td> Tracking                                 </td><td>    34 </td></tr>
<tr><td> Installer                                </td><td>    34 </td></tr>
<tr><td> Layout: BiDi Hebrew & Arabic             </td><td>    33 </td></tr>
<tr><td> Selection                                </td><td>    33 </td></tr>
<tr><td> General                                  </td><td>    33 </td></tr>
<tr><td> Embedding: GTK Widget                    </td><td>    33 </td></tr>
<tr><td> DOM: Level 0                             </td><td>    32 </td></tr>
<tr><td> DOM: Events                              </td><td>    29 </td></tr>
<tr><td> User Accounts                            </td><td>    29 </td></tr>
<tr><td> XML                                      </td><td>    29 </td></tr>
<tr><td> Email Notifications                      </td><td>    29 </td></tr>
<tr><td> DOM Inspector                            </td><td>    28 </td></tr>
<tr><td> Preferences                              </td><td>    28 </td></tr>
<tr><td> Networking: Cookies                      </td><td>    27 </td></tr>
<tr><td> MailNews: Filters                        </td><td>    27 </td></tr>
<tr><td> XUL Widgets                              </td><td>    26 </td></tr>
<tr><td> Location Bar and Autocomplete            </td><td>    26 </td></tr>
<tr><td> LXR                                      </td><td>    25 </td></tr>
<tr><td> Build                                    </td><td>    25 </td></tr>
<tr><td> Layout: View Rendering                   </td><td>    25 </td></tr>
<tr><td> Build Config                             </td><td>    24 </td></tr>
<tr><td> Preferences: Backend                     </td><td>    24 </td></tr>
<tr><td> RDF                                      </td><td>    24 </td></tr>
<tr><td> Places                                   </td><td>    24 </td></tr>
<tr><td> Developers                               </td><td>    24 </td></tr>
<tr><td> Search                                   </td><td>    24 </td></tr>
<tr><td> Layout: Fonts and Text                   </td><td>    23 </td></tr>
<tr><td> Tabbed Browser                           </td><td>    23 </td></tr>
<tr><td> DOM: Core                                </td><td>    23 </td></tr>
<tr><td> de-AT / German-Austria                   </td><td>    23 </td></tr>
<tr><td> Web Site                                 </td><td>    23 </td></tr>
<tr><td> Cmd-line Features                        </td><td>    22 </td></tr>
<tr><td> Sidebar                                  </td><td>    22 </td></tr>
<tr><td> Tools                                    </td><td>    22 </td></tr>
<tr><td> XBL                                      </td><td>    22 </td></tr>
<tr><td> JavaScript Debugger                      </td><td>    22 </td></tr>
<tr><td> MailNews: Internationalization           </td><td>    22 </td></tr>
<tr><td> MailNews: Database                       </td><td>    22 </td></tr>
<tr><td> XSLT                                     </td><td>    21 </td></tr>
<tr><td> Bonsai                                   </td><td>    21 </td></tr>
<tr><td> Java to XPCOM Bridge                     </td><td>    21 </td></tr>
<tr><td> GFX: Win32                               </td><td>    21 </td></tr>
<tr><td> Networking: News                         </td><td>    21 </td></tr>
<tr><td> Help                                     </td><td>    20 </td></tr>
<tr><td> Embedding: ActiveX Wrapper               </td><td>    20 </td></tr>
<tr><td> Layout: Block and Inline                 </td><td>    20 </td></tr>
<tr><td> Base                                     </td><td>    20 </td></tr>
<tr><td> Extension/Theme Manager                  </td><td>    19 </td></tr>
<tr><td> MailNews: Offline                        </td><td>    19 </td></tr>
<tr><td> xpidl                                    </td><td>    19 </td></tr>
<tr><td> Java APIs to WebShell                    </td><td>    19 </td></tr>
<tr><td> Address Book                             </td><td>    19 </td></tr>
<tr><td> Tinderbox                                </td><td>    19 </td></tr>
<tr><td> Installer: XPInstall Engine              </td><td>    18 </td></tr>
<tr><td> ChatZilla                                </td><td>    18 </td></tr>
<tr><td> Message Compose Window                   </td><td>    18 </td></tr>
<tr><td> DOM: HTML                                </td><td>    18 </td></tr>
<tr><td> Networking: Cache                        </td><td>    17 </td></tr>
<tr><td> Java: Live Connect                       </td><td>    17 </td></tr>
<tr><td> Profile: BackEnd                         </td><td>    17 </td></tr>
<tr><td> Help Viewer                              </td><td>    17 </td></tr>
<tr><td> DOM: Mozilla Extensions                  </td><td>    17 </td></tr>
<tr><td> XRE Startup                              </td><td>    17 </td></tr>
<tr><td> Mozbot                                   </td><td>    17 </td></tr>
<tr><td> Image: GFX                               </td><td>    16 </td></tr>
<tr><td> Location Bar                             </td><td>    16 </td></tr>
<tr><td> Drag and Drop                            </td><td>    15 </td></tr>
<tr><td> Page Info                                </td><td>    15 </td></tr>
<tr><td> Download Manager                         </td><td>    15 </td></tr>
<tr><td> RSS                                      </td><td>    15 </td></tr>
<tr><td> Security                                 </td><td>    15 </td></tr>
<tr><td> Download Manager                         </td><td>    15 </td></tr>
<tr><td> Disability Access APIs                   </td><td>    15 </td></tr>
<tr><td> Lightning                                </td><td>    15 </td></tr>
<tr><td> Widget: Gtk                              </td><td>    14 </td></tr>
<tr><td> Attachments & Requests                   </td><td>    14 </td></tr>
<tr><td> Documentation                            </td><td>    14 </td></tr>
<tr><td> History: Global                          </td><td>    14 </td></tr>
<tr><td> Menus                                    </td><td>    13 </td></tr>
<tr><td> Installer                                </td><td>    13 </td></tr>
<tr><td> Mozilla Developer                        </td><td>    13 </td></tr>
<tr><td> Web Services                             </td><td>    13 </td></tr>
<tr><td> Find Toolbar / FastFind                  </td><td>    13 </td></tr>
<tr><td> Security: CAPS                           </td><td>    13 </td></tr>
<tr><td> History: Session                         </td><td>    12 </td></tr>
<tr><td> Software Update                          </td><td>    12 </td></tr>
<tr><td> Java: OJI                                </td><td>    12 </td></tr>
<tr><td> Spelling checker                         </td><td>    12 </td></tr>
<tr><td> X-remote                                 </td><td>    12 </td></tr>
<tr><td> Storage                                  </td><td>    12 </td></tr>
<tr><td> Installation & Upgrading                 </td><td>    12 </td></tr>
<tr><td> GFX: Mac                                 </td><td>    12 </td></tr>
<tr><td> MailNews: LDAP Integration               </td><td>    12 </td></tr>
<tr><td> LDAP C SDK                               </td><td>    12 </td></tr>
<tr><td> Reporting/Charting                       </td><td>    11 </td></tr>
<tr><td> Layout: CTL                              </td><td>    11 </td></tr>
<tr><td> Widget: Mac                              </td><td>    11 </td></tr>
<tr><td> General                                  </td><td>    11 </td></tr>
<tr><td> Test                                     </td><td>    11 </td></tr>
<tr><td> Embedding: Mac                           </td><td>    10 </td></tr>
<tr><td> MailNews: Networking                     </td><td>    10 </td></tr>
<tr><td> Networking: File                         </td><td>    10 </td></tr>
<tr><td> JavaScript Console                       </td><td>    10 </td></tr>
<tr><td> MailNews: Security                       </td><td>    10 </td></tr>
<tr><td> Print Preview                            </td><td>    10 </td></tr>
<tr><td> Security: PSM                            </td><td>    10 </td></tr>
<tr><td> DOM to Text Conversion                   </td><td>    10 </td></tr>
<tr><td> MailNews: Attachments                    </td><td>    10 </td></tr>
<tr><td> OS Integration                           </td><td>    10 </td></tr>
<tr><td> DOM: CSSOM                               </td><td>    10 </td></tr>
<tr><td> Widget: Win32                            </td><td>     9 </td></tr>
<tr><td> MailNews: Profile Migration              </td><td>     9 </td></tr>
<tr><td> Profile: Manager                         </td><td>     9 </td></tr>
<tr><td> Networking: FTP                          </td><td>     9 </td></tr>
<tr><td> Ports: Qt                                </td><td>     9 </td></tr>
<tr><td> Password Manager                         </td><td>     9 </td></tr>
<tr><td> Networking: POP                          </td><td>     9 </td></tr>
<tr><td> Miscellaneous                            </td><td>     8 </td></tr>
<tr><td> HTML: Form Submission                    </td><td>     8 </td></tr>
<tr><td> MailNews: Search                         </td><td>     8 </td></tr>
<tr><td> Bugzilla: Other b.m.o Issues             </td><td>     8 </td></tr>
<tr><td> Profile: Roaming                         </td><td>     8 </td></tr>
<tr><td> Autocomplete                             </td><td>     8 </td></tr>
<tr><td> Java APIs for DOM                        </td><td>     8 </td></tr>
<tr><td> Profile: Migration                       </td><td>     7 </td></tr>
<tr><td> Address Book                             </td><td>     7 </td></tr>
<tr><td> XP Miscellany                            </td><td>     7 </td></tr>
<tr><td> MathML                                   </td><td>     7 </td></tr>
<tr><td> Layout: HTML Frames                      </td><td>     7 </td></tr>
<tr><td> Database                                 </td><td>     7 </td></tr>
<tr><td> Preferences                              </td><td>     7 </td></tr>
<tr><td> Image Blocking                           </td><td>     7 </td></tr>
<tr><td> Installer: XPI Packages                  </td><td>     7 </td></tr>
<tr><td> DOM: Traversal-Range                     </td><td>     7 </td></tr>
<tr><td> ViewSource                               </td><td>     7 </td></tr>
<tr><td> MailNews: Simple MAPI                    </td><td>     7 </td></tr>
<tr><td> Testing Suite                            </td><td>     7 </td></tr>
<tr><td> Tinderbox Configuration                  </td><td>     7 </td></tr>
<tr><td> Build Config                             </td><td>     7 </td></tr>
<tr><td> Networking: SMTP                         </td><td>     6 </td></tr>
<tr><td> nl-NL / Dutch                            </td><td>     6 </td></tr>
<tr><td> Core                                     </td><td>     6 </td></tr>
<tr><td> Plugin Finder Service                    </td><td>     6 </td></tr>
<tr><td> History                                  </td><td>     6 </td></tr>
<tr><td> Reporter                                 </td><td>     6 </td></tr>
<tr><td> Preferences                              </td><td>     6 </td></tr>
<tr><td> Account Manager                          </td><td>     6 </td></tr>
<tr><td> LDAP XPCOM SDK                           </td><td>     6 </td></tr>
<tr><td> Search                                   </td><td>     6 </td></tr>
<tr><td> MailNews: Import                         </td><td>     6 </td></tr>
<tr><td> Bookmarks                                </td><td>     6 </td></tr>
<tr><td> Skinability                              </td><td>     6 </td></tr>
<tr><td> GFX: BeOS                                </td><td>     6 </td></tr>
<tr><td> Migration                                </td><td>     6 </td></tr>
<tr><td> XPCOM Registry                           </td><td>     5 </td></tr>
<tr><td> QuickLaunch (AKA turbo mode)             </td><td>     5 </td></tr>
<tr><td> English US                               </td><td>     5 </td></tr>
<tr><td> MailNews: Palm Sync                      </td><td>     5 </td></tr>
<tr><td> View Source                              </td><td>     5 </td></tr>
<tr><td> Page Layout                              </td><td>     5 </td></tr>
<tr><td> Layout: Floats                           </td><td>     5 </td></tr>
<tr><td> HTML Form Controls                       </td><td>     5 </td></tr>
<tr><td> Preferences                              </td><td>     5 </td></tr>
<tr><td> Widget: Cocoa                            </td><td>     5 </td></tr>
<tr><td> es-ES / Spanish                          </td><td>     5 </td></tr>
<tr><td> Accessibility                            </td><td>     5 </td></tr>
<tr><td> Localization                             </td><td>     5 </td></tr>
<tr><td> Widget: BeOS                             </td><td>     5 </td></tr>
<tr><td> Password Manager                         </td><td>     5 </td></tr>
<tr><td> Printing: Xprint                         </td><td>     5 </td></tr>
<tr><td> File Handling                            </td><td>     4 </td></tr>
<tr><td> Disability Access                        </td><td>     4 </td></tr>
<tr><td> Library                                  </td><td>     4 </td></tr>
<tr><td> Migration                                </td><td>     4 </td></tr>
<tr><td> he-IL / Hebrew                           </td><td>     4 </td></tr>
<tr><td> Embedding: Packaging                     </td><td>     4 </td></tr>
<tr><td> XTF                                      </td><td>     4 </td></tr>
<tr><td> Layout: Canvas                           </td><td>     4 </td></tr>
<tr><td> libical                                  </td><td>     4 </td></tr>
<tr><td> Bug Import/Export & Moving               </td><td>     4 </td></tr>
<tr><td> LDAP Java SDK                            </td><td>     4 </td></tr>
<tr><td> MailNews: Subscribe                      </td><td>     4 </td></tr>
<tr><td> MailNews: Notification                   </td><td>     4 </td></tr>
<tr><td> XP Apps: Autocomplete                    </td><td>     4 </td></tr>
<tr><td> Widget                                   </td><td>     4 </td></tr>
<tr><td> Trademark Permissions                    </td><td>     4 </td></tr>
<tr><td> developer.mozilla.org                    </td><td>     4 </td></tr>
<tr><td> Startup and Profile System               </td><td>     4 </td></tr>
<tr><td> History                                  </td><td>     3 </td></tr>
<tr><td> it-IT / Italian                          </td><td>     3 </td></tr>
<tr><td> Despot                                   </td><td>     3 </td></tr>
<tr><td> MailNews: Localization                   </td><td>     3 </td></tr>
<tr><td> WebDAV                                   </td><td>     3 </td></tr>
<tr><td> Administration                           </td><td>     3 </td></tr>
<tr><td> IPC                                      </td><td>     3 </td></tr>
<tr><td> GFX: Thebes                              </td><td>     3 </td></tr>
<tr><td> Layout: R & A Pos                        </td><td>     3 </td></tr>
<tr><td> XULRunner                                </td><td>     3 </td></tr>
<tr><td> Server Operations                        </td><td>     3 </td></tr>
<tr><td> Talkback Client                          </td><td>     3 </td></tr>
<tr><td> GFX: OS/2                                </td><td>     3 </td></tr>
<tr><td> Sample Code                              </td><td>     3 </td></tr>
<tr><td> Java-Implemented Plugins                 </td><td>     3 </td></tr>
<tr><td> JavaScript Console                       </td><td>     3 </td></tr>
<tr><td> Tinderbox2                               </td><td>     3 </td></tr>
<tr><td> Whining                                  </td><td>     3 </td></tr>
<tr><td> RSS Discovery and Preview                </td><td>     2 </td></tr>
<tr><td> Toolbars and Toolbar Customization       </td><td>     2 </td></tr>
<tr><td> Security: S/MIME                         </td><td>     2 </td></tr>
<tr><td> Keyboard: Find as you Type               </td><td>     2 </td></tr>
<tr><td> Listings                                 </td><td>     2 </td></tr>
<tr><td> libxpical                                </td><td>     2 </td></tr>
<tr><td> en-GB / English, United Kingdom          </td><td>     2 </td></tr>
<tr><td> Build Config                             </td><td>     2 </td></tr>
<tr><td> Tinderbox3                               </td><td>     2 </td></tr>
<tr><td> Build Config                             </td><td>     2 </td></tr>
<tr><td> CA Certificates                          </td><td>     2 </td></tr>
<tr><td> tr-TR / Turkish                          </td><td>     2 </td></tr>
<tr><td> Doctor                                   </td><td>     2 </td></tr>
<tr><td> Help Documentation                       </td><td>     2 </td></tr>
<tr><td> pl-PL / Polish                           </td><td>     2 </td></tr>
<tr><td> Embedding: GRE Core                      </td><td>     2 </td></tr>
<tr><td> DOM: Load and Save                       </td><td>     2 </td></tr>
<tr><td> cs-CZ / Czech                            </td><td>     2 </td></tr>
<tr><td> Keyboard Navigation                      </td><td>     2 </td></tr>
<tr><td> OS Integration                           </td><td>     2 </td></tr>
<tr><td> Installer: GRE                           </td><td>     2 </td></tr>
<tr><td> MailNews: Movemail                       </td><td>     2 </td></tr>
<tr><td> Layout: Images                           </td><td>     2 </td></tr>
<tr><td> Security                                 </td><td>     2 </td></tr>
<tr><td> Location Bar & Autocomplete              </td><td>     2 </td></tr>
<tr><td> Korean                                   </td><td>     1 </td></tr>
<tr><td> General                                  </td><td>     1 </td></tr>
<tr><td> MailNews: Return Receipts                </td><td>     1 </td></tr>
<tr><td> Widget: OS/2                             </td><td>     1 </td></tr>
<tr><td> Printing                                 </td><td>     1 </td></tr>
<tr><td> MailNews: Search                         </td><td>     1 </td></tr>
<tr><td> GFX: Xlib                                </td><td>     1 </td></tr>
<tr><td> Downloading                              </td><td>     1 </td></tr>
<tr><td> Form Manager                             </td><td>     1 </td></tr>
<tr><td> Security                                 </td><td>     1 </td></tr>
<tr><td> Viewer App                               </td><td>     1 </td></tr>
<tr><td> Installer                                </td><td>     1 </td></tr>
<tr><td> Registration & Management                </td><td>     1 </td></tr>
<tr><td> Form Manager                             </td><td>     1 </td></tr>
<tr><td> Composer CSS Editor                      </td><td>     1 </td></tr>
<tr><td> CCK                                      </td><td>     1 </td></tr>
<tr><td> Security                                 </td><td>     1 </td></tr>
<tr><td> Installer                                </td><td>     1 </td></tr>
<tr><td> User Interface                           </td><td>     1 </td></tr>
<tr><td> MailNews: Printing                       </td><td>     1 </td></tr>
<tr><td> Compiler                                 </td><td>     1 </td></tr>
<tr><td> CVS Account Request                      </td><td>     1 </td></tr>
<tr><td> Business Development                     </td><td>     1 </td></tr>
<tr><td> Drag & Drop                              </td><td>     1 </td></tr>
<tr><td> nb-NO / Norwegian bokmal                 </td><td>     1 </td></tr>
<tr><td> Plugin Listings                          </td><td>     1 </td></tr>
<tr><td> Tabbed Browsing                          </td><td>     1 </td></tr>
<tr><td> Page Info                                </td><td>     1 </td></tr>
<tr><td> Tests                                    </td><td>     1 </td></tr>
<tr><td> Product Site                             </td><td>     1 </td></tr>
<tr><td> Toolbars & Menus                         </td><td>     1 </td></tr>
<tr><td> SQL                                      </td><td>     1 </td></tr>
</table>

* The review page shows the date that the patch was posted to bugzilla, not the date that review was requested. For how many patches do these dates significantly differ (eg by more than two weeks)?

 SELECT count(*) from attachments INNER JOIN bugs ON attachments.bug_id = 
 bugs.bug_id INNER JOIN flags on attachments.attach_id = flags.attach_id INNER 
 JOIN flagtypes ON flags.type_id = flagtypes.id WHERE flagtypes.name = 'review' 
 AND ispatch = 1 AND isobsolete = 0 AND resolution = "" AND  
 (TO_DAYS(flags.creation_date) - TO_DAYS(attachments.creation_ts) > 14);

362 (4.7%)

* How man/what percentage of patches have r? set without an email target?

 SELECT bugs.bug_id from attachments INNER JOIN bugs ON attachments.bug_id =  
 bugs.bug_id INNER JOIN flags on attachments.attach_id = flags.attach_id INNER  
 JOIN flagtypes ON flags.type_id = flagtypes.id WHERE flagtypes.name = 'review'
 AND flags.status = "?" AND requestee_id IS NULL AND ispatch = 1 AND isobsolete
 = 0 AND resolution = "";

71 (0.9%)

<table border="1">
<tr><td> 279181 </td></tr>
<tr><td> 161018 </td></tr>
<tr><td> 191752 </td></tr>
<tr><td> 232720 </td></tr>
<tr><td> 148726 </td></tr>
<tr><td> 182076 </td></tr>
<tr><td> 175175 </td></tr>
<tr><td> 248448 </td></tr>
<tr><td> 248450 </td></tr>
<tr><td> 182076 </td></tr>
<tr><td> 105960 </td></tr>
<tr><td> 239499 </td></tr>
<tr><td> 211808 </td></tr>
<tr><td> 284279 </td></tr>
<tr><td> 284755 </td></tr>
<tr><td> 284755 </td></tr>
<tr><td> 279035 </td></tr>
<tr><td> 268448 </td></tr>
<tr><td> 289864 </td></tr>
<tr><td> 289864 </td></tr>
<tr><td> 289864 </td></tr>
<tr><td> 214551 </td></tr>
<tr><td> 300421 </td></tr>
<tr><td> 303647 </td></tr>
<tr><td> 306978 </td></tr>
<tr><td> 236721 </td></tr>
<tr><td> 307228 </td></tr>
<tr><td> 171529 </td></tr>
<tr><td> 301945 </td></tr>
<tr><td> 301945 </td></tr>
<tr><td> 310299 </td></tr>
<tr><td> 310299 </td></tr>
<tr><td> 276232 </td></tr>
<tr><td> 315616 </td></tr>
<tr><td> 218746 </td></tr>
<tr><td> 276075 </td></tr>
<tr><td> 282631 </td></tr>
<tr><td>  65493 </td></tr>
<tr><td> 288038 </td></tr>
<tr><td> 314871 </td></tr>
<tr><td> 312537 </td></tr>
<tr><td> 324291 </td></tr>
<tr><td> 304546 </td></tr>
<tr><td> 327124 </td></tr>
<tr><td> 267108 </td></tr>
<tr><td> 328406 </td></tr>
<tr><td> 328407 </td></tr>
<tr><td> 329205 </td></tr>
<tr><td>  45715 </td></tr>
<tr><td> 323783 </td></tr>
<tr><td> 181446 </td></tr>
<tr><td> 314871 </td></tr>
<tr><td> 125995 </td></tr>
<tr><td> 125995 </td></tr>
<tr><td> 330255 </td></tr>
<tr><td> 329205 </td></tr>
<tr><td> 182082 </td></tr>
<tr><td> 282687 </td></tr>
<tr><td> 331102 </td></tr>
<tr><td> 320751 </td></tr>
<tr><td> 327269 </td></tr>
<tr><td> 331366 </td></tr>
<tr><td> 330600 </td></tr>
<tr><td> 330600 </td></tr>
<tr><td> 331198 </td></tr>
<tr><td> 332066 </td></tr>
<tr><td> 332068 </td></tr>
<tr><td> 332069 </td></tr>
<tr><td> 332128 </td></tr>
<tr><td> 332190 </td></tr>
<tr><td> 328628 </td></tr>
</table>

* How many/what percentage of patches have no apparent communication from the reviewer that the review will not be immediately forthcoming?

Can't tell automatically.

* Of patches that do have such communication, how many/what percentage is incorrect (ie the reviewer said "I'll review next week", but that didn't happen)?

Can't tell automatically.

* What percentage have already gone through an iteration of the review process? Of those that have, how many / what percentage have already been reviewed by the same person on whom review is currently waiting?

Can't tell automatically.

* How many/what percentage have review requests set against people who are no longer active in the project? 

We have to define "no longer active" as "no logincookies entry" (i.e. not logged in in the past 30 days), because Bugzilla keeps no other information on this question.

 SELECT profiles.login_name AS name, count(flags.requestee_id) AS reviews FROM 
 profiles LEFT JOIN logincookies ON profiles.userid = logincookies.userid INNER 
 JOIN flags ON flags.requestee_id = profiles.userid INNER JOIN flagtypes ON 
 flags.type_id = flagtypes.id INNER JOIN attachments ON attachments.attach_id = 
 flags.attach_id INNER JOIN bugs ON attachments.bug_id = bugs.bug_id WHERE 
 logincookies.userid IS NULL AND flagtypes.name = 'review' AND 
 attachments.ispatch = 1 AND attachments.isobsolete = 0 AND bugs.resolution = "" 
 GROUP BY name ORDER BY reviews DESC;

<table border="1">
<tr><td> name                             </td><td> reviews </td></tr>
<tr><td> adamlock@eircom.net              </td><td>       7 </td></tr>
<tr><td> beng@google.com                  </td><td>       4 </td></tr>
<tr><td> hyatt@mozilla.org                </td><td>       4 </td></tr>
<tr><td> roland.mainz@nrubsig.org         </td><td>       4 </td></tr>
<tr><td> timeless@myrealbox.com           </td><td>       3 </td></tr>
<tr><td> ccarlen@mac.com                  </td><td>       3 </td></tr>
<tr><td> hewitt@formerly-netscape.com.tld </td><td>       3 </td></tr>
<tr><td> leaf@mozilla.org                 </td><td>       3 </td></tr>
<tr><td> p_ch@verizon.net                 </td><td>       3 </td></tr>
<tr><td> documentation@bugzilla.bugs      </td><td>       3 </td></tr>
<tr><td> beng.bugs@gmail.com              </td><td>       2 </td></tr>
<tr><td> john@johnkeiser.com              </td><td>       2 </td></tr>
<tr><td> rmegginson0224@aol.com           </td><td>       2 </td></tr>
<tr><td> kinmoz@netscape.net              </td><td>       2 </td></tr>
<tr><td> jband_mozilla@rattlebrain.com    </td><td>       2 </td></tr>
<tr><td> mpgritti@gmail.com               </td><td>       2 </td></tr>
<tr><td> imajes@php.net                   </td><td>       1 </td></tr>
<tr><td> ftang@formerly-netscape.com.tld  </td><td>       1 </td></tr>
<tr><td> law@formerly-netscape.com.tld    </td><td>       1 </td></tr>
<tr><td> bernd.mielke@gmx.de              </td><td>       1 </td></tr>
<tr><td> tara@tequilarista.org            </td><td>       1 </td></tr>
<tr><td> namachi@gmail.com                </td><td>       1 </td></tr>
<tr><td> samir_bugzilla@yahoo.com         </td><td>       1 </td></tr>
<tr><td> jdunn@maine.rr.com               </td><td>       1 </td></tr>
<tr><td> janidarshan@yahoo.com            </td><td>       1 </td></tr>
<tr><td> mozilla@rjcdb.com                </td><td>       1 </td></tr>
<tr><td> braddr@puremagic.com             </td><td>       1 </td></tr>
<tr><td> lordpixel@mac.com                </td><td>       1 </td></tr>
<tr><td> jrgmorrison@aol.com              </td><td>       1 </td></tr>
<tr><td> scc@mozilla.org                  </td><td>       1 </td></tr>
<tr><td> zack@kde.org                     </td><td>       1 </td></tr>
<tr><td> erhyuan@pacbell.net              </td><td>       1 </td></tr>
<tr><td> john.schneider@agiledelta.com    </td><td>       1 </td></tr>
<tr><td> vladimir+bm@vlad1.com            </td><td>       1 </td></tr>
<tr><td> waldemar@acm.org                 </td><td>       1 </td></tr>
<tr><td> limval@yahoo.com                 </td><td>       1 </td></tr>
<tr><td> me@mollyandgeoff.com             </td><td>       1 </td></tr>
<tr><td> browser-china-ab@sun.com         </td><td>       1 </td></tr>
<tr><td> harabai@hotmail.com              </td><td>       1 </td></tr>
<tr><td> composer@editor.bugs             </td><td>       1 </td></tr>
<tr><td> bryner@gmail.com                 </td><td>       1 </td></tr>
<tr><td> julien.pierre.track@sun.com      </td><td>       1 </td></tr>
<tr><td> kevdig@hypersurf.com             </td><td>       1 </td></tr>
<tr><td> mconners@mconners.com            </td><td>       1 </td></tr>
</table>

* How many such inactive review requestees are there?

44

* How many/what percentage are large enough and old enough that they're likely to have bitrotted and no longer be applicable to the current trunk?

See above: the total count is 77, which is not really significant compared to the total of 7713.

* How many/what percentage include complaints about the lack of review?

Can't tell automatically.