Why is querying SVV_TABLE_INFO so slow?

1

SELECT * from SVV_TABLE_INFO where "table" = '<tablename>' limit 1; took 448.8s to execute.

Any ideas why or how I could debug this?

https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TABLE_INFO.html

asked 2 years ago870 views
2 Answers
1

i would start with understanding the workload on the cluster when you are trying to execute the query use the following query to see what running queries are currently active; select user_name, db_name, starttime, pid, replace(trim(query),'\n',' ') from stv_recents where status = 'Running' order by starttime;

answered 2 years ago
AWS
EXPERT
reviewed 2 years ago
0

As mentioned in the other answer the best place to start is to monitor the cluster performance at the time you are experiencing issues. Aside from the query above, you could look at the different steps described in the documentation section dedicated to "Monitoring Amazon Redshift cluster performance".

hope this helps

AWS
EXPERT
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