User:Catrope/CR stats

Breakdown of revisions by status in /trunk/phase3
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; +---+---+ +---+---+ +---+---+ 8 rows in set (3.98 sec)
 * cr_status | COUNT(DISTINCT cr_id) |
 * deferred |                  1320 |
 * fixme    |                    50 |
 * new      |                   715 |
 * ok       |                 17054 |
 * old      |                 11839 |
 * resolved |                   860 |
 * reverted |                   567 |
 * verified |                    13 |

Top 50 commenters by number of comments
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; +--+--+-+---+ +--+--+-+---+ +--+--+-+---+ 50 rows in set (0.21 sec)
 * cc_user_text    | comments | totalLength | avgLength |
 * Brion VIBBER    |     1153 |      169945 |  147.3938 |
 * Catrope         |     1100 |      290358 |  263.9618 |
 * Tim Starling    |      858 |      221889 |  258.6119 |
 * Nikerabbit      |      633 |      111748 |  176.5371 |
 * ^demon          |      594 |       77439 |  130.3687 |
 * Simetrical      |      572 |      165488 |  289.3147 |
 * Platonides      |      524 |       89370 |  170.5534 |
 * Siebrand        |      509 |       76329 |  149.9587 |
 * Aaron Schulz    |      500 |       32673 |   65.3460 |
 * Reedy           |      374 |       49936 |  133.5187 |
 * Raymond         |      358 |       70116 |  195.8547 |
 * Bryan           |      334 |       46561 |  139.4042 |
 * Werdna          |      288 |       33890 |  117.6736 |
 * Trevor Parscal  |      267 |       48941 |  183.2996 |
 * MaxSem          |      213 |       27951 |  131.2254 |
 * MarkAHershberger |     202 |       34591 |  171.2426 |
 * Hashar          |      195 |       20949 |  107.4308 |
 * Jeroen De Dauw  |      184 |       24909 |  135.3750 |
 * IAlex           |      138 |       16032 |  116.1739 |
 * Mdale           |      132 |       31701 |  240.1591 |
 * Kaldari         |      117 |       17877 |  152.7949 |
 * Voice of All    |       90 |        6591 |   73.2333 |
 * MZMcBride       |       78 |       15178 |  194.5897 |
 * NeilK           |       73 |       23215 |  318.0137 |
 * Happy-melon     |       70 |       16462 |  235.1714 |
 * Duesentrieb     |       70 |        9807 |  140.1000 |
 * OverlordQ       |       62 |       14761 |  238.0806 |
 * TheDJ           |       59 |        9944 |  168.5424 |
 * PhiLiP          |       56 |        9865 |  176.1607 |
 * Mr.Z-man        |       53 |       10766 |  203.1321 |
 * Jack Phoenix    |       50 |       18080 |  361.6000 |
 * Umherirrender   |       46 |        7963 |  173.1087 |
 * Adammiller      |       45 |        9257 |  205.7111 |
 * Skizzerz        |       44 |       24741 |  562.2955 |
 * Ilmari Karonen  |       43 |       14899 |  346.4884 |
 * Danny B.        |       42 |       12058 |  287.0952 |
 * Church of emacs |       42 |       12720 |  302.8571 |
 * Shinjiman       |       41 |        6877 |  167.7317 |
 * Awjrichards     |       40 |       15184 |  379.6000 |
 * Freakolowsky    |       38 |        6557 |  172.5526 |
 * Remember the dot |      35 |       16883 |  482.3714 |
 * ThomasV         |       35 |        5150 |  147.1429 |
 * Yaron Koren     |       34 |        5247 |  154.3235 |
 * Jbeigel         |       32 |        5496 |  171.7500 |
 * Gurch           |       31 |        7380 |  238.0645 |
 * Bawolff         |       30 |        8063 |  268.7667 |
 * X!              |       28 |        3039 |  108.5357 |
 * Nimish Gautam   |       28 |        3801 |  135.7500 |
 * Mormegil        |       27 |        7635 |  282.7778 |
 * Peachey88       |       27 |        4405 |  163.1481 |

Distribution of unreviewed revisions in phase3
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; +-+--+ +-+--+ +-+--+ 135 rows in set (0.07 sec)
 * hundred | COUNT(*) |
 * 523 |       1 |
 * 605 |       1 |
 * 619 |       2 |
 * 630 |       1 |
 * 635 |       1 |
 * 640 |       1 |
 * 641 |       2 |
 * 642 |       3 |
 * 643 |       1 |
 * 644 |       1 |
 * 646 |       2 |
 * 647 |       2 |
 * 648 |       7 |
 * 649 |       5 |
 * 650 |       3 |
 * 651 |       4 |
 * 653 |       7 |
 * 654 |       1 |
 * 655 |       4 |
 * 656 |       4 |
 * 657 |       2 |
 * 658 |       5 |
 * 659 |       5 |
 * 660 |       4 |
 * 662 |       7 |
 * 664 |       1 |
 * 665 |       3 |
 * 666 |      12 |
 * 667 |       3 |
 * 668 |       5 |
 * 669 |       8 |
 * 670 |       4 |
 * 671 |       2 |
 * 672 |       4 |
 * 674 |       2 |
 * 675 |       2 |
 * 676 |       3 |
 * 677 |       4 |
 * 678 |       5 |
 * 679 |       4 |
 * 680 |       4 |
 * 681 |       6 |
 * 682 |       7 |
 * 683 |      13 |
 * 684 |       3 |
 * 685 |       7 |
 * 686 |       4 |
 * 687 |       3 |
 * 688 |       5 |
 * 689 |       5 |
 * 690 |       6 |
 * 691 |      12 |
 * 692 |      11 |
 * 693 |       2 |
 * 694 |       6 |
 * 695 |       6 |
 * 696 |       4 |
 * 697 |       4 |
 * 698 |      10 |
 * 699 |      10 |
 * 700 |       6 |
 * 701 |       9 |
 * 702 |       6 |
 * 703 |       5 |
 * 704 |      20 |
 * 705 |      20 |
 * 706 |       9 |
 * 707 |      15 |
 * 708 |      10 |
 * 709 |      15 |
 * 710 |       5 |
 * 711 |      11 |
 * 712 |       5 |
 * 713 |       7 |
 * 714 |      11 |
 * 715 |       7 |
 * 716 |       2 |
 * 717 |       6 |
 * 718 |       5 |
 * 719 |       3 |
 * 720 |       1 |
 * 721 |       6 |
 * 722 |       5 |
 * 723 |      10 |
 * 724 |       3 |
 * 725 |       6 |
 * 726 |       2 |
 * 727 |       5 |
 * 728 |       7 |
 * 729 |       4 |
 * 730 |       1 |
 * 731 |       4 |
 * 732 |       1 |
 * 733 |       1 |
 * 734 |       1 |
 * 735 |       2 |
 * 736 |       2 |
 * 737 |       2 |
 * 738 |       1 |
 * 739 |       7 |
 * 740 |       2 |
 * 741 |       4 |
 * 742 |       2 |
 * 745 |       2 |
 * 746 |       3 |
 * 747 |       5 |
 * 748 |       6 |
 * 749 |      10 |
 * 750 |       6 |
 * 752 |       6 |
 * 753 |      10 |
 * 754 |       9 |
 * 755 |      13 |
 * 756 |      13 |
 * 757 |      16 |
 * 758 |      10 |
 * 759 |       6 |
 * 760 |       2 |
 * 761 |      12 |
 * 762 |      19 |
 * 763 |      13 |
 * 764 |       6 |
 * 765 |       3 |
 * 766 |       3 |
 * 767 |       2 |
 * 768 |       4 |
 * 769 |       3 |
 * 770 |       3 |
 * 771 |       6 |
 * 772 |       4 |
 * 773 |       7 |
 * 774 |       5 |
 * 775 |       8 |
 * 776 |      13 |
 * 777 |      15 |