upstream freshness status (uscan/watch)
It would be kind of nice to see how up to date Debian is, in general. I know of https://qa.debian.org/cgi-bin/watch but that gives only results per package. https://qa.debian.org/developer.php also gives that information, but per developer, and doesn't do sums...
i guess, as usual, UDD could be used to extract some of that information, but that doesn't give us historical information. this is, nevertheless, the magic query, from what i gathered:
udd=> SELECT status, COUNT(status), ROUND(100.0 * COUNT(*) / SUM(COUNT(*)) OVER ()) AS percent FROM upstream GROUP BY status ORDER BY count DESC;
status | count | percent
------------------------------+-------+---------
up to date | 21597 | 59
newer package available | 6542 | 18
error | 4124 | 11
only older package available | 856 | 2
package available | 10 | 0
| 0 | 9
(6 lignes)
we're 59% up to date! (assuming the "error" ones are out of date of course)...