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 | 943.16 us | 943.16 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2010 | 394.71 ms | 738.43 us | 161.30 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2010 | 186.81 ms | 347.70 us | 65.17 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2007 | 13.65 ms | 76.70 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 119101 | 48.73 s | 460.31 ms | 15.96 s | 337939 | 2001977 | 0 | 28308 | |
root | show_fields | 4384 | 4.23 s | 5.02 ms | 1.65 s | 173945 | 886067 | 0 | 0 | |
root | show_keys | 4098 | 3.72 s | 113.92 ms | 1.50 s | 4169 | 66698 | 0 | 0 | |
root | show_variables | 3920 | 3.33 s | 6.07 ms | 345.46 ms | 3918 | 2249639 | 0 | 3920 | |
root | alter_table | 5 | 1.71 s | 440.57 ms | 3.47 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1924 | 1.34 s | 16.62 ms | 652.87 ms | 44106 | 128414 | 0 | 0 | |
root | create_table | 4 | 618.54 ms | 225.97 ms | 4.15 ms | 0 | 0 | 0 | 0 | |
root | set_option | 8429 | 540.42 ms | 7.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2231 | 482.40 ms | 9.40 ms | 8.77 ms | 0 | 0 | 0 | 0 | |
root | create_db | 7 | 199.43 ms | 58.74 ms | 2.90 ms | 0 | 0 | 4 | 0 | |
root | Init DB | 2784 | 142.80 ms | 392.58 us | 10.64 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1553 | 121.31 ms | 1.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 197 | 79.83 ms | 3.14 ms | 51.57 ms | 185 | 743 | 0 | 0 | |
root | show_warnings | 1911 | 58.04 ms | 296.75 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3626 | 23.14 ms | 188.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 12489 | 10.16 ms | 769.20 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 49 | 6.27 ms | 937.77 us | 3.32 ms | 441 | 441 | 0 | 49 | |
root | Prepare | 2 | 5.64 ms | 5.57 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 2105 | 5.19 ms | 817.12 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 68 | 5.03 ms | 605.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 7 | 4.77 ms | 2.26 ms | 0 ps | 0 | 7 | 0 | 0 |
|