#4517 Gather updated activity stats

v1.0.0
closed
Tim Van Steenburgh
sf-1 (616)
General
Dave Brondsema
2015-08-20
2012-07-10
Tim Van Steenburgh
No

Same as [#3817], but with latest numbers.

Discussion

  • Tim Van Steenburgh - 2012-07-10

    1) Total number of registered SF developers

    alexandria_20120709=> select count(*) from users;
  count  
---------
 3698923
(1 row)

alexandria_20120709=> select count(*) from users where status = 'A';
  count  
---------
 3336705
(1 row)
     

  • Tim Van Steenburgh - 2012-07-10

    2) Average monthly number of new developers over the last year

    alexandria_20120227=> 
select extract(year from to_timestamp(add_date)) as theyear, 
       extract(month from to_timestamp(add_date)) as themonth, 
       count(*) 
from users 
where extract(year from to_timestamp(add_date)) > 2010
group by theyear, themonth;

 theyear | themonth | count 
---------+----------+-------
    2011 |        7 | 38898
    2011 |        8 | 37408
    2011 |        9 | 36231
    2011 |       10 | 37512
    2011 |       11 | 36490
    2011 |       12 | 42119
    2012 |        1 | 35708
    2012 |        2 | 36887
    2012 |        3 | 38625
    2012 |        4 | 34938
    2012 |        5 | 36765
    2012 |        6 | 34140
    2012 |        7 |  8610
(19 rows)
     

  • Tim Van Steenburgh - 2012-07-10

    3) Average monthly number of code commits over the last year

    db['zagg.scm'].findOne({_id:'repo-month:svn/2011-07-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2011-07-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2011-07-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2011-07-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2011-07-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2011-08-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2011-08-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2011-08-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2011-08-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2011-08-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2011-09-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2011-09-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2011-09-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2011-09-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2011-09-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2011-10-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2011-10-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2011-10-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2011-10-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2011-10-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2011-11-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2011-11-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2011-11-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2011-11-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2011-11-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2011-12-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2011-12-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2011-12-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2011-12-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2011-12-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2012-01-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2012-01-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2012-01-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2012-01-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2012-01-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2012-02-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2012-02-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2012-02-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2012-02-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2012-02-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2012-03-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2012-03-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2012-03-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2012-03-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2012-03-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2012-04-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2012-04-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2012-04-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2012-04-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2012-04-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2012-05-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2012-05-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2012-05-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2012-05-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2012-05-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2012-06-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2012-06-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2012-06-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2012-06-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2012-06-01'}).value.write
db['zagg.scm'].findOne({_id:'repo-month:svn/2012-07-01'}).value.write_txn + db['zagg.scm'].findOne({_id:'repo-month:cvs/2012-07-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:hg/2012-07-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:git/2012-07-01'}).value.write + db['zagg.scm'].findOne({_id:'repo-month:bzr/2012-07-01'}).value.write

2011-07 158222
2011-08 162886
2011-09 141759
2011-10 157897
2011-11 166287
2011-12 168211
2012-01 159411
2012-02 123589
2012-03 132835
2012-04 132835
2012-05 129528
2012-06 123510
2012-07 37294
     

  • Tim Van Steenburgh - 2012-07-10

    4) Average monthly number of forum posts over the last year (https://sourceforge.net/sitestats/forums?dates=2011-07-01+to+2012-07-10)

    Date            Forum Posts
2011-07-01  162,131
2011-08-01  73,004
2011-09-01  60,570
2011-10-01  43,136
2011-11-01  110,078
2011-12-01  156,514
2012-01-01  138,178
2012-02-01  107,654
2012-03-01  110,348
2012-04-01  110,276
2012-05-01  97,016
2012-06-01  100,836
2012-07-01  13,709

Total           1,283,450
     

  • Tim Van Steenburgh - 2012-07-10

    5) Average monthly number of bugs tracked over the last year (https://sourceforge.net/sitestats/tracker?dates=2011-07-01%20to%202012-07-10)

    Date            Opened  Closed
2011-07-01  35,321  9,746
2011-08-01  18,292  7,393
2011-09-01  14,165  5,898
2011-10-01  14,208  6,919
2011-11-01  15,138  6,519
2011-12-01  23,347  7,050
2012-01-01  15,073  8,343
2012-02-01  12,428  6,228
2012-03-01  16,966  6,076
2012-04-01  8,598   6,353
2012-05-01  8,923   7,676
2012-06-01  7,648   5,079
2012-07-01  2,219   1,358

Total         192,326  84,638
     

  • Dave Brondsema

    Dave Brondsema - 2012-07-10
    • status: in-progress --> closed
    • qa: Dave Brondsema
    • size: --> 1
     

Log in to post a comment.