Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Paste
P1149
scheduler metrics output tryout
Active
Public
Actions
Authored by
ardumont
on Sep 3 2021, 9:35 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Subscribers
None
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
Event Timeline
ardumont
created this paste.
Sep 3 2021, 9:35 AM
2021-09-03 09:35:41 (UTC+2)
ardumont
mentioned this in
D6177: Send scheduler metrics to prometheus
.
ardumont
edited the content of this paste.
(Show Details)
Sep 3 2021, 12:31 PM
2021-09-03 12:31:24 (UTC+2)
Log In to Comment