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.14 ms | 1.14 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 957 | 153.52 ms | 3.59 ms | 59.21 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 957 | 57.60 ms | 158.28 us | 20.71 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 956 | 6.27 ms | 28.68 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 27718 | 15.75 s | 946.74 ms | 4.29 s | 113295 | 1360436 | 0 | 9464 | |
root | show_keys | 951 | 2.05 s | 425.35 ms | 381.40 ms | 917 | 10079 | 0 | 0 | |
root | show_fields | 1137 | 1.02 s | 8.35 ms | 407.44 ms | 37084 | 188607 | 0 | 0 | |
root | show_variables | 962 | 942.94 ms | 15.05 ms | 92.52 ms | 3211 | 551810 | 0 | 962 | |
root | show_tables | 398 | 224.79 ms | 1.67 ms | 141.04 ms | 3103 | 8850 | 0 | 0 | |
root | set_option | 2948 | 145.70 ms | 6.57 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 561 | 119.27 ms | 2.64 ms | 3.29 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 756 | 59.44 ms | 191.90 us | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 46.63 ms | 46.63 ms | 396.00 us | 0 | 0 | 1 | 0 | |
root | Init DB | 758 | 39.30 ms | 1.10 ms | 2.47 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 130 | 29.19 ms | 1.32 ms | 18.27 ms | 0 | 44 | 0 | 0 | |
root | show_create_proc | 78 | 16.33 ms | 3.72 ms | 5.05 ms | 0 | 0 | 0 | 0 | |
root | freturn | 7446 | 15.50 ms | 1.85 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 437 | 14.00 ms | 213.98 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 12657 | 13.35 ms | 603.74 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 110 | 12.78 ms | 221.12 us | 6.46 ms | 990 | 990 | 0 | 110 | |
root | show_create_func | 66 | 8.41 ms | 963.87 us | 1.09 ms | 0 | 0 | 0 | 0 | |
root | Quit | 1048 | 7.34 ms | 355.95 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 42 | 5.13 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 8 | 3.03 ms | 1.49 ms | 0 ps | 0 | 8 | 0 | 0 | |
root | set | 16 | 2.11 ms | 1.43 ms | 0 ps | 0 | 8 | 0 | 0 |
|