Page MenuHomePhabricator

Publish some Phabricator (and/or Gerrit) end-of-year stats for 2020 to wikitech-l@
Closed, ResolvedPublic

Event Timeline

Aklapper triaged this task as Medium priority.

2019-12-31T235959UTC = 1577836799
2021-01-01T000000UTC = 1609459200

Phabricator 2020

  • 29321 tasks got created.
    • SELECT COUNT(tsk.dateCreated) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.dateCreated > 1577836799 AND tsk.dateCreated < 1609459200;
  • 26787 tasks got closed.
    • SELECT COUNT(tsk.closedEpoch) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.closedEpoch > 1577836799 AND tsk.closedEpoch < 1609459200;
  • 3958 people were active in Phabricator.
    • SELECT COUNT(DISTINCT (tsk.authorPHID)) FROM maniphest_transaction tsk WHERE tsk.dateCreated > 1577836799 AND tsk.dateCreated < 1609459200;
  • 2349 people created tasks.
    • SELECT COUNT(DISTINCT (tsk.authorPHID)) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.dateCreated > 1577836799 AND tsk.dateCreated < 1609459200;
  • 839 people closed tasks.
    • SELECT COUNT(DISTINCT (tsk.closerPHID)) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.closedEpoch > 1577836799 AND tsk.closedEpoch < 1609459200;
  • The 20 people who created the most tasks:
    • SELECT usr.username, COUNT(usr.username) AS created FROM phabricator_user.user usr JOIN phabricator_maniphest.maniphest_task tsk WHERE tsk.authorPHID = usr.phid AND tsk.dateCreated > 1577836799 AND tsk.dateCreated < 1609459200 GROUP BY usr.username ORDER BY created DESC LIMIT 20;
DannyS712                   729 
Reedy                       585 
Jdlrobson                   485 
ppelberg                    394 
Krinkle                     302 
JosefineHellrothLarssonWMSE 278 
Lucas_Werkmeister_WMDE      273 
Urbanecm                    263 
kai.nissen                  258 
RobH                        253 
Alicia_Fagerving_WMSE       249 
Lokal_Profil                239 
Marostegui                  226 
Eric_Luth_WMSE              219 
Addshore                    217 
Tgr                         212 
Samwalton9                  209 
ayounsi                     204 
jbolorinos-ctr              193 
Aklapper                    191
  • The 20 people who closed the most tasks:
    • SELECT usr.username, COUNT(usr.username) AS closed FROM phabricator_user.user usr JOIN phabricator_maniphest.maniphest_task tsk WHERE tsk.closerPHID = usr.phid AND tsk.closedEpoch > 1577836799 AND tsk.closedEpoch < 1609459200 GROUP BY usr.username ORDER BY closed DESC LIMIT 20;
Aklapper              1356 
Jopparn                654 
DannyS712              630 
Lokal_Profil           556 
ppelberg               484 
Reedy                  482 
Urbanecm               426 
Jdlrobson              410 
Krinkle                408 
kai.nissen             407 
Jdforrester-WMF        402 
bd808                  402 
Dbrant                 360 
Xqt                    352 
Lucas_Werkmeister_WMDE 302 
Addshore               298 
Lydia_Pintscher        283 
Nuria                  280 
Marostegui             261 
hashar                 256

Gerrit 2020

DannyS712               2403
Umherirrender           2125
Reedy                   1937
Jforrester              1682
Dzahn                   1289
Robert Vogel            1223
Jbond                   1220
Pwirth                  1101
ItSpiderman             1059
Andrew Bogott           1046
Elukey                  1029
Xqt                      956
Esanders                 910
Urbanecm                 904
Thiemo Kreuz (WMDE)      893
Marostegui               838
Lucas Werkmeister (WMDE) 812
Legoktm                  806
Jdlrobson                700
Zoranzoki21              695
Jforrester          5931
Daniel Zahn         3945
DannyS712           3870
Jbond               3486
Luca Toscano        2900
Andrew Bogott       2534
Robert Vogel        2506
Moritz Muehlenhoff  2353
Umherirrender       2204
Ppchelko            2192
Marostegui          2117
Patric Wirth        1880
Timo Tijhof         1809
Filippo Giunchedi   1797
Thiemo Kreuz        1707
Itspiderman         1700
Sam Reed            1637
Martin Urbanec      1595
Jon Robson          1571
Alexandros Kosiaris 1524