Posted On: Jul 30, 2018
You can now get a detailed view of your Amazon Redshift cluster performance with the Workload Execution Breakdown graph on the console Database Performance page or the QueryRuntimeBreakdown metric via Cloudwatch. You can use these new metrics to optimize cluster performance to provide higher throughput and faster results.
Workload Execution Breakdown shows the amount of time queries have spent in the plan, wait, read, and write stages. With this update, the Database Performance page now contains 5 key performance monitoring metrics - Workload Execution Breakdown, Query Throughput, Query Duration, Query Throughput by WLM Queues, and Query Duration by WLM Queues.
To learn how to use these graphs to optimize your cluster settings, see Analyzing Workload Performance in the Cluster Management Guide.
These new metrics are now available in the following AWS Regions: US East (N. Virginia), US East (Ohio), US West (N. California), US West (Oregon) Canada (Central), South America (Sao Paulo), EU (Frankfurt), EU (Ireland). EU (London), Asia Pacific (Beijing), Asia Pacific (Mumbai) Asia Pacific (Seoul) Asia Pacific (Singapore), Asia Pacific (Sydney), Asia Pacific (Tokyo), China (Ningxia).