db-machine-stats-peek.sh

#!/usr/bin/env bash

# invoke with `watch -n 5`

hostname
uptime | cut -d ',' -f 4-6
free -h
echo ''
psql -U postgres -c 'select count(*) as conns, state from pg_stat_activity group by 2;'
psql -U postgres -c 'select pid, locktype, mode, granted from pg_locks where not granted;'
psql -U postgres -c 'select count(*) as total_locks, mode from pg_locks group by 2;'
iostat -h 5 2 | tail -n 14
vmstat -S M 1 5