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.13 ms | 1.13 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 878 | 201.86 ms | 628.90 us | 82.42 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 878 | 101.35 ms | 335.81 us | 34.67 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 877 | 5.79 ms | 55.19 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 50777 | 18.48 s | 296.02 ms | 6.78 s | 127149 | 1706270 | 0 | 7755 | |
root | show_keys | 966 | 2.56 s | 90.22 ms | 360.40 ms | 1479 | 18893 | 0 | 0 | |
root | show_fields | 1195 | 1.09 s | 8.72 ms | 463.25 ms | 39255 | 201127 | 0 | 0 | |
root | show_variables | 1065 | 925.56 ms | 5.12 ms | 93.45 ms | 1053 | 610050 | 0 | 1065 | |
root | show_table_status | 25 | 483.86 ms | 302.61 ms | 15.00 ms | 265 | 1585 | 0 | 0 | |
root | show_tables | 452 | 344.46 ms | 5.62 ms | 191.72 ms | 6915 | 31548 | 0 | 0 | |
root | set_option | 2850 | 238.76 ms | 19.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 584 | 112.09 ms | 5.71 ms | 125.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 882 | 69.49 ms | 335.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 68.34 ms | 68.34 ms | 1.11 ms | 0 | 0 | 1 | 0 | |
root | Init DB | 977 | 54.30 ms | 639.91 us | 2.35 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 445 | 13.11 ms | 184.06 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 10999 | 8.45 ms | 31.80 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 4188 | 7.49 ms | 3.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1021 | 7.25 ms | 216.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 54 | 7.14 ms | 1.95 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 3 | 5.04 ms | 4.71 ms | 2.02 ms | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 46 | 4.60 ms | 463.32 us | 1.99 ms | 414 | 414 | 0 | 46 | |
root | show_create_func | 3 | 2.66 ms | 2.27 ms | 1.64 ms | 0 | 0 | 0 | 0 | |
root | Prepare | 12 | 1.98 ms | 364.60 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 12 | 1.84 ms | 358.97 us | 548.00 us | 1 | 25 | 0 | 12 |
|