Print the db connection count for an AWS RDS db

aws_db_connections.sh

#!/usr/bin/env bash

export AWS_PAGER="" 

db_connections () {
     echo "## ${1}:"
     aws cloudwatch get-metric-statistics \
          --namespace AWS/RDS \
          --dimensions Name=DBInstanceIdentifier,Value=$1 \
          --metric-name DatabaseConnections \
          --start-time $startTime \
          --end-time $endTime \
          --period 300 \
          --statistics Maximum \
          --output text --query 'Datapoints[*].[Timestamp,Maximum]'
}

dbInstance1=postgres-production-rds-1
dbInstance2=postgres-production-rds-2

daysAgoStart=${1:-90}
daysAgoEnd=${2:-0}
startTime=$(date -v-${daysAgoStart}M +"%Y-%m-%dT%H:%M:%S%Z")
endTime=$(date -v-${daysAgoEnd}M +"%Y-%m-%dT%H:%M:%S%Z")

echo "db connections from $startTime to $endTime"
db_connections $dbInstance1 | sort
db_connections $dbInstance2 | sort