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