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

Queries to Redshift Information Schema very slow


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?

2 Answers

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.

answered 5 months ago

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
answered 5 months 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