Queries remaining in queue for extended periods

We do have a Redash self-hosted instance running on AWS EC2. We already increased computational resources and Redash is not consuming all the resources when our users start reporting high response times. When CPU utilization is over 35%, response times start getting high. Top waits on performance insights is always related with CPU.

  1. how can we limit redash container memory to fixed like jvm parameteres (min and max) instaed of giving full memory?

Technical details:

  • Redash Version: 8.0.0 (b32245)
  • Browser/OS: Chrome
  • How did you install Redash: docker-compose deployment