Stale PR stats @Jul 2020

[Mark J Cox]

During June I updated the stale PR script to start to ping reporters where
issues were in the "changes requested" state.  I corrected some issues that
were incorrectly in this state where changes had been supplied.  I also got the
script to close the issues still "waiting for CLA" that had had no response for
several months of automated reminders.  Finally, there were a few issues in
"waiting for review" state that were given reviews or otherwise updated.

PRs that have not had any updates in the last 30 days and are not WIP:

all  ( 132 issues, median  248  days) of which:

 failed CI  ( 22 issues, median  183 days)
 deferred after 1.1.1  ( 46 issues)
 cla required  ( 0 issues)
 waiting for reporter  ( 8 issues, median  255 days)
 waiting for review  ( 0 issues)
 waiting for OMC  ( 1 issue)
 waiting for OTC  ( 4 issues, median  44 days)
 all other  ( 51 issues, median  239 days)

So, ignoring deferred issues too you could summarise this as:

 Stale PRs waiting for us to do something: 27 (last months: 36, 27, 29)
 Stale PRs waiting for the reporter to do something: 8 (last months: 34, 34, 37)
 Stale PRs with unclear next action: 51 (last months: 48, 46, 42)
 Total Stale PRs: 86 (last months: 118, 107, 108)

There really shouldn't be anything "waiting for OMC/OTC/review" that
is over 30 days; many of these did get a decision and the state just
isn't updated.

Over time I hope we can triage the "all other" PRs with labels so we
know what the next action is on each one.

Details:

 waiting for reporter:
    10590 reviewed:changes_requested days:175
    10063 branch: master, reviewed:changes_requested days:35
    9461 reviewed:changes_requested days:335
    9427 reviewed:changes_requested days:342
    8962 reviewed:changes_requested days:104
    8706 branch: master, reviewed:changes_requested days:36
    7961 reviewed:changes_requested days:540
    7432 reviewed:changes_requested days:619

 waiting for OMC:
    10195 branch: master, hold: need omc decision, reviewed:commented days:232

 waiting for OTC:
    11757 hold: cla required, hold: need otc decision,  days:48
    8916 approval: review pending, branch: 1.1.1, branch: master,
hold: need otc decision, reviewed:changes_requested days:41
    8300 approval: otc review pending, branch: 1.1.1, branch: master,
hold: need otc decision, reviewed:review pending days:144
    8024 approval: otc review pending, branch: master,
reviewed:commented days:33

 all other:
    11779 cla: trivial,  days:48
    11744  days:62
    11712 branch: master, reviewed:commented days:57
    11679  days:116
    11481 branch: 1.1.1, branch: master,  days:81
    11421  days:70
    11398 approval: done, branch: master, reviewed:approved days:95
    11359  days:75
    11341  days:73
    11312  days:107
    11260 reviewed:commented days:115
    11248 reviewed:commented days:33
    11116  days:77
    11115  days:116
    11082 branch: master,  days:67
    11057  days:140
    10884  days:162
    10818  days:168
    10570 reviewed:commented days:184
    10541  days:199
    10338 reviewed:commented days:239
    10320 branch: 1.1.1, branch: master, reviewed:commented days:230
    10298  days:243
    10268  days:245
    9655  days:217
    9554  days:326
    9421 branch: 1.1.1, branch: master, reviewed:approved days:181
    9223 branch: master, reviewed:commented days:143
    9206  days:374
    9051 reviewed:commented days:237
    8956  days:396
    8920  days:273
    8908  days:411
    8862  days:390
    8835  days:430
    8743 branch: master,  days:441
    8668  days:452
    8455  days:454
    8420  days:455
    8333  days:490
    8309 branch: master, reviewed:commented days:376
    7688  days:576
    7615  days:580
    7454 reviewed:commented days:531
    7274 reviewed:approved days:382
    7225 reviewed:commented days:647
    6518 milestone:Assessed, reviewed:approved days:741
    6448 milestone:Assessed,  days:248
    6219 milestone:Assessed, reviewed:approved days:779
    4487 milestone:Assessed,  days:718
    4486 milestone:Assessed,  days:718