Event Timeline
Numbers extracted from scheduler db.
total repositories: 576787
- Thu Aug 23 11:24:12 CEST 2018
11:24:12 softwareheritage-scheduler@db:5432=> select t.type, t.policy, t.status, tr.status, count(*) from task t full outer join task_run tr on t.id=tr.task where type='origin-update-git' and
priority='high' group by t.type, t.policy, t.status, tr.status;
┌───────────────────┬───────────┬────────────────────────┬────────────┬────────┐
│ type │ policy │ status │ status │ count │
├───────────────────┼───────────┼────────────────────────┼────────────┼────────┤
│ origin-update-git │ recurring │ next_run_not_scheduled │ eventful │ 198884 │
│ origin-update-git │ recurring │ next_run_not_scheduled │ uneventful │ 23560 │
│ origin-update-git │ recurring │ next_run_not_scheduled │ failed │ 11848 │
│ origin-update-git │ recurring │ next_run_not_scheduled │ ¤ │ 312485 │
│ origin-update-git │ recurring │ next_run_scheduled │ scheduled │ 29995 │
│ origin-update-git │ recurring │ next_run_scheduled │ started │ 15 │
└───────────────────┴───────────┴────────────────────────┴────────────┴────────┘
(6 rows)
Time: 7077.891 ms (00:07.078)
(+ 198884 23560 11848) ; 234292
(+ 312485 29995) ; 342480
- Fri Aug 24 11:17:29 CEST 2018
11:17:29 softwareheritage-scheduler@db:5432=> select t.type, t.policy, t.status, tr.status, count(*) from task t full outer join task_run tr on t.id=tr.task where type='origin-update-git' and
priority='high' group by t.type, t.policy, t.status, tr.status;
┌───────────────────┬───────────┬────────────────────────┬────────────┬────────┐
│ type │ policy │ status │ status │ count │
├───────────────────┼───────────┼────────────────────────┼────────────┼────────┤
│ origin-update-git │ recurring │ next_run_not_scheduled │ eventful │ 232301 │
│ origin-update-git │ recurring │ next_run_not_scheduled │ uneventful │ 27052 │
│ origin-update-git │ recurring │ next_run_not_scheduled │ failed │ 15531 │
│ origin-update-git │ recurring │ next_run_not_scheduled │ ¤ │ 272934 │
│ origin-update-git │ recurring │ next_run_scheduled │ scheduled │ 28940 │
│ origin-update-git │ recurring │ next_run_scheduled │ started │ 29 │
└───────────────────┴───────────┴────────────────────────┴────────────┴────────┘
(6 rows)
Time: 5718.446 ms (00:05.718)
(+ 232301 27052 15531) ; 274884
(+ 272934 28940) ; 301874
Comments:
- P292$10: I take a shortcut here (i do not compute the snapshot times difference and estimate it roughly to match 24 hours ;)
- currently done repositories are the ones whose status are either: eventful, uneventful, failed.
- remaining repositories to inject are the ones whose status are either: null, scheduled, started.