Hi @hasan.idriss,
Welcome back! What is the health of your cluster? And what is the size/ record count of the reports you are generating?
I did find an old post from 2022 where I group faced a similar situation and found there was an issue with workload provisioning. The do suggest taking a look at some metrics in that post that could help you identify if that's an issue.
Hope that helps!