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.56 ms | 4.56 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 641 | 124.62 ms | 2.09 ms | 49.86 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 641 | 58.84 ms | 1.33 ms | 19.73 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 639 | 4.06 ms | 95.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 21275 | 10.01 s | 528.30 ms | 2.88 s | 67175 | 609631 | 0 | 6144 | |
root | create_table | 5 | 1.25 s | 427.03 ms | 3.77 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 879 | 1.15 s | 81.34 ms | 324.28 ms | 790 | 12510 | 0 | 0 | |
root | show_variables | 892 | 829.31 ms | 7.86 ms | 79.53 ms | 892 | 511987 | 0 | 892 | |
root | show_fields | 843 | 819.21 ms | 3.69 ms | 328.16 ms | 31283 | 159545 | 0 | 0 | |
root | show_tables | 446 | 320.65 ms | 4.65 ms | 161.41 ms | 10383 | 28619 | 0 | 0 | |
root | set_option | 2396 | 154.68 ms | 5.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 96.38 ms | 52.56 ms | 2.77 ms | 0 | 0 | 2 | 0 | |
root | show_create_table | 428 | 89.00 ms | 2.09 ms | 121.00 us | 0 | 0 | 0 | 0 | |
root | show_binlogs | 24 | 57.67 ms | 56.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 700 | 42.15 ms | 332.00 us | 5.97 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 390 | 30.67 ms | 245.48 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 102 | 18.23 ms | 2.23 ms | 11.26 ms | 0 | 12 | 0 | 0 | |
root | show_warnings | 393 | 14.84 ms | 1.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 12.81 ms | 2.94 ms | 2.54 ms | 0 | 0 | 0 | 0 | |
root | Quit | 993 | 6.89 ms | 229.79 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 3179 | 5.50 ms | 1.76 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 516 | 4.22 ms | 2.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 4.03 ms | 926.87 us | 1.02 ms | 0 | 0 | 0 | 0 | |
root | error | 34 | 3.64 ms | 1.84 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 3 | 2.26 ms | 2.05 ms | 0 ps | 0 | 0 | 0 | 0 |
|