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 | 951.20 us | 951.20 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2421 | 496.32 ms | 1.20 ms | 201.55 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2421 | 233.37 ms | 526.97 us | 80.91 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2422 | 16.91 ms | 66.12 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 79156 | 38.05 s | 754.40 ms | 11.46 s | 234050 | 1851400 | 0 | 20284 | |
root | alter_table | 21 | 8.51 s | 1.02 s | 37.17 ms | 0 | 0 | 8 | 0 | |
root | create_table | 39 | 8.02 s | 359.96 ms | 155.35 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 2759 | 3.25 s | 127.32 ms | 1.03 s | 2639 | 39811 | 0 | 0 | |
root | show_variables | 2859 | 3.10 s | 394.04 ms | 260.16 ms | 2858 | 1640331 | 0 | 2859 | |
root | show_fields | 2882 | 2.79 s | 12.80 ms | 1.11 s | 110008 | 561192 | 0 | 0 | |
root | set_option | 7575 | 684.29 ms | 176.19 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 899 | 572.34 ms | 5.30 ms | 326.32 ms | 13278 | 45008 | 0 | 0 | |
root | insert | 22 | 497.16 ms | 38.20 ms | 7.50 ms | 0 | 0 | 73 | 0 | |
root | create_db | 6 | 361.42 ms | 81.41 ms | 2.21 ms | 0 | 0 | 6 | 0 | |
root | show_create_table | 1641 | 322.15 ms | 9.31 ms | 2.04 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1592 | 134.16 ms | 1.59 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 2103 | 127.44 ms | 1.18 ms | 12.57 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 1233 | 44.22 ms | 1.67 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 42323 | 41.66 ms | 1.91 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 117 | 30.99 ms | 2.43 ms | 18.59 ms | 0 | 40 | 0 | 0 | |
root | freturn | 17479 | 23.40 ms | 693.05 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2705 | 19.78 ms | 324.56 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 92 | 19.34 ms | 11.63 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 57 | 16.79 ms | 12.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 20 | 8.91 ms | 2.09 ms | 0 ps | 0 | 20 | 0 | 0 |
|