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.69 ms | 1.69 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2281 | 394.89 ms | 2.31 ms | 160.60 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2281 | 176.80 ms | 1.31 ms | 62.37 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2290 | 14.84 ms | 62.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 117403 | 51.24 s | 594.33 ms | 16.85 s | 285406 | 2088346 | 0 | 24633 | |
root | show_fields | 3510 | 3.57 s | 11.29 ms | 1.39 s | 142800 | 725831 | 0 | 0 | |
root | show_variables | 3333 | 3.01 s | 13.35 ms | 300.03 ms | 4436 | 1912470 | 0 | 3333 | |
root | show_keys | 3743 | 2.84 s | 79.13 ms | 1.42 s | 3440 | 36760 | 0 | 0 | |
root | show_tables | 741 | 502.43 ms | 12.53 ms | 276.75 ms | 13738 | 37461 | 0 | 0 | |
root | set_option | 7329 | 410.68 ms | 14.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1818 | 398.19 ms | 10.83 ms | 387.00 us | 0 | 0 | 0 | 0 | |
root | alter_table | 2 | 380.91 ms | 378.79 ms | 806.00 us | 0 | 0 | 0 | 0 | |
root | create_table | 2 | 380.60 ms | 211.41 ms | 2.86 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1713 | 144.60 ms | 8.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 134.76 ms | 55.83 ms | 2.26 ms | 0 | 0 | 3 | 0 | |
root | Init DB | 2267 | 106.98 ms | 1.11 ms | 4.97 ms | 0 | 0 | 0 | 0 | |
root | insert | 3 | 99.04 ms | 38.77 ms | 5.58 ms | 0 | 0 | 7 | 0 | |
root | freturn | 29088 | 65.96 ms | 10.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 66 | 64.07 ms | 47.98 ms | 10.83 ms | 37 | 271 | 0 | 0 | |
root | jump_if_not | 56275 | 52.56 ms | 1.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1566 | 48.30 ms | 735.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 60 | 28.54 ms | 16.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2660 | 17.96 ms | 256.86 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 40 | 17.47 ms | 15.96 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 17 | 9.21 ms | 2.65 ms | 0 ps | 0 | 17 | 0 | 0 |
|