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 | 145.86 us | 145.86 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 5288 | 1.06 s | 2.80 ms | 429.48 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 5288 | 499.25 ms | 509.89 us | 175.63 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 5291 | 36.56 ms | 118.44 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 243517 | 1.54 m | 1.30 s | 33.83 s | 620514 | 4265355 | 0 | 46603 | |
root | alter_table | 20 | 6.49 s | 578.66 ms | 8.01 ms | 0 | 0 | 25 | 0 | |
root | show_keys | 6021 | 5.87 s | 130.49 ms | 2.18 s | 4145 | 50328 | 0 | 0 | |
root | show_variables | 5876 | 5.33 s | 102.53 ms | 559.35 ms | 6425 | 3370850 | 0 | 5876 | |
root | show_fields | 5151 | 4.88 s | 10.71 ms | 1.98 s | 183431 | 934271 | 0 | 0 | |
root | create_table | 24 | 4.11 s | 289.79 ms | 7.59 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1945 | 1.35 s | 5.04 ms | 811.94 ms | 22132 | 60970 | 0 | 0 | |
root | create_db | 39 | 1.21 s | 73.01 ms | 10.09 ms | 0 | 0 | 27 | 0 | |
root | set_option | 17021 | 1.04 s | 4.84 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2594 | 575.52 ms | 4.37 ms | 2.49 ms | 0 | 0 | 0 | 0 | |
root | insert | 19 | 495.34 ms | 58.82 ms | 15.99 ms | 0 | 0 | 3368 | 0 | |
root | Init DB | 4245 | 221.24 ms | 405.30 us | 11.48 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 246 | 201.13 ms | 67.87 ms | 90.94 ms | 68 | 822 | 0 | 0 | |
root | show_grants | 2100 | 174.32 ms | 836.81 us | 0 ps | 0 | 0 | 0 | 0 | |
root | rename_table | 1 | 109.41 ms | 109.41 ms | 455.00 us | 0 | 0 | 0 | 0 | |
root | drop_table | 1 | 105.89 ms | 105.89 ms | 432.00 us | 0 | 0 | 0 | 0 | |
root | show_warnings | 2525 | 82.57 ms | 1.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 87540 | 76.29 ms | 3.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 150 | 66.62 ms | 57.07 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 6020 | 47.57 ms | 1.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 39672 | 44.07 ms | 820.75 us | 0 ps | 0 | 0 | 0 | 0 |
|