pt-query-digest 解析binlog

mysql版本：5.7.19

mysqlbinlog  mysql-bin.000154 > mysql-bin.000154.txt
/home/mysql/mysql_tools/pt-query-digest --type binlog mysql-bin.000154.txt > zzg.sql
mysql-bin.000154.txt:   6% 06:48 remain
mysql-bin.000154.txt:  13% 06:09 remain
mysql-bin.000154.txt:  21% 05:34 remain
mysql-bin.000154.txt:  28% 05:01 remain
mysql-bin.000154.txt:  35% 04:29 remain
mysql-bin.000154.txt:  42% 03:58 remain
mysql-bin.000154.txt:  50% 03:28 remain
mysql-bin.000154.txt:  57% 02:58 remain
mysql-bin.000154.txt:  64% 02:28 remain
mysql-bin.000154.txt:  71% 01:58 remain
mysql-bin.000154.txt:  79% 01:27 remain
mysql-bin.000154.txt:  86% 00:55 remain
mysql-bin.000154.txt:  94% 00:24 remain

cat zzg.sql 感觉结果好像有问题。。。。。。
# 410.8s user time, 2.8s system time, 23.10M rss, 180.35M vsz
# Current date: Mon May 25 15:32:07 2020
# Hostname: edsspstdb30
# Files: mysql-bin.000154.txt
# Overall: 1.25M total, 5 unique, 116.43 QPS, 0.02x concurrency __________
# Time range: 2020-05-19 17:00:54 to 20:00:03
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           165s       0      1s   131us       0    11ms       0
# Query size        13.13M       5     173    5.50    5.75    0.41    5.75
# @@session.au           1       1       1       1       1       0       1
# @@session.au           1       1       1       1       1       0       1
# @@session.au           1       1       1       1       1       0       1
# @@session.ch          33      33      33      33      33       0      33
# @@session.co          33      33      33      33      33       0      33
# @@session.co          33      33      33      33      33       0      33
# @@session.fo           1       1       1       1       1       0       1
# @@session.lc           0       0       0       0       0       0       0
# @@session.ps       3.07M   3.07M   3.07M   3.07M   3.07M       0   3.07M
# @@session.sq           0       0       0       0       0       0       0
# @@session.sq       1.31G   1.31G   1.31G   1.31G   1.31G       0   1.31G
# @@session.un           1       1       1       1       1       0       1
# error code             0       0       0       0       0       0       0

# Profile
# Rank Query ID           Response time   Calls   R/Call V/M   Item
# ==== ================== =============== ======= ====== ===== =====
#    1 0x85FFF5AA78E5FF6A 165.0000 100.0% 1251523 0.0001  0.98 BEGIN

# Query 1: 116.43 QPS, 0.02x concurrency, ID 0x85FFF5AA78E5FF6A at byte 1517149472
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.98
# Time range: 2020-05-19 17:00:54 to 20:00:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count        100 1251523
# Exec time    100    165s       0      1s   131us       0    11ms       0
# Query size    45   5.97M       5       5       5       5       0       5
# @@session.au 100       1       1       1       1       1       0       1
# @@session.au 100       1       1       1       1       1       0       1
# @@session.au 100       1       1       1       1       1       0       1
# @@session.ch 100      33      33      33      33      33       0      33
# @@session.co 100      33      33      33      33      33       0      33
# @@session.co 100      33      33      33      33      33       0      33
# @@session.fo 100       1       1       1       1       1       0       1
# @@session.lc   0       0       0       0       0       0       0       0
# @@session.ps 100   3.07M   3.07M   3.07M   3.07M   3.07M       0   3.07M
# @@session.sq   0       0       0       0       0       0       0       0
# @@session.sq 100   1.31G   1.31G   1.31G   1.31G   1.31G       0   1.31G
# @@session.un 100       1       1       1       1       1       0       1
# error code     0       0       0       0       0       0       0       0
# String:
# @@session.co default
# @@session.ti '+08:00'
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms
#    1s  ################################################################
#  10s+
BEGIN\G