we host the flowable engine in GCP and GCP comes with a nice feature called Query Insights. It keeps a dynamic list of the slowest queries and displays it on the dashboard.
At one point we started experiencing a significant slowdown of the platform and here is a screenshot of the Query Insights dashboard around that time:
As you can see the ones at the top are from the Flowable engine itself (as far as I can tell). Also, around that time the database wait lock time increased significantly.
Did anyone experience anything like that? How did you address this issue?