This is a very simple script, so don't expect something great.
You can change it, distribute, do whatever you like, I don't mind. But if you improve it, you could share it back ;)
To use, you have to export variables to use aws-cli, like AWS_PROFILE, AWS_DEFAULT_REGION, etc. Then just call the script using watch (or however you like) and giving the RDS instance name:
watch ./rds-top.sh <your instance name>
Before using it, you need to enable enhanced monitoring on your RDS instance.
| #!/bin/sh | |
| # Author: Matheus de Oliveira <[email protected]> | |
| # Gist: https://gist.github.com/matheusoliveira/0e9b13d2fca6e7ab993c03e946806503 | |
| instanceid="$1" | |
| resourceid="$( aws rds describe-db-instances | jq -r '.DBInstances[] | select(.DBInstanceIdentifier == "'${instanceid}'") | .DbiResourceId' )" | |
| message_json="$( aws logs get-log-events --log-group-name RDSOSMetrics --log-stream-name "${resourceid}" --limit 1 | jq -r '"\(.events[].message)"' )" | |
| echo "${message_json}" | jq -r \ | |
| '"\(.instanceID) - \(.timestamp) - \(.uptime) up, load average: \(.loadAverageMinute.one), \(.loadAverageMinute.five), \(.loadAverageMinute.fifteen) | |
| Tasks: \(.tasks.total) total, \(.tasks.running) running, \(.tasks.sleeping) sleeping, \(.tasks.stopped) stopped, \(.tasks.zombie) zombie | |
| %Cpu(s): \(.cpuUtilization.user) us, \(.cpuUtilization.system) sy, \(.cpuUtilization.nice) ni, \(.cpuUtilization.idle) id, \(.cpuUtilization.wait) wa, \(.cpuUtilization.steal) st | |
| MiB Mem: \(.memory.total / 1024) total, \(.memory.free / 1024) free, \((.memory.total - .memory.free) / 1024) used, \((.memory.cached + .memory.buffers) / 1024) buff/cache | |
| MiB Swap: \(.swap.total / 1024) total, \(.swap.free / 1024) free, \(.swap.cached) cached"' | |
| echo "${message_json}" | jq -r '.network[] | "Net \(.interface): \(.rx) rx, \(.tx) tx"' | |
| # Mimic `iostat -x` | |
| echo "${message_json}" | jq -r '.diskIO[] | "Disk \(.device): \(.tps) tps, \(.rrqmPS) rrqm/s, \(.wrqmPS) wrqm/s, \(.writeKbPS) wKB/S, \(.readKbPS) rKB/S, \(.avgReqSz) avgrq-sz, \(.avgQueueLen) avgqu-sz, \(.await) await, \(.util) %util"' | |
| echo | |
| tab="$( echo -ne "\t")" | |
| { | |
| echo -e "PID\tVSS\tRSS\t%CPU\t%MEM\tCOMMAND" | |
| echo "${message_json}" | jq -r '.processList[] | "\(.id)\t\(.vss)\t\(.rss)\t\(.cpuUsedPc)\t\(.memoryUsedPc)\t\(.name)"' | sort -nrk 4 | |
| } | column -t -s "${tab}" |