I am experience slaggish performance on self-hosted redash on Kubernetes cluster
- Redash Version: 8
- Browser/OS: Chrome
- How did you install Redash: using kubernetes charts from redash contrib repository
Running on AWS EKS cluster. Postress DB is a clustered Aurora Postgress instance.
For example, if I am getting list of data source, I see in the pod logs:
method=GET path=/api/data_sources endpoint=data_sources status=200 content_type=application/json content_length=2147 duration=65.92 query_count=22 query_duration=41.33
method=GET path=/api/data_sources endpoint=data_sources status=200 content_type=application/json content_length=2147 duration=335.57 query_count=22 query_duration=52.11
Why so big difference between duration and query-duration? Is there any way to optimize?
My resources for service are following:
I do not see any errors in logs. Version 6 (docker install) was performing just file with even smaller Database)