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

Assigned To

Authored By

	Aklapper
	Dec 14 2021, 11:09 AM

Project Tags

Referenced Files

None

Subscribers

Aklapper

RhinosF1

Description

See T270867: Publish some Phabricator (and/or Gerrit) end-of-year stats for 2020 to wikitech-l@ and T240564: Publish some Phabricator (and/or Gerrit) end-of-year stats for 2019 to wikitech-l@.

2021-12-31T235959UTC = 1609459199
2022-01-01T000000UTC = 1640995200

Phabricator:

How many tasks got created?
- SELECT COUNT(tsk.dateCreated) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.dateCreated > 1609459199 AND tsk.dateCreated < 1640995200;
How many tasks got closed?
- SELECT COUNT(tsk.closedEpoch) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.closedEpoch > 1609459199 AND tsk.closedEpoch < 1640995200;
How many people were active in Phabricator?
- SELECT COUNT(DISTINCT (tsk.authorPHID)) FROM maniphest_transaction tsk WHERE tsk.dateCreated > 1609459199 AND tsk.dateCreated < 1640995200;
How many people created tasks?
- SELECT COUNT(DISTINCT (tsk.authorPHID)) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.dateCreated > 1609459199 AND tsk.dateCreated < 1640995200;
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 > 1609459199 AND tsk.dateCreated < 1640995200 GROUP BY usr.username ORDER BY created DESC LIMIT 20;
How many people closed tasks?
- SELECT COUNT(DISTINCT (tsk.closerPHID)) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.closedEpoch > 1609459199 AND tsk.closedEpoch < 1640995200;
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 > 1609459199 AND tsk.closedEpoch < 1640995200 GROUP BY usr.username ORDER BY closed DESC LIMIT 20;

Gerrit:

How many patchsets got created in Gerrit?
- See "Gerrit 🡒 Changesets" on "Gerrit 🡒 Overview": https://wikimedia.biterg.io/goto/c2b4d03d9afadd08b1e1a5df87071276
How many reviews of patchsets happened in Gerrit?
- See "Total Number of Code Reviews" on "Gerrit 🡒 Approvals": https://wikimedia.biterg.io/goto/e055063561a4880db0a65c4727cdf919
How many people created patchsets in Gerrit?
- See "Gerrit 🡒 Changeset Submitters" on "Gerrit 🡒 Overview": https://wikimedia.biterg.io/goto/c2b4d03d9afadd08b1e1a5df87071276
Who created the most patchsets in Gerrit?
- See "Submitters" on "Gerrit 🡒 Overview": https://wikimedia.biterg.io/goto/c2b4d03d9afadd08b1e1a5df87071276
Who reviewed the most patchsets in Gerrit?
- See "Approvals by Reviewer" on "Gerrit 🡒 Approvals": https://wikimedia.biterg.io/goto/e055063561a4880db0a65c4727cdf919