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 | 3.81 ms | 3.81 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1954 | 424.25 ms | 1.19 ms | 172.14 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1954 | 203.56 ms | 494.87 us | 70.00 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1952 | 13.44 ms | 49.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 55614 | 24.45 s | 530.66 ms | 7.92 s | 188137 | 1452275 | 0 | 14181 | |
root | alter_table | 23 | 9.60 s | 580.77 ms | 31.77 ms | 0 | 0 | 56 | 0 | |
root | create_table | 16 | 2.97 s | 246.69 ms | 32.73 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 1809 | 2.29 s | 106.95 ms | 686.45 ms | 2237 | 32260 | 0 | 0 | |
root | show_fields | 2160 | 2.16 s | 5.78 ms | 836.38 ms | 85249 | 434275 | 0 | 0 | |
root | show_variables | 2225 | 2.10 s | 4.66 ms | 202.79 ms | 2224 | 1276919 | 0 | 2225 | |
root | show_tables | 794 | 484.97 ms | 4.46 ms | 253.65 ms | 13271 | 42136 | 0 | 0 | |
root | set_option | 6507 | 472.73 ms | 9.09 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | insert | 15 | 413.22 ms | 59.18 ms | 4.22 ms | 0 | 0 | 65 | 0 | |
root | create_db | 7 | 367.88 ms | 63.59 ms | 4.30 ms | 0 | 0 | 7 | 0 | |
root | show_create_table | 1054 | 204.62 ms | 3.34 ms | 1.92 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 1763 | 114.59 ms | 562.78 us | 14.38 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1339 | 110.35 ms | 862.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 967 | 34.62 ms | 1.23 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 29641 | 30.85 ms | 1.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 146 | 29.45 ms | 1.76 ms | 16.16 ms | 71 | 339 | 0 | 0 | |
root | Quit | 2434 | 17.36 ms | 698.21 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 362 | 16.68 ms | 932.76 us | 0 ps | 0 | 81 | 0 | 0 | |
root | freturn | 4886 | 13.63 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 108 | 8.00 ms | 693.03 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 39 | 6.13 ms | 478.68 us | 2.75 ms | 351 | 351 | 0 | 39 |
|