ptdigest.html

# 2.1s user time, 10ms system time, 41.20M rss, 93.19M vsz
# Current date: Thu Aug 24 15:13:57 2017 
# Hostname: maincloud-bhost-host-abc
# Files: /var/log/mariadb_slowquery.log
# Overall: 3.42k total, 16 unique, 0.06 QPS, 0.41x concurrency ___________
# Time range: 2017-05-23 00:00:36 to 15:39:06
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time         23286s      1s    237s      7s     23s      8s      4s
# Lock time          938ms    19us   107ms   274us   152us     4ms    73us
# Rows sent        191.65M       0  82.44M  57.40k   49.17   1.60M    0.99
# Rows examine      16.03G       0  82.44M   4.80M   7.29M   2.57M   4.93M
# Rows affecte           0       0       0       0       0       0       0
# Query size        10.65M      45 851.11k   3.19k   1.86k  42.91k  511.45

# Profile
# Rank Query ID           Response time    Calls R/Call  V/M   Item
# ==== ================== ================ ===== ======= ===== ===========
#    1 0xxxxxxxxxsccca666 14644.8405 62.9%   893 16.3996  2.02 SELECT catalo1
#    2 0xxxxxxxxxrcccb666  4216.8862 18.1%   780  5.4063  0.66 SELECT catelog2
#    3 0xxxxxxxxxqcccc666  3054.0369 13.1%  1387  2.2019  0.25 SELECT catalog3
#    4 0xxxxxxxxxpcccd666   828.5682  3.6%    20 41.4284 74.06 SELECT catelog5
#    5 0xxxxxxxxxoccce666   255.1623  1.1%   195  1.3085  0.05 SELECT catalog6
#    6 0xxxxxxxxxncccf666   108.4913  0.5%    35  3.0998  0.85 SELECT catlog7
#    7 0xxxxxxxxxmcccg666    68.8060  0.3%    56  1.2287  0.03 SELECT catalog8
#    9 0xxxxxxxxxlccch666    36.2955  0.2%    32  1.1342  0.01 SELECT catalog9
# MISC 0xMISC                73.0793  0.3%    21  3.4800   0.0 <8 ITEMS>
      
# Query 1: 0.02 QPS, 0.26x concurrency, ID 0xxxxxxxxxxcccc666 at byte 11808921
# Scores: V/M = 2.02
# Time range: 2017-05-23 00:01:01 to 15:38:13 
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         26     893
# Exec time     62  14645s      9s     34s     16s     27s      6s     15s
# Lock time     11   109ms    72us   199us   121us   176us    31us   119us
# Rows sent      0  24.58k       0      50   28.18   49.17   23.27   46.83
# Rows examine  40   6.50G   7.43M   7.55M   7.46M   7.29M       0   7.29M
# Rows affecte   0       0       0       0       0       0       0       0 
# Query size    15   1.68M   1.92k   1.92k   1.92k   1.92k       0   1.92k
# String:
# Databases    erp
# Hosts        10.0.222.230
# Users        user