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 | 138.08 us | 138.08 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 388 | 63.71 ms | 659.85 us | 25.70 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 388 | 27.59 ms | 321.02 us | 9.69 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 384 | 2.24 ms | 46.03 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 30331 | 12.68 s | 363.33 ms | 4.50 s | 59927 | 1166937 | 0 | 5205 | |
root | show_fields | 696 | 720.03 ms | 10.29 ms | 288.31 ms | 25666 | 130668 | 0 | 0 | |
root | show_variables | 650 | 631.06 ms | 5.63 ms | 58.28 ms | 1202 | 373016 | 0 | 650 | |
root | show_keys | 794 | 518.80 ms | 2.29 ms | 301.38 ms | 633 | 7603 | 0 | 0 | |
root | show_tables | 165 | 104.10 ms | 3.98 ms | 56.65 ms | 3612 | 8286 | 0 | 0 | |
root | set_option | 1330 | 81.91 ms | 5.43 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 349 | 79.88 ms | 2.58 ms | 77.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 445 | 21.19 ms | 726.40 us | 837.00 us | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 21.16 ms | 21.16 ms | 189.00 us | 450 | 450 | 0 | 1 | |
root | show_grants | 250 | 20.27 ms | 437.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 317 | 10.79 ms | 492.71 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 18 | 9.02 ms | 2.78 ms | 6.62 ms | 0 | 12 | 0 | 0 | |
root | show_create_proc | 26 | 6.89 ms | 1.40 ms | 1.94 ms | 0 | 0 | 0 | 0 | |
root | freturn | 2465 | 4.42 ms | 443.34 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 5 | 4.23 ms | 1.66 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 3.92 ms | 468.95 us | 1.46 ms | 0 | 0 | 0 | 0 | |
root | Quit | 498 | 3.58 ms | 176.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 2.48 ms | 2.48 ms | 2.42 ms | 0 | 0 | 0 | 0 | |
root | error | 5 | 2.17 ms | 1.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 2130 | 1.78 ms | 244.80 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 8 | 1.27 ms | 779.45 us | 0 ps | 0 | 0 | 0 | 0 |
|