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 | 2015 | 353.94 ms | 998.62 us | 143.51 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2015 | 162.47 ms | 560.05 us | 56.54 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2013 | 12.31 ms | 49.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 85561 | 42.44 s | 1.02 s | 11.78 s | 253511 | 1697395 | 0 | 22912 | |
root | show_fields | 3927 | 3.95 s | 5.55 ms | 1.57 s | 152680 | 778155 | 0 | 0 | |
root | show_keys | 3661 | 3.74 s | 109.61 ms | 1.40 s | 3846 | 62723 | 0 | 0 | |
root | show_variables | 3512 | 3.08 s | 7.28 ms | 306.24 ms | 3512 | 2015594 | 0 | 3512 | |
root | create_table | 4 | 1.07 s | 427.25 ms | 10.90 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1738 | 1.06 s | 5.49 ms | 533.66 ms | 39735 | 120097 | 0 | 0 | |
root | set_option | 8262 | 470.67 ms | 8.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1947 | 391.00 ms | 3.98 ms | 755.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 7 | 274.48 ms | 63.56 ms | 398.00 us | 0 | 0 | 6 | 0 | |
root | Init DB | 2617 | 130.58 ms | 533.68 us | 7.98 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1413 | 113.14 ms | 1.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1668 | 50.83 ms | 681.75 us | 0 ps | 0 | 0 | 0 | 0 | |
root | insert | 1 | 28.91 ms | 28.91 ms | 1.85 ms | 0 | 0 | 1 | 0 | |
root | Quit | 3546 | 22.02 ms | 332.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 92 | 16.83 ms | 1.49 ms | 9.44 ms | 33 | 244 | 0 | 0 | |
root | show_master_status | 28 | 12.63 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 87 | 7.95 ms | 1.97 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_storage_engines | 44 | 7.15 ms | 2.13 ms | 4.44 ms | 396 | 396 | 0 | 44 | |
root | jump_if_not | 9291 | 7.09 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 |
|