AWS
What do you if you suspect AWS Redshift performs slowly?
Difficulty: unrated
Source: bregman-arie/devops-exercises
by Arie Bregman
Answer
- You can confirm your suspicion by going to AWS Redshift console and see running queries graph. This should tell you if there are any long-running queries.
- If confirmed, you can query for running queries and cancel the irrelevant queries
- Check for connection leaks (query for running connections and include their IP)
- Check for table locks and kill irrelevant locking sessions