PolitePp opened a new issue, #72358: URL: https://github.com/apache/airflow/issues/72358
### Under which category would you file this issue? Airflow Core ### Apache Airflow version 3.3.0 ### What happened and how to reproduce it? When we execute `ti.get_previous_ti(state='success')` airflow collects all task instances from the database and then gets the latest on api side. It's not effective, because the query itself already has sorting by the date ### What you think should happen instead? We can add limit 1 to the query and prevent api load ### Operating System _No response_ ### Deployment None ### Apache Airflow Provider(s) _No response_ ### Versions of Apache Airflow Providers _No response_ ### Official Helm Chart version Not Applicable ### Kubernetes Version _No response_ ### Helm Chart configuration _No response_ ### Docker Image customizations _No response_ ### Anything else? _No response_ ### Are you willing to submit PR? - [x] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md) -- 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]
