Press Ctrl+Enter to execute queryPress Enter to execute query
Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: information_schema Queried time: During current session
SELECT * FROM `USER_STATISTICS`
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 3,773 k | 367.4 k | 74.08 |
| delete | 282 k | 27.5 k | 5.54 |
| insert | 163 k | 15.8 k | 3.19 |
| show fields | 153 k | 14.9 k | 3.01 |
| show keys | 140 k | 13.6 k | 2.74 |
| update | 121 k | 11.8 k | 2.38 |
| change db | 111 k | 10.8 k | 2.18 |
| set option | 81,439 | 7,928.7 | 1.60 |
| show tables | 79,305 | 7,721 | 1.56 |
| show create table | 58,195 | 5,665.7 | 1.14 |
| flush | 40,333 | 3,926.7 | 0.79 |
| show variables | 26,197 | 2,550.5 | 0.51 |
| show grants | 13,905 | 1,353.8 | 0.27 |
| replace | 13,219 | 1,287 | 0.26 |
| show slave status | 10,506 | 1,022.8 | 0.21 |
| show master status | 10,222 | 995.2 | 0.20 |
| show create proc | 6,048 | 588.8 | 0.12 |
| show binlogs | 4,849 | 472.1 | 0.10 |
| show create func | 1,872 | 182.3 | 0.04 |
| show plugins | 1,019 | 99.2 | 0.02 |
| show storage engines | 1,000 | 97.4 | 0.02 |
| show status | 413 | 40.2 | 0.01 |
| call procedure | 390 | 38 | 0.01 |
| create temporary table | 301 | 29.3 | 0.01 |
| drop table | 301 | 29.3 | 0.01 |
| insert select | 301 | 29.3 | 0.01 |
| stmt prepare | 52 | 5.1 | <0.01 |
| stmt execute | 52 | 5.1 | <0.01 |
| stmt close | 52 | 5.1 | <0.01 |
| show processlist | 30 | 2.9 | <0.01 |