第一個版本: ``` #!/bin/bash log_name="nginx_access.log" url_path="/test/nginx/all_log/script/url_list.txt" for i in $(seq -w 21 28) do for u in $(cat ${url_path}) do cd /test/nginx/all_log/201805${i} && \ echo "time:201805${i}" echo "url:${u}" echo "PV:" $(grep "${u}" ${log_name}|wc -l) grep "${u}" ${log_name}|awk -F"[ \"]+" '{sum+=$(NF-1)} END {print "all-time:",sum/NR}' && \ grep "${u}" ${log_name}|awk -F"[ \"]+" '{sum+=$NF} END {print "PHP-NGINX:,"sum/NR}' echo "\n" done done ``` 第二個版本: 保存成CSV格式,使用excel可以打開查看 ``` #!/bin/bash log_name="bbs.goumin.com_access.log" url_path="/root/url_time/url_list.txt" echo "url,date,nginx_time,php_time" > /root/url_time/time1.csv for u in $(cat ${url_path}) do for i in $(seq -w 29 30) do cd /root/url_time/201805${i} nginx_time=$(grep "${u}" ${log_name}|awk -F"[ \"]+" '{sum+=$(NF-1)} END {printf("%.2f\n",sum/NR)}') php_time=$(grep "${u}" ${log_name}|awk -F"[ \"]+" '{sum+=$NF} END {printf("%.2f\n",sum/NR)}') echo "${u},${i},${nginx_time},${php_time}" >> /root/url_time/time1.csv done done ``` 效果:  后期完善版使用pyton來操作excel表格: 1.調整列寬 2.將第一行標題加黑加粗 3.將相同接口的表格合并居中 4.不同接口區塊標注不同的顏色