ALERT : Postgres waiting connections too high

ACTION : Get Postgres diagnostics automatically

APP_NAME="my-heroku-app"

heroku pg:blocking -a $APP_NAME
heroku pg:locks -a $APP_NAME
heroku pg:diagnose -a $APP_NAME
heroku pg:long-running-queries -a $APP_NAME

# heroku pg:killall -a $APP_NAME

ALERT : App is down

ACTION : Restart your app

APP_NAME="my-heroku-app"

heroku restart -a $APP_NAME

heroku logs -n 200 -a $APP_NAME | grep ERROR

heroku status
                                            

ALERT : Request throughput is high

ACTION : Auto-scale up dynos

APP_NAME="my-heroku-app"

workers_count=$(heroku ps -a $APP_NAME | grep "worker\." | wc -l)

if [ "$workers_count" -lt 5 ]
then
    heroku ps:scale worker+1 --app $APP_NAME
fi

CRON : Everyday at 9pm

ACTION : Scale down web dynos

APP_NAME="my-heroku-app"

heroku scale web=1 worker=1 -a $APP_NAME