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 | 90.56 us | 90.56 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 5157 | 1.03 s | 1.38 ms | 419.18 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 5157 | 487.95 ms | 659.35 us | 169.63 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 5156 | 35.06 ms | 183.05 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 200146 | 1.29 m | 879.31 ms | 28.06 s | 420448 | 2902125 | 0 | 42821 | |
root | drop_db | 39 | 7.52 s | 1.16 s | 20.25 ms | 0 | 0 | 87 | 0 | |
root | create_table | 39 | 6.64 s | 387.83 ms | 17.24 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 6311 | 5.62 s | 5.70 ms | 549.15 ms | 8519 | 3621569 | 0 | 6311 | |
root | show_fields | 5498 | 5.36 s | 7.91 ms | 2.15 s | 212353 | 1079975 | 0 | 0 | |
root | show_keys | 6367 | 5.10 s | 80.68 ms | 2.35 s | 4770 | 56720 | 0 | 0 | |
root | create_db | 29 | 1.27 s | 73.70 ms | 6.24 ms | 0 | 0 | 26 | 0 | |
root | insert | 36 | 1.16 s | 149.34 ms | 8.93 ms | 0 | 0 | 162 | 0 | |
root | show_tables | 1917 | 1.10 s | 14.01 ms | 627.45 ms | 23247 | 64286 | 0 | 0 | |
root | set_option | 16549 | 995.27 ms | 6.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2815 | 615.63 ms | 1.89 ms | 1.86 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 4440 | 256.14 ms | 470.34 us | 26.93 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2506 | 201.89 ms | 349.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 278 | 156.98 ms | 39.96 ms | 73.60 ms | 73 | 705 | 0 | 0 | |
root | show_warnings | 2745 | 87.28 ms | 915.12 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 65859 | 54.90 ms | 1.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 5965 | 40.10 ms | 252.70 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 128 | 33.74 ms | 16.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 4 | 32.98 ms | 16.39 ms | 583.00 us | 1800 | 1800 | 0 | 4 | |
root | set | 510 | 24.79 ms | 2.09 ms | 0 ps | 0 | 105 | 0 | 0 | |
root | freturn | 22908 | 23.92 ms | 1.71 ms | 0 ps | 0 | 0 | 0 | 0 |
|