ObinnaIheanachor commented on issue #62025: URL: https://github.com/apache/airflow/issues/62025#issuecomment-3925861993
@kckoh I think it’s a separate concern from the issue in #62025 though. The slowdown there comes from N+1 queries during serialization (DagRun.dag_versions property), not the query plan itself. The PR I just opened fixes that by: • avoiding touching DagRun.dag_versions • using a bounded eager loader for list endpoints So I’d prefer not to modify or drop indexes in this PR. If @pierrejeambrun still sees a slow query after this change, we can follow up with EXPLAIN and then consider a composite index (probably dag_id + run_after + id) without removing the existing one. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
