User:Catrope/CR stats

Breakdown of revisions by status in /trunk/phase3

edit
mysql> SELECT cr_status, COUNT(DISTINCT cr_id) FROM code_rev, code_paths WHERE cr_repo_id=1 AND cp_repo_id=1 AND cp_rev_id=cr_id AND cp_path LIKE '/trunk/phase3%' GROUP BY cr_status;
+-----------+-----------------------+
| cr_status | COUNT(DISTINCT cr_id) |
+-----------+-----------------------+
| deferred  |                  1331 |
| fixme     |                    47 |
| new       |                   582 |
| ok        |                 17403 |
| old       |                 11838 |
| resolved  |                   886 |
| reverted  |                   589 |
+-----------+-----------------------+
7 rows in set (28.98 sec)

Top 50 commenters by number of comments

edit
mysql> SELECT cc_user_text, COUNT(*) AS comments, SUM(length) AS totalLength, SUM(length)/COUNT(*) AS avgLength FROM (SELECT cc_user_text, LENGTH(cc_text) AS length FROM code_comment) AS d GROUP BY cc_user_text ORDER BY comments DESC LIMIT 50;
+------------------+----------+-------------+-----------+
| cc_user_text     | comments | totalLength | avgLength |
+------------------+----------+-------------+-----------+
| Catrope          |     1183 |      307775 |  260.1648 |
| Brion VIBBER     |     1153 |      169945 |  147.3938 |
| Tim Starling     |      870 |      225507 |  259.2034 |
| Nikerabbit       |      674 |      117248 |  173.9585 |
| ^demon           |      638 |       81190 |  127.2571 |
| Simetrical       |      572 |      165488 |  289.3147 |
| Platonides       |      563 |       93844 |  166.6856 |
| Aaron Schulz     |      522 |       34314 |   65.7356 |
| Siebrand         |      512 |       76536 |  149.4844 |
| Reedy            |      405 |       53889 |  133.0593 |
| Raymond          |      361 |       71431 |  197.8698 |
| Bryan            |      360 |       49401 |  137.2250 |
| Werdna           |      310 |       36861 |  118.9065 |
| Trevor Parscal   |      283 |       51989 |  183.7067 |
| MaxSem           |      220 |       28214 |  128.2455 |
| MarkAHershberger |      217 |       36882 |  169.9631 |
| Hashar           |      204 |       23199 |  113.7206 |
| Jeroen De Dauw   |      193 |       25660 |  132.9534 |
| IAlex            |      150 |       17344 |  115.6267 |
| Mdale            |      132 |       31701 |  240.1591 |
| Kaldari          |      120 |       18251 |  152.0917 |
| Voice of All     |       90 |        6591 |   73.2333 |
| MZMcBride        |       86 |       16162 |  187.9302 |
| Happy-melon      |       74 |       16790 |  226.8919 |
| NeilK            |       73 |       23215 |  318.0137 |
| Duesentrieb      |       70 |        9807 |  140.1000 |
| OverlordQ        |       63 |       14801 |  234.9365 |
| TheDJ            |       62 |       10213 |  164.7258 |
| PhiLiP           |       56 |        9865 |  176.1607 |
| Mr.Z-man         |       53 |       10766 |  203.1321 |
| Jack Phoenix     |       51 |       18117 |  355.2353 |
| Ilmari Karonen   |       46 |       15726 |  341.8696 |
| Umherirrender    |       46 |        7963 |  173.1087 |
| Adammiller       |       45 |        9257 |  205.7111 |
| Skizzerz         |       44 |       24741 |  562.2955 |
| Danny B.         |       42 |       12058 |  287.0952 |
| Church of emacs  |       42 |       12720 |  302.8571 |
| Shinjiman        |       41 |        6877 |  167.7317 |
| Awjrichards      |       41 |       15290 |  372.9268 |
| Freakolowsky     |       38 |        6557 |  172.5526 |
| Yaron Koren      |       37 |        5892 |  159.2432 |
| Remember the dot |       35 |       16883 |  482.3714 |
| ThomasV          |       35 |        5150 |  147.1429 |
| Dantman          |       34 |       14495 |  426.3235 |
| Krinkle          |       34 |        8112 |  238.5882 |
| Jbeigel          |       32 |        5496 |  171.7500 |
| Gurch            |       31 |        7380 |  238.0645 |
| Bawolff          |       30 |        8063 |  268.7667 |
| Peachey88        |       29 |        4753 |  163.8966 |
| X!               |       28 |        3039 |  108.5357 |
+------------------+----------+-------------+-----------+
50 rows in set (0.49 sec)

Distribution of unreviewed revisions in phase3

edit
mysql> SELECT hundred, COUNT(*) FROM (
  SELECT FLOOR(id/100) AS hundred FROM (
    SELECT DISTINCT(cr_id) AS id
    FROM code_rev, code_paths
    WHERE cr_status IN ('new', 'fixme') AND cr_repo_id=1 AND cp_repo_id=1 AND cp_rev_id=cr_id
    AND cp_path LIKE '/trunk/phase3%'
  ) AS a
) AS b GROUP BY hundred;
+---------+----------+
| hundred | COUNT(*) |
+---------+----------+
|     523 |        1 |
|     605 |        1 |
|     619 |        2 |
|     630 |        1 |
|     641 |        2 |
|     642 |        2 |
|     644 |        1 |
|     647 |        2 |
|     648 |        3 |
|     649 |        3 |
|     650 |        2 |
|     653 |        4 |
|     654 |        1 |
|     655 |        4 |
|     656 |        3 |
|     657 |        1 |
|     658 |        1 |
|     659 |        2 |
|     660 |        1 |
|     662 |        6 |
|     664 |        1 |
|     665 |        2 |
|     666 |        9 |
|     667 |        3 |
|     668 |        4 |
|     669 |        5 |
|     670 |        2 |
|     671 |        1 |
|     672 |        3 |
|     674 |        1 |
|     677 |        2 |
|     678 |        5 |
|     679 |        3 |
|     680 |        2 |
|     681 |        1 |
|     682 |        4 |
|     683 |       13 |
|     684 |        2 |
|     685 |        5 |
|     686 |        3 |
|     687 |        2 |
|     688 |        4 |
|     689 |        5 |
|     690 |        4 |
|     691 |        8 |
|     692 |        4 |
|     694 |        4 |
|     695 |        6 |
|     696 |        3 |
|     697 |        1 |
|     698 |        5 |
|     699 |        6 |
|     700 |        4 |
|     701 |        7 |
|     702 |        3 |
|     703 |        2 |
|     704 |       15 |
|     705 |       15 |
|     706 |        7 |
|     707 |       11 |
|     708 |        5 |
|     709 |       14 |
|     710 |        3 |
|     711 |        1 |
|     712 |        1 |
|     713 |        6 |
|     714 |        7 |
|     715 |        4 |
|     716 |        1 |
|     717 |        3 |
|     718 |        5 |
|     719 |        3 |
|     720 |        1 |
|     721 |        2 |
|     722 |        3 |
|     723 |        9 |
|     724 |        3 |
|     725 |        4 |
|     726 |        1 |
|     727 |        5 |
|     728 |        5 |
|     729 |        2 |
|     731 |        3 |
|     732 |        1 |
|     733 |        1 |
|     734 |        1 |
|     735 |        2 |
|     736 |        2 |
|     737 |        2 |
|     738 |        1 |
|     739 |        4 |
|     740 |        1 |
|     741 |        4 |
|     742 |        2 |
|     745 |        2 |
|     746 |        3 |
|     747 |        5 |
|     748 |        4 |
|     749 |        6 |
|     750 |        6 |
|     752 |        5 |
|     753 |        7 |
|     754 |        7 |
|     755 |       13 |
|     756 |       10 |
|     757 |       10 |
|     758 |        6 |
|     759 |        4 |
|     760 |        1 |
|     761 |       11 |
|     762 |       15 |
|     763 |       11 |
|     764 |        4 |
|     765 |        2 |
|     766 |        3 |
|     767 |        2 |
|     768 |        4 |
|     769 |        2 |
|     770 |        3 |
|     771 |        6 |
|     772 |        4 |
|     773 |        7 |
|     774 |        5 |
|     775 |        7 |
|     776 |        7 |
|     777 |       11 |
|     778 |        7 |
|     779 |        7 |
|     780 |       18 |
|     781 |       19 |
|     782 |       22 |
|     783 |       21 |
+---------+----------+
132 rows in set (0.34 sec)