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 | 1.22 ms | 1.22 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 551 | 99.79 ms | 677.47 us | 40.99 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 550 | 46.01 ms | 417.05 us | 16.29 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 547 | 3.73 ms | 51.84 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 19803 | 10.96 s | 457.94 ms | 2.72 s | 59494 | 431364 | 0 | 6258 | |
root | show_keys | 856 | 2.03 s | 129.24 ms | 327.41 ms | 930 | 14600 | 0 | 0 | |
root | show_fields | 920 | 913.91 ms | 4.97 ms | 357.81 ms | 36804 | 187537 | 0 | 0 | |
root | show_variables | 816 | 751.64 ms | 5.71 ms | 74.68 ms | 815 | 468342 | 0 | 816 | |
root | show_tables | 428 | 253.36 ms | 3.40 ms | 128.10 ms | 8845 | 26530 | 0 | 0 | |
root | set_option | 2078 | 135.28 ms | 5.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 470 | 92.84 ms | 830.09 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 652 | 35.56 ms | 328.08 us | 3.88 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 410 | 34.23 ms | 1.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 393 | 12.09 ms | 66.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 52 | 8.35 ms | 2.61 ms | 5.65 ms | 0 | 0 | 0 | 0 | |
root | Quit | 872 | 5.94 ms | 189.50 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 41 | 5.34 ms | 2.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 303 | 3.64 ms | 2.80 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 1752 | 2.29 ms | 740.45 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 1 | 1.82 ms | 1.82 ms | 602.00 us | 0 | 2 | 0 | 1 | |
root | show_master_status | 12 | 1.08 ms | 652.50 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 1 | 814.32 us | 814.32 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 3 | 806.14 us | 650.05 us | 0 ps | 0 | 3 | 0 | 0 | |
root | error | 8 | 746.03 us | 450.98 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 6 | 737.08 us | 621.12 us | 0 ps | 0 | 3 | 0 | 0 |
|