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 | 4.56 ms | 4.56 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1063 | 214.34 ms | 2.09 ms | 86.02 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1063 | 102.31 ms | 1.33 ms | 34.68 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1062 | 6.82 ms | 95.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 41583 | 17.49 s | 528.30 ms | 5.59 s | 118120 | 1072131 | 0 | 10863 | |
root | alter_table | 14 | 5.59 s | 568.71 ms | 2.53 ms | 0 | 0 | 25 | 0 | |
root | create_table | 12 | 2.69 s | 447.50 ms | 5.47 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 1535 | 1.65 s | 81.34 ms | 564.60 ms | 1460 | 23308 | 0 | 0 | |
root | show_variables | 1639 | 1.49 s | 7.86 ms | 145.71 ms | 1639 | 940744 | 0 | 1639 | |
root | show_fields | 1522 | 1.48 s | 3.71 ms | 586.80 ms | 58217 | 296772 | 0 | 0 | |
root | show_tables | 730 | 516.31 ms | 4.69 ms | 262.70 ms | 17067 | 47883 | 0 | 0 | |
root | show_create_table | 767 | 442.20 ms | 94.02 ms | 202.00 us | 0 | 0 | 0 | 0 | |
root | set_option | 4014 | 266.47 ms | 7.84 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 4 | 206.84 ms | 55.43 ms | 2.91 ms | 0 | 0 | 4 | 0 | |
root | insert | 5 | 120.18 ms | 34.89 ms | 1.78 ms | 0 | 0 | 25 | 0 | |
root | Init DB | 1213 | 70.45 ms | 429.51 us | 8.07 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 35 | 58.74 ms | 56.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_grants | 653 | 51.49 ms | 264.56 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 729 | 26.24 ms | 1.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 150 | 24.59 ms | 2.23 ms | 14.81 ms | 0 | 16 | 0 | 0 | |
root | show_create_proc | 27 | 12.81 ms | 2.94 ms | 2.54 ms | 0 | 0 | 0 | 0 | |
root | Quit | 1654 | 11.53 ms | 244.73 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 6805 | 7.79 ms | 1.76 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 15 | 5.55 ms | 2.05 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 1095 | 5.11 ms | 2.30 ms | 0 ps | 0 | 0 | 0 | 0 |
|