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 | 890.51 us | 890.51 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 3785 | 730.75 ms | 1.65 ms | 295.81 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3785 | 340.35 ms | 411.21 us | 117.46 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3784 | 24.83 ms | 67.81 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 158335 | 1.51 m | 994.74 ms | 20.94 s | 459007 | 6258543 | 0 | 48642 | |
root | show_fields | 8072 | 7.59 s | 8.53 ms | 3.07 s | 296400 | 1512545 | 0 | 0 | |
root | show_keys | 8177 | 6.71 s | 86.87 ms | 2.97 s | 7875 | 123335 | 0 | 0 | |
root | show_variables | 7497 | 6.40 s | 5.10 ms | 642.47 ms | 7635 | 4302396 | 0 | 7497 | |
root | alter_table | 8 | 3.27 s | 454.94 ms | 1.45 ms | 0 | 0 | 9 | 0 | |
root | create_table | 26 | 3.01 s | 244.34 ms | 7.24 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 3549 | 2.64 s | 5.43 ms | 1.36 s | 82930 | 237827 | 0 | 0 | |
root | set_option | 15621 | 919.69 ms | 8.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 4125 | 793.19 ms | 9.48 ms | 829.00 us | 0 | 0 | 0 | 0 | |
root | insert | 15 | 447.40 ms | 45.99 ms | 5.56 ms | 0 | 0 | 32 | 0 | |
root | Init DB | 5495 | 258.60 ms | 409.74 us | 7.06 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 3079 | 237.42 ms | 1.68 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 5 | 216.08 ms | 60.12 ms | 968.00 us | 0 | 0 | 5 | 0 | |
root | show_warnings | 3516 | 108.23 ms | 389.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 71922 | 48.40 ms | 494.31 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 6673 | 44.51 ms | 750.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 19774 | 30.78 ms | 1.65 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 116 | 27.58 ms | 3.49 ms | 17.57 ms | 1 | 41 | 0 | 0 | |
root | drop_db | 1 | 19.58 ms | 19.58 ms | 48.00 us | 0 | 0 | 0 | 0 | |
root | show_binlogs | 77 | 11.13 ms | 2.37 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 27 | 8.42 ms | 2.45 ms | 1.00 ms | 0 | 0 | 0 | 0 |
|