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.32 ms | 3.32 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 817 | 183.98 ms | 583.98 us | 74.81 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 817 | 91.88 ms | 353.95 us | 31.42 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 815 | 5.99 ms | 30.66 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 13492 | 8.74 s | 957.99 ms | 1.78 s | 68548 | 432093 | 0 | 6468 | |
root | show_keys | 632 | 1.37 s | 147.75 ms | 232.26 ms | 945 | 11675 | 0 | 0 | |
root | show_fields | 831 | 778.06 ms | 4.19 ms | 316.13 ms | 31449 | 160333 | 0 | 0 | |
root | show_variables | 757 | 663.08 ms | 5.99 ms | 69.91 ms | 749 | 433741 | 0 | 757 | |
root | show_tables | 392 | 247.77 ms | 3.16 ms | 150.55 ms | 2495 | 8333 | 0 | 0 | |
root | set_option | 2627 | 210.41 ms | 6.45 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 194.13 ms | 194.13 ms | 1.70 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 399 | 66.70 ms | 968.39 us | 244.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 61.62 ms | 61.62 ms | 775.00 us | 0 | 0 | 1 | 0 | |
root | show_grants | 713 | 57.85 ms | 326.77 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 727 | 42.83 ms | 412.24 us | 2.89 ms | 0 | 0 | 0 | 0 | |
root | insert | 1 | 33.89 ms | 33.89 ms | 1.97 ms | 0 | 0 | 1 | 0 | |
root | show_table_status | 87 | 25.12 ms | 1.47 ms | 15.47 ms | 4 | 66 | 0 | 0 | |
root | show_warnings | 328 | 10.17 ms | 236.86 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 39 | 7.38 ms | 2.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 935 | 5.62 ms | 216.62 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 27 | 3.22 ms | 405.32 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 27 | 3.21 ms | 368.57 us | 941.00 us | 0 | 54 | 0 | 27 | |
root | show_storage_engines | 25 | 3.00 ms | 348.99 us | 1.39 ms | 225 | 225 | 0 | 25 | |
root | error | 22 | 2.98 ms | 2.29 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 27 | 2.48 ms | 451.74 us | 0 ps | 0 | 0 | 0 | 0 |
|