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.02 ms | 1.02 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1185 | 182.69 ms | 2.62 ms | 74.21 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1185 | 70.47 ms | 312.76 us | 25.84 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1183 | 8.97 ms | 167.67 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 56956 | 24.98 s | 831.35 ms | 8.49 s | 146796 | 1153598 | 0 | 12266 | |
root | show_keys | 1246 | 1.73 s | 348.01 ms | 481.40 ms | 1324 | 13850 | 0 | 0 | |
root | show_fields | 1406 | 1.36 s | 6.62 ms | 543.88 ms | 51705 | 262976 | 0 | 0 | |
root | show_variables | 1321 | 1.24 s | 30.55 ms | 129.46 ms | 2425 | 758002 | 0 | 1321 | |
root | show_tables | 567 | 318.88 ms | 10.47 ms | 187.85 ms | 8105 | 25370 | 0 | 0 | |
root | set_option | 3680 | 176.07 ms | 3.81 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 689 | 158.94 ms | 5.91 ms | 1.69 ms | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 150.03 ms | 50.69 ms | 212.00 us | 0 | 0 | 3 | 0 | |
root | show_grants | 1035 | 80.26 ms | 168.06 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1126 | 63.64 ms | 260.30 us | 7.45 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 184 | 35.92 ms | 1.03 ms | 21.75 ms | 0 | 47 | 0 | 0 | |
root | show_create_proc | 239 | 26.56 ms | 2.68 ms | 1.93 ms | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 21.41 ms | 20.91 ms | 219.00 us | 900 | 900 | 0 | 2 | |
root | show_master_status | 29 | 20.49 ms | 19.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 214 | 20.24 ms | 970.84 us | 1.35 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 606 | 19.02 ms | 137.85 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 16414 | 16.77 ms | 621.39 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 9119 | 15.14 ms | 323.44 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 85 | 13.05 ms | 5.15 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1335 | 10.33 ms | 218.32 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 166 | 9.21 ms | 2.93 ms | 0 ps | 0 | 33 | 0 | 0 |
|