Logging and monitoring in Amazon Redshift
Monitoring is an important part of maintaining the reliability, availability, and performance of Amazon Redshift and your Amazon solutions. You can collect monitoring data from all of the parts of your Amazon solution so that you can more easily debug a multi-point failure if one occurs. Amazon provides several tools for monitoring your Amazon Redshift resources and responding to potential incidents:
- Amazon CloudWatch Alarms
Using Amazon CloudWatch alarms, you watch a single metric over a time period that you specify. If the metric exceeds a given threshold, a notification is sent to an Amazon SNS topic or Amazon Auto Scaling policy. CloudWatch alarms do not invoke actions because they are in a particular state. Rather the state must have changed and been maintained for a specified number of periods. For more information, see Managing alarms. For a list of metrics, see Monitoring Amazon Redshift using CloudWatch metrics.
- Amazon CloudTrail Logs
CloudTrail provides a record of API operations taken by a user, an IAM role, or an Amazon service in Amazon Redshift. Using the information collected by CloudTrail, you can determine the request that was made to Amazon Redshift, the IP address from which the request was made, who made the request, when it was made, and additional details. For more information, see Logging with CloudTrail.