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.12 ms | 1.12 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1364 | 321.35 ms | 1.68 ms | 129.25 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1364 | 156.90 ms | 426.04 us | 54.57 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1363 | 9.05 ms | 33.48 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 25045 | 11.77 s | 1.01 s | 3.19 s | 103325 | 701630 | 0 | 11752 | |
root | show_keys | 1060 | 1.50 s | 84.88 ms | 368.40 ms | 1586 | 19279 | 0 | 0 | |
root | show_fields | 1345 | 1.27 s | 4.54 ms | 489.03 ms | 58104 | 295394 | 0 | 0 | |
root | show_variables | 1428 | 1.20 s | 9.00 ms | 127.27 ms | 7604 | 819462 | 0 | 1428 | |
root | set_option | 4505 | 359.63 ms | 6.98 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 440 | 218.84 ms | 6.15 ms | 105.23 ms | 5853 | 17433 | 0 | 0 | |
root | show_create_table | 663 | 114.10 ms | 1.23 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1343 | 107.90 ms | 392.38 us | 21.55 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1309 | 106.20 ms | 350.68 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 498 | 54.96 ms | 1.78 ms | 28.67 ms | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 54.31 ms | 54.31 ms | 2.07 ms | 0 | 0 | 1 | 0 | |
root | show_warnings | 607 | 17.85 ms | 124.67 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1638 | 13.19 ms | 264.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 48 | 7.67 ms | 630.33 us | 2.67 ms | 1 | 97 | 0 | 48 | |
root | Prepare | 48 | 6.60 ms | 920.42 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 146 | 6.42 ms | 1.35 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 67 | 5.26 ms | 675.27 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 125 | 5.21 ms | 5.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 15 | 2.90 ms | 1.90 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 1 | 2.45 ms | 2.45 ms | 0 ps | 0 | 1 | 0 | 0 | |
root | set | 2 | 2.42 ms | 2.42 ms | 0 ps | 0 | 1 | 0 | 0 |
|