Download RDS slow query logs and zip it into a single file

fetch-slow-queries.sh

#!/bin/bash

set -ex

instanceID=$1
date=$(date +%Y%m%d)

function downloadLog () {
  local log=$1

  aws rds download-db-log-file-portion \
    --output text \
    --db-instance-identifier $instanceID \
    --log-file-name $log
}

downloadLog slowquery/mysql-slowquery.log > slow-$instanceID-$date.log

for i in $(seq 0 23); do
  downloadLog slowquery/mysql-slowquery.log.$i >> slow-$instanceID-$date.log
done

zip -r slow-$instanceID-$date.log.zip slow-$instanceID-$date.log