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.78 ms | 2.78 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 665 | 160.74 ms | 632.23 us | 64.85 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 665 | 79.52 ms | 330.24 us | 26.99 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 664 | 4.24 ms | 73.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 11990 | 8.60 s | 751.29 ms | 1.72 s | 65523 | 1528108 | 0 | 5461 | |
root | show_keys | 695 | 2.79 s | 546.79 ms | 285.06 ms | 772 | 9245 | 0 | 0 | |
root | show_table_status | 80 | 670.89 ms | 422.50 ms | 17.32 ms | 268 | 1702 | 0 | 0 | |
root | show_fields | 685 | 654.65 ms | 4.09 ms | 296.97 ms | 16842 | 86884 | 0 | 0 | |
root | show_variables | 600 | 556.93 ms | 5.15 ms | 53.92 ms | 574 | 342846 | 0 | 600 | |
root | set_option | 1925 | 160.41 ms | 5.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 226 | 153.34 ms | 2.98 ms | 81.43 ms | 4040 | 15840 | 0 | 0 | |
root | create_db | 1 | 100.60 ms | 100.60 ms | 3.46 ms | 0 | 0 | 1 | 0 | |
root | show_create_table | 339 | 70.71 ms | 6.88 ms | 573.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 630 | 54.55 ms | 702.43 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 698 | 48.73 ms | 1.92 ms | 6.12 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 5747 | 11.23 ms | 6.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 43 | 10.48 ms | 702.54 us | 3.24 ms | 9 | 77 | 0 | 34 | |
root | Prepare | 43 | 8.53 ms | 692.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 48 | 7.05 ms | 402.47 us | 3.47 ms | 432 | 432 | 0 | 48 | |
root | show_warnings | 217 | 6.42 ms | 154.71 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 738 | 5.74 ms | 228.68 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 5 | 4.26 ms | 2.13 ms | 0 ps | 0 | 5 | 0 | 0 | |
root | freturn | 986 | 4.01 ms | 955.87 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 39 | 3.59 ms | 743.20 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 5 | 2.46 ms | 1.90 ms | 0 ps | 0 | 0 | 0 | 0 |
|