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 | 2.05 ms | 2.05 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1783 | 312.15 ms | 998.62 us | 126.66 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1783 | 143.04 ms | 560.05 us | 49.91 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1782 | 10.90 ms | 49.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 75006 | 38.29 s | 1.02 s | 10.35 s | 221057 | 1489866 | 0 | 20407 | |
root | show_fields | 3471 | 3.50 s | 5.55 ms | 1.39 s | 135658 | 691297 | 0 | 0 | |
root | show_keys | 3231 | 3.41 s | 109.61 ms | 1.24 s | 3370 | 55021 | 0 | 0 | |
root | show_variables | 3127 | 2.76 s | 7.28 ms | 273.32 ms | 3127 | 1794667 | 0 | 3127 | |
root | show_tables | 1545 | 937.58 ms | 4.81 ms | 472.64 ms | 35386 | 106547 | 0 | 0 | |
root | create_table | 2 | 431.33 ms | 235.64 ms | 10.59 ms | 0 | 0 | 0 | 0 | |
root | set_option | 7311 | 422.32 ms | 8.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1722 | 349.62 ms | 3.98 ms | 711.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 233.14 ms | 63.56 ms | 310.00 us | 0 | 0 | 5 | 0 | |
root | Init DB | 2306 | 115.25 ms | 533.68 us | 7.34 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1270 | 101.86 ms | 1.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1486 | 45.48 ms | 681.75 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3144 | 19.46 ms | 332.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 82 | 15.43 ms | 1.49 ms | 8.62 ms | 33 | 242 | 0 | 0 | |
root | show_master_status | 24 | 12.49 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 7.28 ms | 1.41 ms | 1.70 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 75 | 7.22 ms | 1.97 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 35 | 6.25 ms | 2.13 ms | 4.03 ms | 315 | 315 | 0 | 35 | |
root | jump_if_not | 7991 | 6.05 ms | 283.92 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 34 | 5.46 ms | 699.85 us | 2.00 ms | 28 | 42 | 0 | 7 | |
root | Prepare | 34 | 4.58 ms | 923.81 us | 0 ps | 0 | 0 | 0 | 0 |
|