https://bugzilla.wikimedia.org/show_bug.cgi?id=37463
--- Comment #10 from Alvaro <[email protected]> --- Ok, we have some results no. The gerrit backend for Bicho has being improved in order to get the MERGED and ABANDONED real event dates. We have added some new vizs to the gerrit panel in korma dashboard: http://korma.wmflabs.org/browser/scr.html The last one is the accumulated pending reviews in time. We need to find why so many reviews were merged in 2013-04. It seems that the merged date was not correct before this date. So probably, for this kind of analysis, we have only good data after 2013-04. In order to get the tables for this data using just SQL: select new-closed as increment, new, closed, year_new, month_new FROM ( select count(issue_id) as new, YEAR(changed_on) as year_new, MONTH(changed_on) as month_new FROM changes WHERE (new_value='new') GROUP BY YEAR(changed_on),MONTH(changed_on)) t, (select count(issue_id) as closed, YEAR(changed_on) as year_closed, MONTH(changed_on) as month_closed FROM changes WHERE (new_value='merged' OR new_value='abandoned') GROUP BY YEAR(changed_on),MONTH(changed_on)) t1 WHERE year_new = year_closed and month_new = month_closed; +-----------+------+--------+----------+-----------+ | increment | new | closed | year_new | month_new | +-----------+------+--------+----------+-----------+ | 184 | 206 | 22 | 2011 | 9 | | 339 | 367 | 28 | 2011 | 10 | | 596 | 619 | 23 | 2011 | 11 | | 495 | 543 | 48 | 2011 | 12 | | 364 | 384 | 20 | 2012 | 1 | | 661 | 699 | 38 | 2012 | 2 | | 940 | 1058 | 118 | 2012 | 3 | | 1795 | 1954 | 159 | 2012 | 4 | | 2681 | 2812 | 131 | 2012 | 5 | | 3036 | 3192 | 156 | 2012 | 6 | | 2459 | 2611 | 152 | 2012 | 7 | | 3519 | 3694 | 175 | 2012 | 8 | | 2658 | 2797 | 139 | 2012 | 9 | | 3888 | 4098 | 210 | 2012 | 10 | | 3891 | 4121 | 230 | 2012 | 11 | | 3778 | 3961 | 183 | 2012 | 12 | | 3887 | 4101 | 214 | 2013 | 1 | | 3202 | 3393 | 191 | 2013 | 2 | | -37432 | 4118 | 41550 | 2013 | 3 | | -21 | 3922 | 3943 | 2013 | 4 | | 150 | 3846 | 3696 | 2013 | 5 | | 22 | 3919 | 3897 | 2013 | 6 | | 31 | 4321 | 4290 | 2013 | 7 | | 103 | 3785 | 3682 | 2013 | 8 | | -12 | 3375 | 3387 | 2013 | 9 | | 75 | 4394 | 4319 | 2013 | 10 | | 70 | 3502 | 3432 | 2013 | 11 | +-----------+------+--------+----------+-----------+ Is this the kind of information you are searching for? The other important analysis is the backlog: the distribution in time of the pending reviews (when they were opened). We have already done that but not yet included in korma dashboard for gerrit. We can build this analysis per repository, company and people! Next goal is to work in the review time analysis. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
