statistics from patchworks?

Jeremy Kerr jk at ozlabs.org
Tue Oct 9 21:01:21 EST 2012


Hi Stephen & David,

So, I've done a couple of queries on the netdev patchset that I think
might be useful for you:

First, a breakdown by current state:

       state       | count
-------------------+-------
 Not Applicable    |  7588
 Changes Requested |  6364
 Awaiting Upstream |   705
 Under Review      |     3
 New               |     3
 Accepted          | 21653
 Deferred          |   386
 Superseded        |  2661
 Rejected          |  1679
 RFC               |  4106
(10 rows)

Second, a breakdown of current state vs. patch size. The columns are:

 * the patch size, given as the log (base-2) of the length of the
   patch's content.

 * the state id and name

 * the number of patches with that fit into the (state, size) category

 * the total number of patches with the same log(2, size).

For example, the first row tells us that there are 5742 patches that are
have a size in the range [2^8, 2^9) bytes, and 2 of those patches are in
the 'New' state.

 log_size | state |       name        |  n   | total_n
----------+-------+-------------------+------+---------
        8 |     1 | New               |    2 |    5742
       11 |     1 | New               |    1 |    7824
        8 |     2 | Under Review      |    2 |    5742
        9 |     2 | Under Review      |    1 |    9474
        7 |     3 | Accepted          |   14 |      29
        8 |     3 | Accepted          | 3210 |    5742
        9 |     3 | Accepted          | 5211 |    9474
       10 |     3 | Accepted          | 4469 |    8725
       11 |     3 | Accepted          | 3542 |    7824
       12 |     3 | Accepted          | 2546 |    6053
       13 |     3 | Accepted          | 1294 |    3502
       14 |     3 | Accepted          |  662 |    1928
       15 |     3 | Accepted          |  290 |     961
       16 |     3 | Accepted          |  108 |     398
       17 |     3 | Accepted          |   51 |     170
       18 |     3 | Accepted          |    4 |      23
        7 |     4 | Rejected          |    3 |      29
        8 |     4 | Rejected          |  252 |    5742
        9 |     4 | Rejected          |  409 |    9474
       10 |     4 | Rejected          |  351 |    8725
       11 |     4 | Rejected          |  281 |    7824
       12 |     4 | Rejected          |  180 |    6053
       13 |     4 | Rejected          |   97 |    3502
       14 |     4 | Rejected          |   48 |    1928
       15 |     4 | Rejected          |   31 |     961
       16 |     4 | Rejected          |   14 |     398
       17 |     4 | Rejected          |    8 |     170
       18 |     4 | Rejected          |    3 |      23
        8 |     5 | RFC               |  399 |    5742
        9 |     5 | RFC               |  656 |    9474
       10 |     5 | RFC               |  730 |    8725
       11 |     5 | RFC               |  775 |    7824
       12 |     5 | RFC               |  680 |    6053
       13 |     5 | RFC               |  451 |    3502
       14 |     5 | RFC               |  267 |    1928
       15 |     5 | RFC               |   97 |     961
       16 |     5 | RFC               |   39 |     398
       17 |     5 | RFC               |   12 |     170
        6 |     6 | Not Applicable    |    1 |       1
        7 |     6 | Not Applicable    |   10 |      29
        8 |     6 | Not Applicable    |  932 |    5742
        9 |     6 | Not Applicable    | 1383 |    9474
       10 |     6 | Not Applicable    | 1392 |    8725
       11 |     6 | Not Applicable    | 1321 |    7824
       12 |     6 | Not Applicable    | 1107 |    6053
       13 |     6 | Not Applicable    |  691 |    3502
       14 |     6 | Not Applicable    |  412 |    1928
       15 |     6 | Not Applicable    |  199 |     961
       16 |     6 | Not Applicable    |   75 |     398
       17 |     6 | Not Applicable    |   32 |     170
       18 |     6 | Not Applicable    |    3 |      23
        7 |     7 | Changes Requested |    2 |      29
        8 |     7 | Changes Requested |  555 |    5742
        9 |     7 | Changes Requested | 1067 |    9474
       10 |     7 | Changes Requested | 1078 |    8725
       11 |     7 | Changes Requested | 1193 |    7824
       12 |     7 | Changes Requested |  985 |    6053
       13 |     7 | Changes Requested |  611 |    3502
       14 |     7 | Changes Requested |  379 |    1928
       15 |     7 | Changes Requested |  265 |     961
       16 |     7 | Changes Requested |  132 |     398
       17 |     7 | Changes Requested |   58 |     170
       18 |     7 | Changes Requested |   12 |      23
        8 |     8 | Awaiting Upstream |   72 |    5742
        9 |     8 | Awaiting Upstream |  130 |    9474
       10 |     8 | Awaiting Upstream |  142 |    8725
       11 |     8 | Awaiting Upstream |  125 |    7824
       12 |     8 | Awaiting Upstream |  111 |    6053
       13 |     8 | Awaiting Upstream |   68 |    3502
       14 |     8 | Awaiting Upstream |   35 |    1928
       15 |     8 | Awaiting Upstream |   16 |     961
       16 |     8 | Awaiting Upstream |    3 |     398
       17 |     8 | Awaiting Upstream |    1 |     170
        8 |     9 | Superseded        |  301 |    5742
        9 |     9 | Superseded        |  541 |    9474
       10 |     9 | Superseded        |  484 |    8725
       11 |     9 | Superseded        |  498 |    7824
       12 |     9 | Superseded        |  378 |    6053
       13 |     9 | Superseded        |  254 |    3502
       14 |     9 | Superseded        |  114 |    1928
       15 |     9 | Superseded        |   59 |     961
       16 |     9 | Superseded        |   20 |     398
       17 |     9 | Superseded        |    6 |     170
       18 |     9 | Superseded        |    1 |      23
        8 |    10 | Deferred          |   17 |    5742
        9 |    10 | Deferred          |   76 |    9474
       10 |    10 | Deferred          |   79 |    8725
       11 |    10 | Deferred          |   88 |    7824
       12 |    10 | Deferred          |   66 |    6053
       13 |    10 | Deferred          |   36 |    3502
       14 |    10 | Deferred          |   11 |    1928
       15 |    10 | Deferred          |    4 |     961
       16 |    10 | Deferred          |    7 |     398
       17 |    10 | Deferred          |    2 |     170
(94 rows)

I've also attached the SQL used to generate these data, which you may
want to review before using it for anything serious. Also, let me know
if you'd like these queries re-done with different parameters (is the
log-2 suitable?), the output in a different format, or some other
analysis of the patchset.

Like I said, there's no historical log for the updates to a patch, but
it's sounding like that would be a good feature for me to add.

Cheers,


Jeremy
-------------- next part --------------
A non-text attachment was scrubbed...
Name: patchwork-stats.sql
Type: text/x-sql
Size: 1282 bytes
Desc: not available
URL: <http://lists.ozlabs.org/pipermail/patchwork/attachments/20121009/47caa991/attachment.bin>


More information about the Patchwork mailing list