There are long load times for flows, list of flow executions, and flow executions.
- Open flow designer
- Select a flow
- Click the executions button
- Observe a long load time
- Click a single execution
- Observe a long load time of this execution
In reviewing the various flows and the load times, it was noticed a particularly large number of flow executions. On the sys_flow_context table, there were 117,000 records. When that number was reduced to below 12,000 the load times because reasonable amounts of time.
The recommendation is to remove or archive unused sys_flow_context records. ServiceNow platform provides a data archiving functionality.