SELECT * FROM `user_summary_by_statement_type`
|
user | statement | total | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans | |
---|---|---|---|---|---|---|---|---|---|---|
background | select | 1 | 1.47 ms | 1.47 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1239 | 221.96 ms | 1.37 ms | 90.92 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1121 | 90.48 ms | 328.10 us | 31.75 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1178 | 7.73 ms | 47.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 37502 | 17.74 s | 1.06 s | 6.05 s | 135070 | 1863236 | 0 | 15295 | |
root | alter_table | 11 | 3.62 s | 467.86 ms | 2.62 ms | 0 | 0 | 20 | 0 | |
root | show_keys | 2182 | 2.34 s | 88.85 ms | 845.99 ms | 1793 | 27766 | 0 | 0 | |
root | show_fields | 2020 | 1.94 s | 5.97 ms | 789.31 ms | 70044 | 357682 | 0 | 0 | |
root | show_variables | 2121 | 1.89 s | 5.68 ms | 187.40 ms | 3219 | 1216866 | 0 | 2121 | |
root | create_table | 6 | 1.18 s | 278.56 ms | 4.81 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1005 | 656.70 ms | 4.50 ms | 331.46 ms | 23634 | 64487 | 0 | 0 | |
root | create_trigger | 13 | 642.24 ms | 87.03 ms | 3.23 ms | 0 | 0 | 0 | 0 | |
root | delete | 5 | 361.91 ms | 245.11 ms | 563.00 us | 0 | 30 | 4 | 0 | |
root | show_create_table | 1008 | 325.95 ms | 91.67 ms | 578.00 us | 0 | 0 | 0 | 0 | |
root | set_option | 4884 | 283.39 ms | 12.93 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 156 | 280.99 ms | 256.66 ms | 15.03 ms | 51 | 332 | 0 | 0 | |
root | insert | 9 | 275.14 ms | 58.88 ms | 2.18 ms | 0 | 4 | 24 | 0 | |
root | update | 4 | 160.30 ms | 47.69 ms | 268.00 us | 0 | 28 | 4 | 0 | |
root | create_db | 2 | 107.58 ms | 60.88 ms | 2.38 ms | 0 | 0 | 2 | 0 | |
root | alter_user | 2 | 91.62 ms | 53.86 ms | 915.00 us | 0 | 0 | 0 | 0 | |
root | grant | 2 | 88.27 ms | 54.91 ms | 1.40 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 1564 | 83.53 ms | 629.91 us | 7.61 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 981 | 74.46 ms | 301.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 46.76 ms | 26.08 ms | 582.00 us | 900 | 900 | 0 | 2 | |
root | create_view | 1 | 44.28 ms | 44.28 ms | 1.82 ms | 0 | 0 | 0 | 0 |
|