The GitHub Actions job "Tests" on 
airflow.git/fix/historical-metrics-performance has failed.
Run started by GitHub user chigili (triggered by jason810496).

Head commit for run:
9e9a7c06a7874f400dfa92d59cb840b99a0da868 / chigili <[email protected]>
Add composite indexes and further optimize historical_metrics queries

- Add composite indexes (dag_id, start_date) and (dag_id, end_date) to
  dag_run table for multi-column filter queries
- Move TaskInstance dag_id filter before JOIN to leverage ti_dag_run index
  and reduce rows scanned before joining to dag_run

Benchmark shows ~63% improvement over the original coalesce-based queries
on SQLite with 10k dag runs; improvement expected to be larger on Postgres
with production-scale datasets.

Report URL: https://github.com/apache/airflow/actions/runs/22842612315

With regards,
GitHub Actions via GitBox


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to