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

最新推荐文章于 2024-09-08 20:30:30 发布

zdsg1024

最新推荐文章于 2024-09-08 20:30:30 发布

阅读量594

点赞数 2

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

belongs-to-zdsg

本文链接：https://blog.youkuaiyun.com/qq_44170834/article/details/127106042

版权

shell 专栏收录该内容

4 篇文章

订阅专栏

该博客介绍了如何利用awk命令在Linux环境中，从包含时间戳的数据中提取、处理并计算时间数据的平均值、最大值和最小值。通过示例文本，展示了awk的用法，包括字段分割、数值比较和字符串操作，从而高效地从日志文件中获取性能指标。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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