I’m facing an issue after migrating my self-hosted Prefect server from SQLite to PostgreSQL (hosted on AWS RDS). Initially, I was using the default SQLite database, which stored all data locally on the EC2 instance. As the space consumed by events and resource metadata kept growing significantly, I decided to switch to PostgreSQL on RDS. However, after the migration, my flow runs have started taking much longer than before. Previously, an average flow run would complete in around 5 minutes, but now they’re taking 30 minutes or more. Additionally, the next scheduled run (set to trigger every 30 minutes) often starts and enters the RUNNING state before the previous flow has completed. PS: The schedule interval is 30 minutes. Can someone please help me understand what could be causing this slowdown?

hi @Kartik - where are the slow flow runs taking their time? is the slowdown definitely related to prefect API calls? have you checked the new RDS instance to make sure that normal operations occur as you expect? without more info it’s hard to say

hi @Nate, yeah i finally figured it out what was the issue, it was related to RDS only, prefect is executing the runs fine