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.63 ms | 1.63 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2006 | 432.37 ms | 1.02 ms | 176.06 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2006 | 207.62 ms | 568.49 us | 70.96 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2005 | 15.58 ms | 142.66 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 67032 | 24.04 s | 543.33 ms | 8.62 s | 187038 | 1251636 | 0 | 18448 | |
root | show_fields | 2468 | 2.44 s | 4.93 ms | 915.96 ms | 117762 | 597684 | 0 | 0 | |
root | show_variables | 2432 | 2.05 s | 30.78 ms | 217.03 ms | 2968 | 1394456 | 0 | 2432 | |
root | show_keys | 1874 | 1.88 s | 93.73 ms | 651.44 ms | 2832 | 33104 | 0 | 0 | |
root | show_binlogs | 89 | 831.95 ms | 821.01 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_table | 3 | 652.35 ms | 260.34 ms | 6.77 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 704 | 446.21 ms | 4.48 ms | 271.58 ms | 4815 | 17955 | 0 | 0 | |
root | set_option | 6151 | 421.39 ms | 5.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1227 | 234.99 ms | 3.59 ms | 893.00 us | 0 | 0 | 0 | 0 | |
root | show_table_status | 60 | 182.72 ms | 100.68 ms | 31.11 ms | 121 | 825 | 0 | 0 | |
root | create_db | 4 | 163.68 ms | 70.68 ms | 1.06 ms | 0 | 0 | 3 | 0 | |
root | show_grants | 1682 | 131.82 ms | 1.07 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1850 | 107.10 ms | 2.45 ms | 5.33 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 1108 | 32.00 ms | 124.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 20536 | 17.07 ms | 636.84 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2095 | 17.07 ms | 241.43 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 15.71 ms | 15.71 ms | 146.00 us | 450 | 450 | 0 | 1 | |
root | Prepare | 25 | 8.72 ms | 3.78 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 5959 | 8.31 ms | 919.18 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 42 | 7.05 ms | 2.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 42 | 5.18 ms | 2.79 ms | 0 ps | 0 | 0 | 0 | 0 |
|