Re: [I] Performance issue: recent_dag_runs endpoint slow with many DAGs [airflow]

Mon, 01 Sep 2025 07:16:17 -0700 


GB6638 commented on issue #55071:
URL: https://github.com/apache/airflow/issues/55071#issuecomment-3242544237

   In the latest version I see some calls to recent_dag_runs
   
   <img width="2550" height="1237" alt="Image" 
src="https://github.com/user-attachments/assets/6d8c7710-9272-4370-9ee3-a47233bec41c";
 />
   
   <img width="1243" height="741" alt="Image" 
src="https://github.com/user-attachments/assets/2262bc53-737f-4e99-8b0b-c79985522900";
 />
   
   > Upon investigating this issue on the main branch, I found that the `/dags` 
UI page does not make any call to`/airflow/ui/dags/recent_dag_runs`. In the 
codebase, I also did not find any usage of `dags_with_recent_dag_runs = 
session.execute(dags_with_recent_dag_runs_select_filter)`.
   > 
   > Instead, I observed that an API call is made to 
`/ui/dags?dag_runs_limit=1&limit=50&offset=0&exclude_stale=true&order_by=dag_display_name`
 which is returning a response of the list of dags within 175ms.
   > 
   > Seems like this issue is no more present on the latest main branch. 
[@GB6638](https://github.com/GB6638) Correct me If I'm wrong ?
   > 
   > <img alt="Image" width="2000" height="1107" 
src="https://private-user-images.githubusercontent.com/215842861/484213316-49f71ba4-4d0d-4165-b035-80a1b087c0f4.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NTY3MzYzMzQsIm5iZiI6MTc1NjczNjAzNCwicGF0aCI6Ii8yMTU4NDI4NjEvNDg0MjEzMzE2LTQ5ZjcxYmE0LTRkMGQtNDE2NS1iMDM1LTgwYTFiMDg3YzBmNC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwOTAxJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDkwMVQxNDEzNTRaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1lNTZiMjY4NTAwYTdhZTBkYjc5MzUyYmI1OWFkM2I2ZjNkYWJlMjQ2NjNkODAxZDc2MGYxODBhMWFmZmU1MWRiJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.Kfb0E7pqBAtviD8q_Nis1RPN00E8J_b7t7s4Qb9mlMI";>
   
   


-- 
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]

Reply via email to