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.22 ms | 1.22 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1113 | 210.50 ms | 785.56 us | 85.29 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1113 | 96.03 ms | 338.88 us | 33.22 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1111 | 7.08 ms | 74.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 59613 | 23.10 s | 707.47 ms | 7.58 s | 128625 | 859520 | 0 | 15110 | |
root | show_fields | 2305 | 2.25 s | 6.12 ms | 850.34 ms | 106962 | 542459 | 0 | 0 | |
root | show_variables | 2292 | 1.95 s | 4.49 ms | 201.54 ms | 2292 | 1315608 | 0 | 2292 | |
root | show_keys | 2246 | 1.83 s | 72.73 ms | 779.75 ms | 2320 | 26019 | 0 | 0 | |
root | show_create_table | 1184 | 243.01 ms | 5.95 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set_option | 3766 | 215.15 ms | 5.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 315 | 210.32 ms | 5.40 ms | 105.02 ms | 8555 | 20782 | 0 | 0 | |
root | Init DB | 1300 | 58.78 ms | 2.13 ms | 1.40 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 570 | 43.74 ms | 1.87 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1131 | 33.51 ms | 821.74 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1395 | 9.64 ms | 212.19 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 29 | 7.23 ms | 1.91 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 2132 | 6.00 ms | 1.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 4790 | 4.49 ms | 301.94 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 2.20 ms | 2.15 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 2 | 1.58 ms | 1.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 2 | 1.22 ms | 1.15 ms | 0 ps | 0 | 2 | 0 | 0 | |
root | set | 4 | 1.16 ms | 1.11 ms | 0 ps | 0 | 2 | 0 | 0 | |
root | show_table_status | 1 | 938.29 us | 938.29 us | 877.00 us | 0 | 0 | 0 | 0 | |
root | error | 2 | 287.64 us | 256.32 us | 0 ps | 0 | 0 | 0 | 0 |
|