By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Queries to Redshift Information Schema very slow

0

Since the last maintenance release we have noticed that queries to the information schema on our Redshift cluster are incredibly slow - previously they were taking < 1 second but now are taking around 10 mins. Is there anything that has happened in the release to cause this or anything I can do on the cluster myself to improve performance?

Topics
DatabaseAnalytics
Tags
Extract Transform & Load DataAmazon Redshift
Language
English
AWS-User-0724223
asked 2 years ago401 views
2 Answers
0

I would suggest creating a support ticket for this, before trying to tune it up. This isn't something that should be happening, most probably not your fault.

AWS
AWS-ADolganov
answered 2 years ago
0

Please create a AWS Support case, with information including

  • the cluster name/region
  • query text
  • query IDs of the same query when it's fast and when it's slow
  • when the issue started
  • anything else you'd like to mention
AWS
AWS-supipi
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content