https://prefect.io logo
#prefect-ui
Title
# prefect-ui
k

Kevin Mullins

12/23/2021, 7:08 PM
I know the UI shows upcoming runs that are late; however, is there any way to find historical runs that were late?
k

Kevin Kho

12/23/2021, 7:32 PM
I don’t think there is a view in the UI. You would need to use the GraphQL API and check for the start time being later than the scheduled time
👍 1
k

Kevin Mullins

12/23/2021, 7:37 PM
@Kevin Kho I’m kind of new to GraphQL/Hasura/etc. I can’t seem to find/figure out how to compare a field to another. Have you ever done this before by chance?
k

Kevin Kho

12/23/2021, 7:39 PM
I think you need to bring the query results to Python and then do the comparison there because you can’t in the query. Am looking through the UI code. Let me verify.
k

Kevin Mullins

12/23/2021, 7:40 PM
Gotcha, I could query for flow runs for the past x timeframe, then check the data in memory.
k

Kevin Kho

12/23/2021, 7:41 PM
I checked and I think I’m right. You can use the
client.graphql
to just do a simple query on flows with something like:
Copy code
query {
  flow {
    flow_runs {
      start_time
      scheduled_start_time
    }
  }
}
and then process the results in Python
🙏 1
2 Views