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 #76 background imageLoading...
Page #76 background image
page you can access the Events+Alarms, Performance, Queries, and Loads tabs which contain the
performance data.These tabs are shown in the following example.
Viewing Cluster Performance Data
Cluster metrics in Amazon Redshift enable the following common performance use cases:
Determine if cluster metrics are abnormal over a specified time range and, if so, identify the queries
responsible for the performance hit.
Check if historical or current queries are impacting cluster performance. If you identify a problematic
query, you can be view details about it including the cluster performance during the query's execution,
information which may assist you in diagnosing why the query was slow, and what can be done to
improve its performance.
The default cluster view shows all nodes graphed together, an Average statistic, and data for the last
hour.You can change this view as needed. Some metrics, such as HealthStatus, are only applicable
for the leader node while others, such as WriteOps, are only applicable for compute nodes. Switching
the node display mode will reset all filters.
To view cluster performance data
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, click the magnifying glass icon beside the cluster for which you want to view
performance data.
4. Select the Performance tab.
API Version 2012-12-01
72
Amazon Redshift Management Guide
Viewing Cluster Performance Data

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