Amazon Redshift | Monitoring

Question 1

How do I get a list of all external database tables created in my cluster?

Monitoring

Amazon Redshift | Database

Answer 1

You can query the system table SVV_EXTERNAL_TABLES to get that information.

Question 2

How do I monitor the performance of my Amazon Redshift data warehouse cluster?

Monitoring

Amazon Redshift | Database

Answer 2

Metrics for compute utilization, storage utilization, and read/write traffic to your Amazon Redshift data warehouse cluster are available free of charge via the AWS Management Console or Amazon CloudWatch APIs. You can also add additional, user-defined metrics via Amazon Cloudwatch’s custom metric functionality. In addition to CloudWatch metrics, Amazon Redshift also provides information on query and cluster performance via the AWS Management Console. This information enables you to see which users and queries are consuming the most system resources and diagnose performance issues. In addition, you can see the resource utilization on each of your compute nodes to ensure that you have data and queries that are well balanced across all nodes.