Documentation forSolarWinds Observability SaaS

Redshift metrics

Amazon Redshift is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools. Ensure your cloud platform is configured in SolarWinds Observability SaaS to collect this service's data. See Add an AWS cloud account. CloudWatch metrics must also be enabled for this service in the AWS Console for the metric data to be available.

Many of the collected metrics from Redshift Cluster entities are displayed as widgets in SolarWinds Observability explorers; additional metrics may be collected and available in the Metrics Explorer. You can also create an alert for when an entity's metric value moves out of a specific range. See Entities in SolarWinds Observability SaaS for information about entity types in SolarWinds Observability SaaS.

The following table lists some of the metrics collected for these entities. To see the Redshift Cluster metrics in the Metrics Explorer, type AWS.Redshift in the search box.

Metric Units Description
sw.metrics.healthscore Percent (%)

Health score. A health score provides real-time insight into the overall health and performance of your monitored entities. The health score is calculated based on anomalies detected for the entity, alerts triggered for the entity's metrics, and the status of the entity. The health score is displayed as a single numerical value that ranges from a Good (70-100) to Moderate (40-69) to Bad (0-39) distinction.

To view the health score for Redshift entities in the Metrics Explorer, filter the sw.metrics.healthscore metric by entity_types and select awsredshift.
AWS.Redshift.CommitQueueLength Count The number of transactions waiting to commit at a given point in time.
AWS.Redshift.ConcurrencyScalingActiveClusters Count The number of concurrency scaling clusters that are actively processing queries at any given time.
AWS.Redshift.ConcurrencyScalingSecond Count The number of seconds used by concurrency scaling clusters that have active query processing activity.

AWS.Redshift.CPUUtilization

Percent (%)

The percentage of CPU utilization.

AWS.Redshift.DatabaseConnections

Count

The number of database connections to a cluster.

AWS.Redshift.HealthStatus

Boolean

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.

AWS.Redshift.MaintenanceMode

Boolean

Indicates whether the cluster is in maintenance mode.
AWS.Redshift.MaxConfiguredConcurrencyScalingClusters Count Sets the maximum number of concurrency scaling clusters allowed when concurrency scaling is enabled.

AWS.Redshift.NetworkReceiveThroughput

bps

The rate at which the node or cluster receives data.

AWS.Redshift.NetworkTransmitThroughput

bps

The rate at which the node or cluster writes data.
AWS.Redshift.NumExceededSchemaQuotas Count The number of times schema quotas have been exceeded in the Redshift cluster.

AWS.Redshift.PercentageDiskSpaceUsed

Percent (%)

The percent of disk space used.
AWS.Redshift.PercentageQuotaUsed Percent (%) The percentage of the quota that has been used in the Redshift cluster.
AWS.Redshift.QueriesCompletedPerSecond Count per second The number of queries completed per second in the Redshift cluster.
AWS.Redshift.QueryDuration milliseconds (ms) The average amount of time taken to complete a query in the Redshift cluster.
AWS.Redshift.QueryRuntimeBreakdown milliseconds (ms) The breakdown of query runtime into various stages such as planning, waiting, and execution.

AWS.Redshift.ReadIOPS

Count per second

The average number of disk read operations per second.

AWS.Redshift.ReadLatency

seconds (s)

The average amount of time taken for disk read I/O operations.

AWS.Redshift.ReadThroughput

bytes

The average number of bytes read from disk per second.
AWS.Redshift.RedshiftManagedStorageTotalCapacity bytes The total capacity of managed storage available in the Redshift cluster.
AWS.Redshift.SchemaQuota Megabytes The amount of disk space that a schema can use in the Redshift cluster.
AWS.Redshift.StorageUsed bytes The amount of storage space used by the Redshift cluster.
AWS.Redshift.TotalTableCount Count The total number of tables in the Redshift cluster.
AWS.Redshift.UsageLimitAvailable Count The amount of usage limit available for the specified feature in the Redshift cluster.
AWS.Redshift.UsageLimitConsumed Count The amount of usage limit consumed for the specified feature in the Redshift cluster.
AWS.Redshift.WLMQueriesCompletedPerSecond Count per second The number of queries completed per second in the workload management (WLM) queues of the Redshift cluster.
AWS.Redshift.WLMQueryDuration milliseconds (ms) The average amount of time taken to complete a query in the workload management (WLM) queues of the Redshift cluster.
AWS.Redshift.WLMQueueLength Count The number of queries waiting in the workload management (WLM) queues of the Redshift cluster.
AWS.Redshift.WLMQueueWaitTime milliseconds (ms) The amount of time queries wait in the workload management (WLM) queue before being processed.
AWS.Redshift.WLMRunningQueries Count The number of queries currently running in the workload management (WLM) queue.

AWS.Redshift.WriteIOPS

Count per second

The average number of write operations per second.

AWS.Redshift.WriteLatency

seconds (s)

The average amount of time taken for disk write I/O operations.

AWS.Redshift.WriteThroughput

bps

The average number of bytes written to disk per second.