Queries to Redshift Information Schema very slow

Question

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?

Answer

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

Answer

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.

Queries to Redshift Information Schema very slow

Relevanter Inhalt