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 | 4.22 ms | 4.22 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 884 | 155.00 ms | 1.19 ms | 62.62 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 884 | 66.71 ms | 338.32 us | 23.33 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 878 | 5.76 ms | 32.98 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 18040 | 9.49 s | 995.46 ms | 2.40 s | 63931 | 577789 | 0 | 7795 | |
root | show_fields | 1304 | 1.38 s | 32.76 ms | 498.45 ms | 63788 | 323412 | 0 | 0 | |
root | show_variables | 1189 | 1.03 s | 7.92 ms | 107.42 ms | 1189 | 682423 | 0 | 1189 | |
root | show_keys | 896 | 988.09 ms | 76.14 ms | 320.21 ms | 1439 | 11015 | 0 | 0 | |
root | show_tables | 377 | 246.11 ms | 2.83 ms | 130.97 ms | 7743 | 40183 | 0 | 0 | |
root | set_option | 2732 | 187.60 ms | 30.86 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 576 | 141.52 ms | 16.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 93.17 ms | 48.90 ms | 7.94 ms | 0 | 0 | 2 | 0 | |
root | show_grants | 509 | 39.08 ms | 510.64 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 805 | 38.15 ms | 1.19 ms | 1.08 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 564 | 16.71 ms | 557.62 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 142 | 12.30 ms | 654.78 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 2080 | 7.28 ms | 1.98 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 938 | 6.40 ms | 203.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 10 | 4.05 ms | 1.15 ms | 2.99 ms | 0 | 6 | 0 | 0 | |
root | show_slave_status | 5 | 3.62 ms | 2.86 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 1927 | 2.87 ms | 959.74 us | 0 ps | 0 | 0 | 0 | 0 | |
root | change_db | 1 | 2.40 ms | 2.40 ms | 65.00 us | 0 | 0 | 0 | 0 | |
root | error | 8 | 2.40 ms | 1.94 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 5 | 1.78 ms | 1.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 1 | 789.74 us | 789.74 us | 0 ps | 0 | 1 | 0 | 0 |
|