#!/bin/bash
RECORD_TIME=`date '+%Y-%m-%d---%H-%M-%S'`
#获取现在的负载,如果大于30,记录active的SQL
LOAD50=`/usr/bin/w|grep 'load average'|awk -F [':'] '{print $4}'|awk -F [','] '{print $1}' `
MIN=0.01
echo $LOAD50
if [ `echo "$LOAD50 > $MIN" | bc` -eq 1 ];
then
echo "$LOAD50 is bigger"
echo "========================== $RECORD_TIME $LOAD50 ===================================" >> /home/wallog/load_monitor50.log
/usr/bin/psql -Upostgres -p5432 -h127.0.0.1 -d postgres -c "select * from pg_stat_activity ;" >> /home/wallog/load_monitor50.log
echo "######################## end ####################" >> /home/wallog/load_monitor50.log
fi
用一个例子来演示会更加清晰