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 | 890.51 us | 890.51 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 642 | 119.51 ms | 665.08 us | 48.40 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 642 | 55.41 ms | 311.07 us | 19.20 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 640 | 4.27 ms | 63.06 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 31985 | 14.47 s | 360.82 ms | 4.29 s | 74177 | 894435 | 0 | 7647 | |
root | show_keys | 1083 | 1.40 s | 75.04 ms | 396.14 ms | 1122 | 17069 | 0 | 0 | |
root | create_table | 6 | 1.13 s | 212.57 ms | 2.85 ms | 0 | 0 | 0 | 0 | |
root | show_fields | 1132 | 1.12 s | 8.53 ms | 439.80 ms | 45555 | 231943 | 0 | 0 | |
root | show_variables | 1069 | 938.91 ms | 3.82 ms | 91.32 ms | 1069 | 613459 | 0 | 1069 | |
root | show_tables | 566 | 387.28 ms | 3.35 ms | 203.24 ms | 11498 | 34093 | 0 | 0 | |
root | set_option | 2545 | 164.99 ms | 8.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 135.09 ms | 60.12 ms | 569.00 us | 0 | 0 | 3 | 0 | |
root | show_create_table | 571 | 125.31 ms | 9.48 ms | 374.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 625 | 48.45 ms | 1.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 829 | 42.73 ms | 335.28 us | 3.72 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 77 | 18.27 ms | 3.49 ms | 11.49 ms | 0 | 20 | 0 | 0 | |
root | show_warnings | 505 | 15.65 ms | 178.57 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1052 | 7.84 ms | 750.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 28 | 4.78 ms | 368.54 us | 1.62 ms | 18 | 38 | 0 | 10 | |
root | Prepare | 28 | 4.53 ms | 755.08 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 1094 | 4.20 ms | 1.65 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 11 | 3.26 ms | 1.66 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 8 | 2.96 ms | 2.37 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 2294 | 2.68 ms | 494.31 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 6 | 2.50 ms | 2.04 ms | 2.22 ms | 54 | 54 | 0 | 6 |
|