awk求最大值，最小值，平均值

最新推荐文章于 2024-04-17 11:54:56 发布

zdsg1024

最新推荐文章于 2024-04-17 11:54:56 发布

阅读量490

点赞数 2

分类专栏： shell 文章标签： linux awk shell

belongs-to-zdsg

本文链接：https://blog.csdn.net/qq_44170834/article/details/127106042

版权

shell 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

awk求最大值,最小值,平均值

以如下文本为例
cat queryresult4tpchform.out | grep Time:

[root@oushu01 logs]# cat queryresult4tpchform.out | grep Time:
Time: 6.250 ms
Time: 1033.327 ms
Time: 4.808 ms
Time: 918.734 ms
Time: 6.006 ms
Time: 9905.242 ms
Time: 5.971 ms
Time: 2464.976 ms
Time: 12.896 ms
Time: 23480.558 ms
Time: 4.982 ms
Time: 10694.684 ms
Time: 8.126 ms
Time: 36866.198 ms
Time: 13.356 ms
Time: 132351.908 ms

平均值

cat queryresult4tpchform.out | grep Time: | awk -F “:” ‘{print $2}’ | awk ‘{ sub(/ms/,“”); print $0}’| awk ‘{sub(" “,”"); print $0}’ | awk ‘{sum+=$1} END {print “Avg=”,sum/NR, “ms”}’

[root@oushu01 logs]#  cat queryresult4tpchform.out | grep Time: | awk -F ":" '{print $2}' | awk '{ sub(/ms/,""); print $0}'| awk '{sub(" ",""); print $0}' | awk '{sum+=$1} END {print "Avg=",sum/NR, "ms"}'
Avg= 13611.1 ms

最大值

cat queryresult4tpchform.out | grep Time: | awk -F “:” ‘{print $2}’ | awk ‘{ sub(/ms/,“”); print $0}’| awk ‘{sub(" “,”"); print $0}’ | awk ’ BEGIN {max=0} {if($1+0>max+0) max=$1} END {print “Max=”,max, “ms”}’

[root@oushu01 logs]#  cat queryresult4tpchform.out | grep Time: | awk -F ":" '{print $2}' | awk '{ sub(/ms/,""); print $0}'| awk '{sub(" ",""); print $0}' | awk ' BEGIN {max=0} {if($1+0>max+0) max=$1} END {print "Max=",max, "ms"}'
Max= 132351.908 ms

最小值

cat queryresult4tpchform.out | grep Time: | awk -F “:” ‘{print $2}’ | awk ‘{ sub(/ms/,“”); print $0}’| awk ‘{sub(" “,”"); print $0}’ | awk ’ BEGIN {min=3600000000} {if($1+0<min+0) min=$1} END {print “Min=”,min, “ms”}’

[root@oushu01 logs]# cat queryresult4tpchform.out | grep Time: | awk -F ":" '{print $2}' | awk '{ sub(/ms/,""); print $0}'| awk '{sub(" ",""); print $0}' | awk ' BEGIN {min=3600000000} {if($1+0<min+0) min=$1} END {print "Min=",min, "ms"}'
Min= 4.808 ms