工作中使用到的一些linux命令

sum=0
for i in `ps aux|grep postgres|grep -v grep |awk '{print $6}'`
do
((sum=sum+${i}))
done
echo $(echo "scale=2;${sum}/1024"|bc)MB

ps aux |awk '{printf $6" "}{for(i=11;i<=NF;i++){printf("%s ",$i)}}{print ""}' |sort -nr -k1|awk '{printf $1/1024 "Mb  "}{for(i=2;i<=NF;i++){printf("%s ",$i)}{print "-------"}}'|head -20

cat /proc/cpuinfo| grep "processor"| wc -l

# 创建新账户
CREATE USER user_name_data WITH PASSWORD 'N7&37Pg#pn';

# 给新用户授权只读模式
alter user user_name_data set default_transaction_read_only=on;
# 切换到库gra
\c gra
# 赋权select权限
grant select on all tables in schema public to user_name_data;