09:35:38 softwareheritage-scheduler@belvedere:5432=> select l.name||':'||l.instance_name as lister_name, sm.visit_type, sm.last_update, sm.origins_known, sm.origins_enabled12:31:24 softwareheritage-scheduler@belvedere:5432=> select l.name, sm.origins_never_visitedl.instance_name, sm.origins_with_pending_changes from scheduler_metrics sm inner join listers l on sm.lister_id=l.id order by lister_name;visit_type,
+--------------------------------------------+------------+-------------------------------+---------------+-----------------+-----------------------+------------------------------+softwareheritage-scheduler-> extract(epoch from sm.last_update) as last_update,
| lister_name | visit_type | last_update | origins_known | origins_enabled | origins_never_visited | origins_with_pending_changes |softwareheritage-scheduler-> sm.origins_known, sm.origins_enabled, sm.origins_never_visited,
+--------------------------------------------+------------+-------------------------------+---------------+-----------------+-----------------------+------------------------------+softwareheritage-scheduler-> sm.origins_with_pending_changes
| CRAN:cran | tar | 2021-09-03 04:38:34.372095+00 | 18580 | 18580 | 18580 | 0 |softwareheritage-scheduler-> from scheduler_metrics sm
| GNU:GNU | tar | 2021-09-03 04:38:34.372095+00 | 387 | 387 | 33 | 91 |softwareheritage-scheduler-> inner join listers l on sm.lister_id=l.id
| bitbucket:bitbucket | git | 2021-09-03 04:38:34.372095+00 | 2886766 | 2768673 | 888996 | 302 |softwareheritage-scheduler-> order by l.name, l.instance_name
| cgit:code.qt.io | git | 2021-09-03 04:38:34.372095+00 | 281 | 281 | 9 | 0 |softwareheritage-scheduler-> ;
| cgit:fedorapeople.org | git | 2021-09-03 04:38:34.372095+00 | 869 | 869 | 31 | 0 |+---------------+------------------------------+------------+-------------------+---------------+-----------------+-----------------------+------------------------------+
| cgit:git.alpinelinux.org | git | 2021-09-03 04:38:34.372095+00 | 7 | 7 | 1 | 0 name | instance_name | visit_type | last_update | origins_known | origins_enabled | origins_never_visited | origins_with_pending_changes |
| cgit:git.baserock.org | git | 2021-09-03 04:38:34.372095+00 | 1524 | 1524 | 70 | 0 |+---------------+------------------------------+------------+-------------------+---------------+-----------------+-----------------------+------------------------------+
| cgit:git.eclipse.org | git | 2021-09-03 04:38:34.372095+00 | 3152 | 3149 | 3070 | 1CRAN | cran | tar | 1630658313.779757 | 18580 | 18580 | 18580 | 0 |
| cgit:git.gnu.org.ua | git | 2021-09-03 04:38:34.372095+00 | 147 | 145 | 126 | 0GNU | GNU | tar | 1630658313.779757 | 387 | 387 | 33 | 91 |
| cgit:git.joeyh.name | git | 2021-09-03 04:38:34.372095+00 | 62 | 62 | 62 | 0bitbucket | bitbucket | git | 1630658313.779757 | 2886766 | 2768673 | 888996 | 302 |
| cgit:git.kernel.org | git | 2021-09-03 04:38:34.372095+00 | 1092 | 1092 | 232 | 1 | code.qt.io | git | 1630658313.779757 | 281 | 281 | 9 | 0 |
| cgit:git.openembedded.org | git | 2021-09-03 04:38:34.372095+00 | 16 | 16 | 16 | fedorapeople.org | git | 1630658313.779757 | 869 | 869 | 31 | 0 |
| cgit:git.yoctoproject.org | git | 2021-09-03 04:38:34.372095+00 | 178 | 178 | 13 | 12 | git.alpinelinux.org | git | 1630658313.779757 | 7 | 7 | 1 | 0 |
| cgit:git.zx2c4.com | git | 2021-09-03 04:38:34.372095+00 | 161 | 160 | 6 | git.baserock.org | git | 1630658313.779757 | 1524 | 1524 | 70 | 0 |
| cgit:gitweb.torproject.org | git | 2021-09-03 04:38:34.372095+00 | 519 | 519 | 519 | 0 | git.eclipse.org | git | 1630658313.779757 | 3152 | 3149 | 3048 | 1 |
| cgit:gnu-savannah | git | 2021-09-03 04:38:34.372095+00 | 1038 | 1038 | 19 | git.gnu.org.ua | git | 1630658313.779757 | 147 | 145 | 126 | 0 |
| cgit:hdiff.luite.com | git | 2021-09-03 04:38:34.372095+00 | 15134 | 15134 | 15134 | git.joeyh.name | git | 1630658313.779757 | 62 | 62 | 62 | 0 |
| debian:Debian | deb | 2021-09-03 04:38:34.372095+00 | 35996 | 35996 | 555 | 0cgit | git.kernel.org | git | 1630658313.779757 | 1092 | 1092 | 231 | 1 |
| debian:Debian-Security | deb | 2021-09-03 04:38:34.372095+00 | 813 | 813 | 28cgit | git.openembedded.org | git | 1630658313.779757 | 16 | 16 | 16 | 0 |
| gitea:codeberg.org | git | 2021-09-03 04:38:34.372095+00 | 10583 | 10535 | 5068 | 49cgit | git.yoctoproject.org | git | 1630658313.779757 | 178 | 178 | 13 | 12 |
| gitea:git.fsfe.org | git | 2021-09-03 04:38:34.372095+00 | 424 | 423 | 74cgit | git.zx2c4.com | git | 1630658313.779757 | 161 | 160 | 6 | 0 |
| github:github | git | 2021-09-03 04:38:34.372095+00 | 181899187 | 181870618 | 59452682 | 113247cgit | gitweb.torproject.org | git | 1630658313.779757 | 519 | 519 | 519 | 0 |
| gitlab:0xacab.org | git | 2021-09-03 04:38:34.372095+00 | 1302 | 1301 | 202 | 21cgit | gnu-savannah | git | 1630658313.779757 | 1038 | 1038 | 19 | 0 |
| gitlab:framagit.org | git | 2021-09-03 04:38:34.372095+00 | 20867 | 20857 | 5483 | 4cgit | hdiff.luite.com | git | 1630658313.779757 | 15134 | 15134 | 15134 | 0 |
| gitlab:gite.lirmm.fr | git | 2021-09-03 04:38:34.372095+00 | 638 | 638 | 154debian | Debian | deb | 1630658313.779757 | 35996 | 35996 | 555 | 0 |
| gitlab:gitlab.com | git | 2021-09-03 04:38:34.372095+00 | 2898255 | 2898031 | 2080774 | 247debian | Debian-Security | deb | 1630658313.779757 | 813 | 813 | 286 | 0 |
| gitlab:gitlab.common-lisp.net | git | 2021-09-03 04:38:34.372095+00 | 825 | 825 | 24 | 0ea | codeberg.org | git | 1630658313.779757 | 10583 | 10535 | 5068 | 49 |
| gitlab:gitlab.freedesktop.org | git | 2021-09-03 04:38:34.372095+00 | 8791 | 8788 | 2291 | 264ea | git.fsfe.org | git | 1630658313.779757 | 424 | 423 | 74 | 0 |
| gitlab:gitlab.gnome.org | git | 2021-09-03 04:38:34.372095+00 | 13176 | 13175 | 2153 | 1hub | github | git | 1630658313.779757 | 181899187 | 181870498 | 59424154 | 1118472 |
| gitlab:gitlab.inria.fr | git | 2021-09-03 04:38:34.372095+00 | 3520 | 3519 | 1560 | | 0xacab.org | git | 1630658313.779757 | 1302 | 1301 | 202 | 21 |
| gitlab:gitlab.lip6.fr | git | 2021-09-03 04:38:34.372095+00 | 71 | 71 | 64 | 0 | framagit.org | git | 1630658313.779757 | 20867 | 20857 | 5483 | 4 |
| gitlab:gitlab.ow2.org | git | 2021-09-03 04:38:34.372095+00 | 1332 | 1332 | 158 | gite.lirmm.fr | git | 1630658313.779757 | 638 | 638 | 154 | 0 |
| launchpad:launchpad | git | 2021-09-03 04:38:34.372095+00 | 24547 | 24543 | 4157 | 3022gitlab | gitlab.com | git | 1630658313.779757 | 2898255 | 2898030 | 2080755 | 246 |
| npm:npm | npm | 2021-09-03 04:38:34.372095+00 | 1725502 | 1725502 | 3530 | 135gitlab | gitlab.common-lisp.net | git | 1630658313.779757 | 825 | 825 | 24 | 0 |
| phabricator:developer.blender.org | git | 2021-09-03 04:38:34.372095+00 | 41 | 38 | 38 | 0gitlab | gitlab.freedesktop.org | git | 1630658313.779757 | 8791 | 8788 | 2291 | 264 |
| phabricator:developer.blender.org | svn | 2021-09-03 04:38:34.372095+00 | 6 | 5 | 0 | 0gitlab | gitlab.gnome.org | git | 1630658313.779757 | 13176 | 13175 | 2153 | 1 |
| phabricator:forge.softwareheritage.org | git | 2021-09-03 04:38:34.372095+00 | 195 | 175 | 22 | 0gitlab | gitlab.inria.fr | git | 1630658313.779757 | 3520 | 3519 | 1560 | 1 |
| phabricator:phabricator.kde.org | git | 2021-09-03 04:38:34.372095+00 | 1036 | 1025 | 1025gitlab | gitlab.lip6.fr | git | 1630658313.779757 | 71 | 71 | 64 | 0 |
| pypi:pypi | pypi | 2021-09-03 04:38:34.372095+00 | 403756 | 393422 | 65225 | 4232gitlab | gitlab.ow2.org | git | 1630658313.779757 | 1332 | 1332 | 158 | 0 |
| save-code-now:archive.softwareheritage.org | hg | 2021-09-03 04:38:34.372095+00 | 19 | 18 | 0 | 0launchpad | launchpad | git | 1630658313.779757 | 24547 | 24543 | 4156 | 3022 |
| save-code-now:archive.softwareheritage.org | svn | 2021-09-03 04:38:34.372095+00 | 18 | 18 | 0 | 0npm | npm | npm | 1630658313.779757 | 1725502 | 1725502 | 3530 | 135 |
| save-code-now:archive.softwareheritage.org | git | 2021-09-03 04:38:34.372095+00 | 5380 | 5380 | 0phabricator | developer.blender.org | git | 1630658313.779757 | 41 | 38 | 38 | 0 |
| sourceforge:main | phabricator | developer.blender.org | gitsvn | 2021-09-03 04:38:34.372095+001630658313.779757 | 182302 6 | 05 | 0 | 0 |
| sourceforge:main | bzr | 2021-09-03 04:38:34.372095+00 | 290 | 0 | 0phabricator | forge.softwareheritage.org | git | 1630658313.779757 | 195 | 175 | 22 | 0 |
| sourceforge:main | svn | 2021-09-03 04:38:34.372095+00 | 101985 | 0 | 0phabricator | phabricator.kde.org | git | 1630658313.779757 | 1036 | 1025 | 1025 | 0 |
| sourceforge:main | cvs | 2021-09-03 04:38:34.372095+00 | 28622 | 0 | 0 | 0pypi | pypi | pypi | 1630658313.779757 | 403756 | 393421 | 65225 | 4232 |
| sourceforge:main | save-code-now | archive.softwareheritage.org | hg | 2021-09-03 04:38:34.372095+001630658313.779757 | 27720 19 | 018 | 0 | 0 |
+--------------------------------------------+------------+------------| save-code-now | archive.softwareheritage.org | svn | 1630658313.779757 | 18 | 18 | 0 | 0 |
| save-code-now | archive.softwareheritage.org | git | 1630658313.779757 | 5383 | 5383 | 0 | 0 |
| sourceforge | main | git | 1630658313.779757 | 182302 | 0 | 0 | 0 |
| sourceforge | main | bzr | 1630658313.779757 | 290 | 0 | 0 | 0 |
| sourceforge | main | svn | 1630658313.779757 | 101985 | 0 | 0 | 0 |
| sourceforge | main | cvs | 1630658313.779757 | 28622 | 0 | 0 | 0 |
| sourceforge | main | hg | 1630658313.779757 | 27720 | 0 | 0 | 0 |
+---------------+------------------------------+------------+-------------------+---------------+-----------------+-----------------------+------------------------------+
(47 rows)
Time: 8.320 ms16.114 ms