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