Stale PR stats @Apr01

[Mark J Cox]

Earlier this month I started a script to ping stale PRs that were in
certain states.  The script has also been collecting statistics
(trending and snapshot).  I intend to post this monthly and after a
few months with trends and commentary.

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

 all  ( 153 issues, median  158  days) of which:

     failed CI  ( 21 issues, median  158  days)
     deferred after 1.1.1  ( 45 issues, median  158  days)
     cla required  ( 24 issues, median  325.0  days)
     waiting for reporter  ( 13 issues, median  252  days)
     waiting for review  ( 3 issues, median  44  days)
     waiting for OMC  ( 3 issues, median  142  days)
     waiting for OTC  ( 2 issues, median  43.5  days)
     all other  ( 42 issues, median  289.0  days)

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

    Stale PRs waiting for us to do something: 29 (27%)
    Stale PRs waiting for the reporter to do something: 37 (34%)
    Stale PRs with unclear next action: 42 (39%)

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

Detail:

failed CI  ( 21 issues, median  158  days)

    11151  days:30
    11136 reviewed:commented days:36
    11116  days:42
    10626  days:36
    10556  days:117
    10465  days:134
    10344 branch: master,  days:149
    9926  days:196
    9603  days:196
    9155 reviewed:commented days:70
    8955 branch: 1.1.1, branch: master, reviewed:dismissed days:145
    8687 reviewed:commented days:180
    8389  days:385
    8024 reviewed:commented days:51
    7921 reviewed:commented days:389
    7914 reviewed:approved days:448
    7380 reviewed:commented days:536
    7051 milestone:Assessed, reviewed:commented days:585
    6074 milestone:Assessed, reviewed:commented days:628
    4992 milestone:Assessed, reviewed:commented days:158
    4486 milestone:Assessed,  days:628

 waiting for reporter  ( 13 issues, median  252  days)

    10724 reviewed:changes_requested days:76
    10590 reviewed:changes_requested days:85
    9575 reviewed:changes_requested days:232
    9461 reviewed:changes_requested days:245
    9427 reviewed:changes_requested days:252
    9243 reviewed:changes_requested days:254
    9240 reviewed:changes_requested days:279
    8992 reviewed:changes_requested days:196
    8730 reviewed:changes_requested days:293
    8674 reviewed:changes_requested days:348
    7961 reviewed:changes_requested days:450
    7432 reviewed:changes_requested days:529
    2986 milestone:Assessed, reviewed:changes_requested days:158

 waiting for review  ( 3 issues, median  44  days)

    10563 approval: review pending, branch: 1.1.1, branch: master,
reviewed:approved days:44
    10063 approval: review pending, reviewed:approved days:32
    8916 approval: review pending, branch: 1.1.1, branch: master,
reviewed:approved days:125

 waiting for OMC  ( 3 issues, median  142  days)

    10195 branch: master, hold: need omc decision, reviewed:commented days:142
    7285 hold: need omc decision, reviewed:changes_requested days:35
    5909 hold: need omc decision, milestone:Assessed,
reviewed:changes_requested days:643

 waiting for OTC  ( 2 issues, median  43.5  days)

    9654 approval: otc review pending, branch: master, triaged:
feature, reviewed:changes_requested days:33
    8300 approval: otc review pending, branch: 1.1.1, branch: master,
hold: need otc decision, reviewed:approved days:54

 all other  ( 42 issues, median  289.0  days)

    11154  days:36
    11057  days:50
    10884  days:72
    10818  days:78
    10570 reviewed:commented days:94
    10541  days:109
    10338 reviewed:commented days:149
    10320 branch: 1.1.1, branch: master, reviewed:commented days:140
    10298  days:153
    10268  days:155
    10037  days:117
    9655  days:127
    9554  days:236
    9421 branch: 1.1.1, branch: master, reviewed:approved days:91
    9223 branch: master, reviewed:commented days:53
    9206  days:284
    9051 reviewed:commented days:147
    8956  days:306
    8920  days:183
    8908  days:321
    8862  days:300
    8835  days:340
    8743 branch: master,  days:351
    8668  days:362
    8455  days:364
    8420  days:365
    8333  days:400
    8309 branch: master, reviewed:commented days:286
    7688  days:486
    7615  days:490
    7485 branch: 1.1.1, branch: master, reviewed:commented days:516
    7454 reviewed:commented days:441
    7274 reviewed:approved days:292
    7225 reviewed:commented days:557
    6725 milestone:Assessed, reviewed:approved days:300
    6518 milestone:Assessed, reviewed:approved days:651
    6516 branch: 1.1.1, branch: master, milestone:Assessed,  days:651
    6448 milestone:Assessed,  days:158
    6219 milestone:Assessed, reviewed:approved days:689
    5860 branch: 1.1.1, branch: master, milestone:Assessed,
reviewed:commented days:222
    5427 branch: master, milestone:Assessed, reviewed:commented days:451
    4487 milestone:Assessed,  days:628