gentoo bug stats, creation & resolved, as of 2024/01/07

gistfile1.txt

MariaDB [gentoo-bugs]> select now(); \
select count(distinct bug_id), YEAR(bugs_activity.bug_when) AS yyyy \
FROM bugs_activity \
WHERE fieldid=8 AND added='RESOLVED' GROUP BY yyyy ORDER BY yyyy; \
SELECT COUNT(distinct bug_id), EXTRACT(YEAR FROM creation_ts) AS yyyy \
FROM bugs \
GROUP BY yyyy \
ORDER BY yyyy;

+---------------------+
| now()               |
+---------------------+
| 2024-01-07 21:11:34 |
+---------------------+
1 row in set (0.000 sec)

+------------------------+------+
| count(distinct bug_id) | yyyy |
+------------------------+------+
|                  11398 | 2002 |
|                  21782 | 2003 |
|                  36403 | 2004 |
|                  40929 | 2005 |
|                  41810 | 2006 |
|                  31599 | 2007 |
|                  26663 | 2008 |
|                  30357 | 2009 |
|                  26636 | 2010 |
|                  23908 | 2011 |
|                  26657 | 2012 |
|                  22541 | 2013 |
|                  18199 | 2014 |
|                  18567 | 2015 |
|                  17022 | 2016 |
|                  17892 | 2017 |
|                  17219 | 2018 |
|                  15389 | 2019 |
|                  23818 | 2020 |
|                  24294 | 2021 |
|                  24681 | 2022 |
|                  22779 | 2023 |
|                    497 | 2024 |
+------------------------+------+
23 rows in set (1.255 sec)

+------------------------+------+
| count(distinct bug_id) | yyyy |
+------------------------+------+
|                  13002 | 2002 |
|                  23926 | 2003 |
|                  39357 | 2004 |
|                  41039 | 2005 |
|                  42280 | 2006 |
|                  29649 | 2007 |
|                  30520 | 2008 |
|                  30578 | 2009 |
|                  27449 | 2010 |
|                  23783 | 2011 |
|                  26452 | 2012 |
|                  23559 | 2013 |
|                  18765 | 2014 |
|                  18142 | 2015 |
|                  16913 | 2016 |
|                  19301 | 2017 |
|                  15619 | 2018 |
|                  15074 | 2019 |
|                  25475 | 2020 |
|                  24104 | 2021 |
|                  26362 | 2022 |
|                  24795 | 2023 |
|                    449 | 2024 |
+------------------------+------+
23 rows in set (0.268 sec)