Viewing workload concurrency and concurrency scaling data - Amazon Redshift
Workload concurrency graphs

Viewing workload concurrency and concurrency scaling data

By using concurrency scaling metrics in Amazon Redshift, you can do the following:

  • Analyze whether you can reduce the number of queued queries by enabling concurrency scaling. You can compare by WLM queue or for all WLM queues.

  • View concurrency scaling activity in concurrency scaling clusters. This can tell you if concurrency scaling is limited by the max_concurrency_scaling_clusters. If so, you can choose to increase the max_concurrency_scaling_clusters in the DB parameter.

  • View the total usage of concurrency scaling summed across all concurrency scaling clusters.

To display concurrency scaling data

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshiftv2/.

  2. On the navigation menu, choose Clusters, then choose the cluster name from the list to open its details. The details of the cluster are displayed, which can include Cluster performance, Query monitoring, Databases, Datashares, Schedules, Maintenance, and Properties tabs.

  3. Choose the Query monitoring tab for metrics about your queries.

  4. In the Query monitoring section, choose Workload concurrency tab.

    The tab includes the following graphs:

    • Queued vs. Running queries on the cluster – The number of queries running (from the main cluster and concurrency scaling cluster) compared to the number of queries waiting in all WLM queues in the cluster.

    • Queued vs. Running queries per queue – The number of queries running (from the main cluster and concurrency scaling cluster) compared to the number or queries waiting in each WLM queue.

    • Concurrency scaling activity – The number of concurrency scaling clusters that are actively processing queries.

    • Concurrency scaling usage – The usage of concurrency scaling clusters that have active query processing activity.

Workload concurrency graphs

The following examples show graphs that are displayed in the new Amazon Redshift console. To create similar graphs in Amazon CloudWatch, you can use the concurrency scaling and WLM CloudWatch metrics. For more information about CloudWatch metrics for Amazon Redshift, see Performance data in Amazon Redshift.

  • Queued vs. Running queries on the cluster

    Vertical bar graph in increments of days, with each bar divided into two different colors, one showing the average queued queries on a cluster, and the other showing the average running queries on the same cluster.

  • Queued vs. Running queries per queue

    Vertical bar graph in increments of days showing the number of queries running compared to the number of queries waiting in each queue.

  • Concurrency scaling activity

    Horizontal dot graph in increments of days showing the number of concurrency scaling clusters that are actively processing queries.

  • Concurrency scaling usage

    Horizontal line graph in increments of days showing the usage of concurrency scaling clusters that have active query processing activity.