The GitHub Actions job "Tests" on airflow.git/dagrun-improve-performance has failed. Run started by GitHub user SavingFrame (triggered by SavingFrame).
Head commit for run: 2732fcf5f783f9cab85f815b8e42476b55a09bc7 / SavingFrame <[email protected]> Add database index on dag_run.start_date for query optimization DagRuns API page was extremely slow with large datasets due to unindexed ORDER BY on start_date column. The nullsfirst CASE statement workaround prevented index usage, forcing full table scans. This change adds idx_dag_run_start_date index and removes the nullsfirst logic. While NULLS FIRST DESC would be ideal, it cannot leverage the index. Since there's no way to achieve both indexed performance and consistent NULL ordering across PostgreSQL and MySQL, we accept the database defaults: PostgreSQL orders NULLs first in DESC, MySQL orders NULLs last in DESC. Fixes #57344 Report URL: https://github.com/apache/airflow/actions/runs/19081033588 With regards, GitHub Actions via GitBox --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
