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.59 ms | 3.59 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1289 | 293.24 ms | 823.16 us | 119.08 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1289 | 141.67 ms | 388.52 us | 48.68 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1288 | 8.76 ms | 34.60 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 127107 | 38.14 s | 343.53 ms | 16.62 s | 209482 | 1394770 | 0 | 11536 | |
root | alter_table | 16 | 6.90 s | 553.06 ms | 3.15 ms | 0 | 0 | 18 | 0 | |
root | show_keys | 1165 | 2.28 s | 104.77 ms | 436.40 ms | 1513 | 20646 | 0 | 0 | |
root | create_table | 11 | 2.22 s | 339.38 ms | 4.76 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 1440 | 1.35 s | 8.33 ms | 132.27 ms | 1436 | 825972 | 0 | 1440 | |
root | show_fields | 1311 | 1.24 s | 6.94 ms | 495.99 ms | 50648 | 258186 | 0 | 0 | |
root | set_option | 4100 | 320.24 ms | 17.67 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 548 | 275.54 ms | 3.23 ms | 153.08 ms | 5965 | 18652 | 0 | 0 | |
root | insert | 8 | 250.90 ms | 47.25 ms | 2.64 ms | 0 | 0 | 18 | 0 | |
root | show_create_table | 652 | 208.56 ms | 68.61 ms | 588.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 165.98 ms | 63.00 ms | 512.00 us | 0 | 0 | 3 | 0 | |
root | Init DB | 1349 | 106.22 ms | 407.61 us | 19.02 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1158 | 97.01 ms | 350.03 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 287 | 37.46 ms | 2.20 ms | 20.94 ms | 8 | 62 | 0 | 0 | |
root | jump_if_not | 30489 | 24.65 ms | 659.63 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 607 | 21.27 ms | 358.40 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 12473 | 11.47 ms | 2.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1471 | 8.94 ms | 209.34 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 32 | 6.20 ms | 698.75 us | 2.06 ms | 0 | 64 | 0 | 32 | |
root | show_storage_engines | 26 | 5.76 ms | 1.94 ms | 3.68 ms | 234 | 234 | 0 | 26 | |
root | Prepare | 32 | 5.62 ms | 942.73 us | 0 ps | 0 | 0 | 0 | 0 |
|