匹配nginx日志里面的ipv4地址:
select regexp_extract(http_x_forwarded_for,'d+.d+.d+.d+') as s_ip
然后分组求和,利用图表渲染工具就可以出一个好看的图了