Airflow Dags 执行时间的统计

 

执行SQL：

SELECT  execution_date
       ,  MIN(start_date) AS start
       ,  MAX(end_date) AS end
       ,  MAX(end_date) - MIN(start_date) AS duration
    FROM  task_instance
   WHERE  dag_id = 'HKG042476_Woocommerce_Handle'
     AND  state = 'success'
GROUP BY  execution_date
ORDER BY  execution_date DESC