Page MenuHomeSoftware Heritage
Paste P1001

save code now average ingestion time
ActivePublic

Authored by ardumont on Apr 7 2021, 3:54 PM.
```
swh-web=> select loading_task_status, avg(visit_date - request_date) from save_origin_request where loading_task_status in ('succeeded', 'failed') group by loading_task_status;
loading_task_status | avg
---------------------+-----------------
succeeded | 06:13:01.904513
failed | 16:23:24.820058
(2 rows)
swh-web=> select loading_task_status, count(*) from save_origin_request where loading_task_status in ('succeeded', 'failed') group by loading_task_status;
loading_task_status | count
---------------------+-------
succeeded | 66899
failed | 2231
(2 rows)
swh-web=> select loading_task_status, count(*) from save_origin_request where loading_task_status in ('succeeded', 'failed') and request_date >= '2021-01-01' group by loading_task_status;
loading_task_status | count
---------------------+-------
succeeded | 15318
failed | 181
(2 rows)
swh-web=> select loading_task_status, avg(visit_data - request_date) from save_origin_request where loading_task_status in ('succeeded', 'failed') and request_date >= '2021-01-01' group by loading_task_status;
ERROR: column "visit_data" does not exist
LINE 1: select loading_task_status, avg(visit_data - request_date) f...
^
HINT: Perhaps you meant to reference the column "save_origin_request.visit_date".
swh-web=> select loading_task_status, avg(visit_date - request_date) from save_origin_request where loading_task_status in ('succeeded', 'failed') and request_date >= '2021-01-01' group by loading_task_status;
loading_task_status | avg
---------------------+-----------------
succeeded | 03:24:48.034856
failed | 07:09:21.202971
(2 rows)
```