Get Redshift performance metrics using Aws::CloudWatch::Metric

clowd_watch_metrics.rb

require 'aws-sdk'

AWS_ACCESS_KEY_ID = 'hoge'.freeze
AWS_SECRET_ACCESS_KEY = 'piyo'.freeze

Aws.config.update({
  region: 'us-west-2',
  credentials: Aws::Credentials.new(AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY)
})

metric = Aws::CloudWatch::Metric.new('AWS/Redshift', 'CPUUtilization')
output = metric.get_statistics(
  start_time: Time.now - 24 * 60 * 60,
  end_time: Time.now,
  statistics: ['Average', 'Maximum'],
  period: 300,
  dimensions: [{:name=>"ClusterIdentifier", :value=>"livesense-analytics"}]
)

output.datapoints.sort_by(&:timestamp).each do |dp|
  puts "#{dp.timestamp.strftime('%Y/%m/%d %H:%M')} - avg: #{dp.average.round(2)}, max: #{dp.maximum}"
end