Amazon Aurora — Enhanced Monitoring による取得とセクション定義

# Enhanced Monitoring を1秒粒度で有効化
# monitoring-role-arn には rds-monitoring-role の ARN を指定
aws rds modify-db-instance \
  --db-instance-identifier my-aurora-instance \
  --monitoring-interval 1 \
  --monitoring-role-arn arn:aws:iam::123456789012:role/rds-monitoring-role \
  --apply-immediately

# IAM ロールがない場合は先に作成する
aws iam create-role \
  --role-name rds-monitoring-role \
  --assume-role-policy-document '{
    "Version":"2012-10-17",
    "Statement":[{
      "Effect":"Allow",
      "Principal":{"Service":"monitoring.rds.amazonaws.com"},
      "Action":"sts:AssumeRole"
    }]
  }'
aws iam attach-role-policy \
  --role-name rds-monitoring-role \
  --policy-arn arn:aws:iam::aws:policy/service-role/AmazonRDSEnhancedMonitoringRole

# ロググループ内のログストリームを確認
aws logs describe-log-streams \
  --log-group-name RDSOSMetrics \
  --log-stream-name-prefix db-INSTANCE_ID \
  --query 'logStreams[*].logStreamName'

# 最新のメトリクスイベントを取得（JSON 形式）
aws logs get-log-events \
  --log-group-name RDSOSMetrics \
  --log-stream-name "db-INSTANCE_ID" \
  --limit 5 \
  --query 'events[*].message' \
  --output text | python3 -m json.tool

-- CPU 使用率の推移を時系列で確認
fields @timestamp, cpuUtilization.total as cpu_total,
       cpuUtilization.user as cpu_user,
       cpuUtilization.wait as cpu_iowait
| filter ispresent(cpuUtilization.total)
| sort @timestamp desc
| limit 60

-- メモリ使用状況を確認
fields @timestamp, memory.total as mem_total,
       memory.free as mem_free, swap.used as swap_used
| filter ispresent(memory.total)
| sort @timestamp desc
| limit 30

-- プロセスリストから CPU 使用率上位を抽出
fields @timestamp
| filter ispresent(processList)
| parse @message '"name":"*","cpuUsedPc":*,' as proc_name, cpu_pct
| sort cpu_pct desc
| limit 20