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 #73 background imageLoading...
Page #73 background image
DescriptionMetric
The memory available of the initial node memory allocation. For example, the
High Storage Extra Large (XL) DW Node has 15 GB of memory.
This metric indicates how much of a node is used. If the FreeableMemory is
too low, you can change how the node is used for queries. For more information,
go to Configuring memory use for queries in the Amazon Redshift Developer
Guide.
Units: Bytes (GB in the Amazon Redshift console)
Dimension: node (leader and compute), cluster
FreeableMemory
Indicates the health of the cluster. Every minute the cluster connects to its
database and performs a simple query. If it is able to perform this operation
successfully, the cluster is considered healthy. Otherwise, the cluster is
unhealthy. An unhealthy status can occur when the cluster database is under
extremely heavy load or if there is a configuration problem with a database on
the cluster.
Note
In Amazon CloudWatch this metric is reported as 1 or 0 whereas in
the Amazon Redshift console, this metric is displayed with the words
HEALTHY or UNHEALTHY for convenience.When this metric is displayed
in the Amazon Redshift console, sampling averages are ignored and
only HEALTHY or UNHEALTHY are displayed. In Amazon CloudWatch,
values different than 1 and 0 may occur because of sampling issue.
Any value below 1 for HealthStatus is reported as 0 (UNHEALTHY).
Units: 1/0 (HEALTHY/UNHEALTHY in the Amazon Redshift console)
Dimension: cluster
HealthStatus
Indicates whether the cluster is in maintenance mode.
Note
In Amazon CloudWatch this metric is reported as 1 or 0 whereas in
the Amazon Redshift console, this metric is displayed with the words
ON or OFF for convenience.When this metric is displayed in the
Amazon Redshift console, sampling averages are ignored and only
ON or OFF are displayed. In Amazon CloudWatch, values different than
1 and 0 may occur because of sampling issues. Any value greater
than 0 for MaintenanceMode is reported as 1 (ON).
Units: 1/0 (ON/OFF in the Amazon Redshift console).
Dimension: cluster
MaintenanceMode
The rate at which the node or cluster receives data.
Units: Bytes/seconds (MB/s in the Amazon Redshift console)
Dimension: node (leader and compute), cluster
NetworkReceiveThroughput
The rate at which the node or cluster writes data.
Units: Bytes/second (MB/s in the Amazon Redshift console)
Dimension: node (leader and compute), cluster
NetworkTransmitThroughput
API Version 2012-12-01
69
Amazon Redshift Management Guide
Amazon Redshift CloudWatch Metrics

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