Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Questions since startup: 30,697,970 Documentation

  • ø per hour: 15,983,901
  • ø per minute: 266,398
  • ø per second: 4,440
Statements # ø per hour %
select 26,852 k 14 M 87.47
stmt prepare 913 k 475.6 k 2.98
stmt execute 913 k 475.5 k 2.97
stmt close 913 k 475.5 k 2.97
set option 421 k 219.4 k 1.37
update 209 k 108.9 k 0.68
change db 149 k 77.5 k 0.48
insert 111 k 58 k 0.36
show fields 93,847 48.9 k 0.31
delete 26,341 13.7 k 0.09
replace 24,361 12.7 k 0.08
show status 20,904 10.9 k 0.07
show tables 14,563 7,582.7 0.05
show variables 7,101 3,697.4 0.02
insert select 6,932 3,609.4 0.02
show engine status 6,889 3,587 0.02
show generic 6,889 3,587 0.02
update multi 2,077 1,081.5 0.01
show processlist 1,868 972.6 0.01
show keys 1,025 533.7 <0.01
show profile 592 308.2 <0.01
alter table 452 235.3 <0.01
delete multi 311 161.9 <0.01
begin 278 144.7 <0.01
commit 278 144.7 <0.01
show databases 173 90.1 <0.01
show create table 157 81.7 <0.01
create table 154 80.2 <0.01
truncate 120 62.5 <0.01
enable governor lve 115 59.9 <0.01
show profiles 38 19.8 <0.01
show warnings 32 16.7 <0.01
show grants 27 14.1 <0.01
show table status 19 9.9 <0.01
show storage engines 13 6.8 <0.01
show binlogs 7 3.6 <0.01
stmt send long data 5 2.6 <0.01
show slave status 4 2.1 <0.01
lock tables 3 1.6 <0.01
show binlog status 3 1.6 <0.01
unlock tables 3 1.6 <0.01
show function status 1 0.5 <0.01
show procedure status 1 0.5 <0.01