EasyManuals Logo

Amazon Redshift User Manual

Amazon Redshift
131 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #78 background imageLoading...
Page #78 background image
The following example shows the NetworkReceiveThroughput for a cluster with two nodes. It shows
a line for the leader and two compute nodes. Note that the leader node metrics is flat and is not of interest
since data is only loaded on the compute nodes.The example shows that one long query ran in the time
period shown. On the Queries graph the cursor is positioned over the long running query and the Query
ID is displayed on the right.You could then click the Query ID to find out more about the query running.
The NetworkReceiveThroughput value is displayed during the query execution.
Viewing Cluster Metrics During Query Execution
You can view cluster metrics during query execution to help identify poorly performing queries, look for
bottleneck queries, and determine if you need to resize your cluster for your workload.
To view cluster metrics during query execution
1. Sign into the AWS Management Console and open the Amazon Redshift console at
https://console.aws.amazon.com/redshift.
2. In the left navigation, click Clusters.
3. In the cluster list, select the cluster for which you want to view cluster performance during query
execution.
API Version 2012-12-01
74
Amazon Redshift Management Guide
Viewing Cluster Metrics During Query Execution

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the Amazon Redshift and is the answer not in the manual?

Amazon Redshift Specifications

General IconGeneral
ProviderAmazon Web Services (AWS)
Query LanguageSQL
Data StorageColumnar storage
SecurityEncryption at rest and in transit, VPC, IAM
BackupAutomated and manual snapshots
DeploymentCloud-based
TypeCloud-based data warehouse service
Primary UseData warehousing, analytics
IntegrationIntegrates with AWS services, BI tools, and ETL tools
Pricing ModelOn-demand and reserved instance pricing
Data CompressionColumnar storage with data compression
Performance OptimizationQuery optimization

Related product manuals