cat /var/log/haproxy.log | awk '{print $3":"$12}' | awk -F: '{a[$1":"$2]+=$4} {b[$1":"$2]++} END {for (i in a) print i, a[i]/1024/1024, b[i] |"sort -u"}'
Commands made simple
cat /var/log/haproxy.log | awk '{print $3":"$12}' | awk -F: '{a[$1":"$2]+=$4} {b[$1":"$2]++} END {for (i in a) print i, a[i]/1024/1024, b[i] |"sort -u"}'