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;