Changeset View
Changeset View
Standalone View
Standalone View
site-modules/profile/files/prometheus/sql/config/swh-scheduler.yml
| - name: swh_scheduler_delay | - name: swh_scheduler_delay | ||||
| scope: database | scope: database | ||||
| cluster: secondary | database: ^(swh|softwareheritage)-scheduler$ | ||||
olasd: You'll need to drop that one too | |||||
Done Inline Actionsd'oh! ardumont: d'oh! | |||||
| database: ^softwareheritage-scheduler$ | |||||
| interval: '1h' | interval: '1h' | ||||
| help: "Software Heritage Scheduler task delay spread. Positive delay for tasks whose execution is late" | help: "Software Heritage Scheduler task delay spread. Positive delay for tasks whose execution is late" | ||||
| query: | | query: | | ||||
| with task_count_by_bucket as ( | with task_count_by_bucket as ( | ||||
| -- get the count of tasks by delay bucket. Tasks are grouped by their | -- get the count of tasks by delay bucket. Tasks are grouped by their | ||||
| -- characteristics (type, status, policy, priority, current interval), | -- characteristics (type, status, policy, priority, current interval), | ||||
| -- then by delay buckets that are 1 hour wide between -24 and +24 hours, | -- then by delay buckets that are 1 hour wide between -24 and +24 hours, | ||||
| -- and 1 day wide outside of this range. | -- and 1 day wide outside of this range. | ||||
| ▲ Show 20 Lines • Show All 175 Lines • ▼ Show 20 Lines | labels: | ||||
| - task | - task | ||||
| - status | - status | ||||
| - policy | - policy | ||||
| - priority | - priority | ||||
| - current_interval | - current_interval | ||||
| - le | - le | ||||
| values: | values: | ||||
| - sum | - sum | ||||
| - name: swh_scheduler_metrics | |||||
| scope: database | |||||
| database: ^(softwareheritage|swh)-scheduler$ | |||||
| interval: '15m' | |||||
| help: "Software Heritage Scheduler Metrics" | |||||
| query: | | |||||
| select l.name, l.instance_name, sm.visit_type, | |||||
| extract(epoch from sm.last_update) as 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 l.name, l.instance_name | |||||
| labels: | |||||
| - name | |||||
| - instance_name | |||||
| - visit_type | |||||
| values: | |||||
| - last_update | |||||
| - origins_known | |||||
| - origins_enabled | |||||
| - origins_never_visited | |||||
| - origins_with_pending_changes | |||||
You'll need to drop that one too