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.14 ms | 1.14 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1507 | 235.14 ms | 3.59 ms | 93.01 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1507 | 91.35 ms | 1.90 ms | 32.33 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1505 | 10.13 ms | 29.65 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 50713 | 26.34 s | 946.74 ms | 7.80 s | 190816 | 2098424 | 0 | 14486 | |
root | show_keys | 1739 | 3.85 s | 425.35 ms | 681.99 ms | 1854 | 20448 | 0 | 0 | |
root | show_fields | 1971 | 1.79 s | 8.35 ms | 748.01 ms | 58808 | 300408 | 0 | 0 | |
root | show_variables | 1494 | 1.43 s | 15.05 ms | 143.16 ms | 3741 | 856947 | 0 | 1494 | |
root | create_table | 3 | 693.56 ms | 289.51 ms | 2.81 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 644 | 388.80 ms | 1.67 ms | 240.32 ms | 6480 | 20949 | 0 | 0 | |
root | set_option | 4703 | 215.60 ms | 6.57 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 887 | 189.76 ms | 5.62 ms | 3.53 ms | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 128.50 ms | 46.63 ms | 545.00 us | 0 | 0 | 3 | 0 | |
root | show_grants | 1167 | 91.78 ms | 191.90 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1175 | 59.22 ms | 1.10 ms | 3.12 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 149 | 37.77 ms | 1.32 ms | 23.43 ms | 0 | 67 | 0 | 0 | |
root | show_warnings | 676 | 21.28 ms | 213.98 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 184 | 20.42 ms | 232.09 us | 10.20 ms | 1656 | 1656 | 0 | 184 | |
root | jump_if_not | 19007 | 18.46 ms | 603.74 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 9812 | 17.39 ms | 1.85 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 78 | 16.33 ms | 3.72 ms | 5.05 ms | 0 | 0 | 0 | 0 | |
root | Quit | 1667 | 11.91 ms | 355.95 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 66 | 8.41 ms | 963.87 us | 1.09 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 69 | 7.30 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 13 | 3.92 ms | 1.49 ms | 0 ps | 0 | 13 | 0 | 0 |
|