Docs » Integrations Guide » Integrations Reference » Amazon Redshift

../../_images/integration_awsredshift.png Amazon Redshift πŸ”—

DESCRIPTION πŸ”—

Use SignalFx to monitor Amazon Redshift via Amazon Web Services.

FEATURES πŸ”—

Built-in dashboards πŸ”—

  • Redshift: Overview of all data from Redshift.

    ../../_images/dashboard_redshift.png

INSTALLATION πŸ”—

To access this integration, connect to CloudWatch.

By default, SignalFx will import all CloudWatch metrics that are available in your account. To retrieve metrics for a subset of available services or regions, modify the connection on the Integrations page.

USAGE πŸ”—

SignalFx provides built-in dashboards for this service. Examples are shown below.

../../_images/dashboard_redshift.png

METRICS πŸ”—

Metric Name Description
CPUUtilization The percentage of CPU utilization.
ConcurrencyScalingActiveClusters The number of concurrency scaling clusters that are actively processing queries at any given time.
ConcurrencyScalingSeconds The number of seconds used by concurrency scaling clusters that have active query processing activity.
DatabaseConnections The number of database connections to a cluster.
HealthStatus Indicates the health of the cluster.
MaintenanceMode Indicates whether the cluster is in maintenance mode.
MaxConfiguredConcurrencyScalingClusters Maximum number of concurrency scaling clusters configured from the parameter group.
NetworkReceiveThroughput The rate at which the node or cluster receives data.
NetworkTransmitThroughput The rate at which the node or cluster writes data.
PercentageDiskSpaceUsed The percent of disk space used.
QueriesCompletedPerSecond The average number of queries completed per second.
QueryDuration The average amount of time to complete a query.
ReadIOPS The average number of disk read operations per second.
ReadLatency The average amount of time taken for disk read I/O operations.
ReadThroughput The average number of bytes read from disk per second.
TotalTableCount The number of user tables open at a particular point in time.
WLMQueriesCompletedPerSecond The average number of queries completed per second for a workload management (WLM) queue.
WLMQueryDuration The average length of time to complete a query for a workload management (WLM) queue.
WLMQueueLength The number of queries waiting to enter a workload management (WLM) queue.
WriteIOPS The average number of write operations per second.
WriteLatency The average amount of time taken for disk write I/O operations.
WriteThroughput The average number of bytes written to disk per second.
WLMQueueWaitTime

CPUUtilization πŸ”—

The percentage of CPU utilization.

ConcurrencyScalingActiveClusters πŸ”—

The number of concurrency scaling clusters that are actively processing queries at any given time.

ConcurrencyScalingSeconds πŸ”—

The number of seconds used by concurrency scaling clusters that have active query processing activity.

DatabaseConnections πŸ”—

The number of database connections to a cluster.

HealthStatus πŸ”—

Indicates the health of the cluster.

MaintenanceMode πŸ”—

Indicates whether the cluster is in maintenance mode.

MaxConfiguredConcurrencyScalingClusters πŸ”—

Maximum number of concurrency scaling clusters configured from the parameter group.

NetworkReceiveThroughput πŸ”—

The rate at which the node or cluster receives data.

NetworkTransmitThroughput πŸ”—

The rate at which the node or cluster writes data.

PercentageDiskSpaceUsed πŸ”—

The percent of disk space used.

QueriesCompletedPerSecond πŸ”—

The average number of queries completed per second.

QueryDuration πŸ”—

The average amount of time to complete a query.

ReadIOPS πŸ”—

The average number of disk read operations per second.

ReadLatency πŸ”—

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

ReadThroughput πŸ”—

The average number of bytes read from disk per second.

TotalTableCount πŸ”—

The number of user tables open at a particular point in time.

WLMQueriesCompletedPerSecond πŸ”—

The average number of queries completed per second for a workload management (WLM) queue.

WLMQueryDuration πŸ”—

The average length of time to complete a query for a workload management (WLM) queue.

WLMQueueLength πŸ”—

The number of queries waiting to enter a workload management (WLM) queue.

WriteIOPS πŸ”—

The average number of write operations per second.

WriteLatency πŸ”—

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

WriteThroughput πŸ”—

The average number of bytes written to disk per second.

WLMQueueWaitTime πŸ”—

The total time queries spent waiting in the workload management (WLM) queue.

For more information about the metrics emitted by Amazon Redshift, visit the service’s homepage at https://aws.amazon.com/redshift/.