diff --git a/site-modules/profile/files/prometheus/sql/config/swh-scheduler.yml b/site-modules/profile/files/prometheus/sql/config/swh-scheduler.yml --- a/site-modules/profile/files/prometheus/sql/config/swh-scheduler.yml +++ b/site-modules/profile/files/prometheus/sql/config/swh-scheduler.yml @@ -193,3 +193,27 @@ - le values: - sum + +- name: swh_scheduler_metrics + scope: database + cluster: secondary + database: ^softwareheritage-scheduler$ + interval: '4h' + help: "Software Heritage Scheduler Metrics" + query: | + select l.name||':'||l.instance_name as lister_name, sm.visit_type, sm.last_update, + sm.origins_known, sm.origins_enabled, sm.origins_never_visited, + sm.origins_with_pending_changes + from scheduler_metrics sm + inner join listers l on sm.lister_id=l.id + order by lister_name + labels: + - lister_name + - visit_type + - last_update + - origins_known + - origins_enabled + - origins_never_visited + - origins_with_pending_changes + values: + - sum