On Monday, January 3, 2022 11:30:42 AM CET Tomas Tomecek wrote: > On Thu, Dec 30, 2021 at 3:35 PM Miroslav Suchý <msuchy@xxxxxxxxxx> wrote: > > > > > - > > > > Statistics: > > - > > > > Copr run 2,900,000 builds. > > - > > > > People created 15 731 new projects. > > > > > Whaaat! The whole list of things you have achieved is mega impressive but > this one totally caught my eye: doing millions of builds per year. > > I'm wondering how many of those projects were created by packit. Frontend footer links this: https://copr.fedorainfracloud.org/db_dumps/ In case anyone wanted to do more analysis ... coprdb=# select count(*) from copr where created_on > 1609459200 and created_on < 1640995200; ┌───────┐ │ count │ ├───────┤ │ 15760 │ └───────┘ (1 row) coprdb=# select count(*) from copr where created_on > 1609459200 and created_on < 1640995200 and user_id = 5576; ┌───────┐ │ count │ ├───────┤ │ 10037 │ └───────┘ (1 row) Most of the projects is from Packit. Packit has though quite unusual use-case; those projects are used for a short period of time (usually new project for every PR), and contain only a few builds. Builds statistics for Packit are not easy to get.. The old removed projects (deleted=true, temporary projects...) have all the related Build instances removed from DB. But due to the nature of the CI builds I suppose it will be somewhere below 100k. Pavel _______________________________________________ devel mailing list -- devel@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to devel-leave@xxxxxxxxxxxxxxxxxxxxxxx Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/devel@xxxxxxxxxxxxxxxxxxxxxxx Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
