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

Assigned To

Authored By

	Aklapper
	Dec 12 2019, 12:53 PM

Description

We lost this in 2014 when moving from Bugzilla to Phabricator, plus this functionality is currently not available in wikimedia.biterg.io because T161926 and T161928 so would be custom SQL I guess...

2018-12-31T235959UTC = 1546300799
2020-01-01T000000UTC = 1577836800

Phabricator:

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

Gerrit:

How many patches got created in Gerrit?
- See "Gerrit 🡒 Changesets" on "Gerrit 🡒 Overview": https://wikimedia.biterg.io/goto/7cb967eef5dc53b06f52a9a0ee63cf5f
How many patches got reviewed in Gerrit? BUT: See T241664: Rename "Total Number of Code Reviews" as it is actually the number of created Changesets
- See "Total Number of Code Reviews" on "Gerrit 🡒 Approvals": https://wikimedia.biterg.io/goto/0d79dddb1f24742745d7b542945fec09
How many people created patches in Gerrit?
- See "Gerrit 🡒 Changeset Submitters" on "Gerrit 🡒 Overview": https://wikimedia.biterg.io/goto/7cb967eef5dc53b06f52a9a0ee63cf5f
Who created the most patches in Gerrit?
- See "Submitters" on "Gerrit 🡒 Overview": https://wikimedia.biterg.io/goto/7cb967eef5dc53b06f52a9a0ee63cf5f
Who reviewed the most patches in Gerrit?
- See "Approvals by Reviewer" on "Gerrit 🡒 Approvals": https://wikimedia.biterg.io/goto/0d79dddb1f24742745d7b542945fec09

*drumroll* Share on wikitech-l@.

Details

Due Date: Jan 9 2020, 11:00 PM

Related Objects

Mentioned In: T354168: [January 2025] Publish some Phabricator (and/or Gerrit) end-of-year stats for 2024 to wikitech-l@
T326562: [January 2024] Publish some Phabricator (and/or Gerrit) end-of-year stats for 2023 to wikitech-l@
T320878: Publish some Phabricator (and/or Gerrit) end-of-year stats for 2022 to wikitech-l@
T297685: Publish some Phabricator (and/or Gerrit) end-of-year stats for 2021 to wikitech-l@
T270867: Publish some Phabricator (and/or Gerrit) end-of-year stats for 2020 to wikitech-l@
Mentioned Here: T241664: Rename "Total Number of Code Reviews" as it is actually the number of created Changesets
T161926: Maniphest Backend: Index which user resolved a task
T161928: Maniphest Backend: Consider having metrics covering *any* user activity in Maniphest

Event Timeline

Aklapper triaged this task as Low priority.Dec 12 2019, 12:53 PM

Aklapper created this task.

Top 20 task creators in last month:
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 FROM_UNIXTIME(tsk.dateCreated,'%Y%m')>=date_format(NOW() - INTERVAL 1 MONTH,'%Y%m') GROUP BY usr.username ORDER BY created DESC LIMIT 20;

Usernames of those 20 users who closed the most tasks in the last month:
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 FROM_UNIXTIME(tsk.closedEpoch,'%Y%m')>=date_format(NOW() - INTERVAL 1 MONTH,'%Y%m') GROUP BY usr.username ORDER BY closed DESC LIMIT 20;

Top 20 task commenters in last month (but probably too expensive to run):
SELECT usr.username, COUNT(usr.username) AS comments FROM phabricator_user.user usr INNER JOIN phabricator_maniphest.maniphest_transaction trs WHERE usr.phid = trs.authorPHID AND trs.transactionType = "core:comment" AND FROM_UNIXTIME(trs.dateCreated) >= (NOW() - INTERVAL 1 MONTH) GROUP BY usr.username ORDER BY comments DESC LIMIT 20;

Aklapper renamed this task from Phabricator (and/or Gerrit) end-of-year stats 2019 to Publish some Phabricator (and/or Gerrit) end-of-year stats for 2019 to wikitech-l@.Dec 12 2019, 5:01 PM

Aklapper updated the task description. (Show Details)Dec 13 2019, 12:39 PM

Aklapper updated the task description. (Show Details)Dec 13 2019, 12:44 PM

Aklapper updated the task description. (Show Details)Dec 13 2019, 12:51 PM

Aklapper changed the task status from Open to Stalled.Dec 13 2019, 12:57 PM

Aklapper updated the task description. (Show Details)

Aklapper set Due Date to Jan 9 2020, 11:00 PM.

Aklapper updated the task description. (Show Details)Dec 13 2019, 1:09 PM

Aklapper updated the task description. (Show Details)Dec 13 2019, 1:30 PM

Aklapper updated the task description. (Show Details)

Aklapper updated the task description. (Show Details)Jan 1 2020, 12:35 AM

DannyS712 subscribed.Jan 1 2020, 2:00 AM