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 | 4.23 ms | 4.23 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2568 | 608.21 ms | 1.41 ms | 244.89 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2568 | 298.88 ms | 631.28 us | 100.31 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2576 | 19.01 ms | 48.26 us | 0 ps | 0 | 0 | 0 | 0 | |
root | alter_table | 185 | 49.53 s | 669.93 ms | 46.19 ms | 0 | 0 | 390 | 0 | |
root | select | 45710 | 23.53 s | 2.03 s | 6.80 s | 266719 | 1592714 | 0 | 18371 | |
root | create_table | 113 | 23.19 s | 549.22 ms | 45.26 ms | 0 | 0 | 0 | 0 | |
root | insert | 154 | 5.57 s | 76.39 ms | 39.76 ms | 0 | 0 | 685 | 0 | |
root | show_keys | 2442 | 3.80 s | 81.72 ms | 934.24 ms | 2924 | 44318 | 0 | 0 | |
root | drop_db | 2 | 2.31 s | 2.25 s | 4.33 ms | 0 | 0 | 94 | 0 | |
root | show_fields | 2759 | 2.17 s | 9.27 ms | 927.63 ms | 73504 | 379288 | 0 | 0 | |
root | show_variables | 1845 | 1.63 s | 4.34 ms | 167.62 ms | 2397 | 1058106 | 0 | 1845 | |
root | Init DB | 2119 | 959.33 ms | 786.44 ms | 813.72 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1172 | 614.57 ms | 10.50 ms | 339.16 ms | 16869 | 70432 | 0 | 0 | |
root | set_option | 7718 | 610.47 ms | 13.56 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1829 | 476.72 ms | 135.99 ms | 5.32 ms | 0 | 0 | 0 | 0 | |
root | create_db | 7 | 320.17 ms | 76.34 ms | 1.25 ms | 0 | 0 | 7 | 0 | |
root | show_grants | 1753 | 153.06 ms | 621.38 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 267 | 90.94 ms | 2.46 ms | 58.23 ms | 94 | 510 | 0 | 0 | |
root | create_view | 1 | 68.70 ms | 68.70 ms | 1.43 ms | 0 | 0 | 0 | 0 | |
root | update | 1 | 38.76 ms | 38.76 ms | 844.00 us | 0 | 1 | 1 | 0 | |
root | jump_if_not | 57046 | 32.89 ms | 46.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 82 | 30.60 ms | 21.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 751 | 23.43 ms | 263.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2615 | 20.40 ms | 329.78 us | 0 ps | 0 | 0 | 0 | 0 |
|