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: 14,101,371 Documentation

  • ø per hour: 779,883
  • ø per minute: 12,998
  • ø per second: 217
Statements # ø per hour %
select 13,586 k 751.4 k 96.34
set option 166 k 9,185.9 1.18
update 103 k 5,698.1 0.73
show fields 77,476 4,284.8 0.55
change db 46,510 2,572.3 0.33
show tables 41,183 2,277.6 0.29
insert 40,616 2,246.3 0.29
delete 18,398 1,017.5 0.13
show processlist 13,230 731.7 0.09
insert select 1,156 63.9 0.01
update multi 1,104 61.1 0.01
show variables 1,005 55.6 0.01
show status 883 48.8 0.01
create table 671 37.1 <0.01
stmt execute 651 36 <0.01
stmt close 651 36 <0.01
stmt prepare 651 36 <0.01
stmt send long data 651 36 <0.01
show table status 334 18.5 <0.01
show create table 324 17.9 <0.01
show keys 299 16.5 <0.01
replace 154 8.5 <0.01
delete multi 137 7.6 <0.01
check 114 6.3 <0.01
show grants 96 5.3 <0.01
show binlogs 65 3.6 <0.01
show triggers 30 1.7 <0.01
truncate 29 1.6 <0.01
lock tables 28 1.5 <0.01
unlock tables 28 1.5 <0.01
show storage engines 26 1.4 <0.01
show master status 21 1.2 <0.01
show replica status 21 1.2 <0.01
show slave status 21 1.2 <0.01
drop table 10 0.6 <0.01
show databases 4 0.2 <0.01
flush 2 0.1 <0.01
show engine status 2 0.1 <0.01
show function status 2 0.1 <0.01
show procedure status 2 0.1 <0.01
alter table 1 0.1 <0.01
create db 1 0.1 <0.01
drop db 1 0.1 <0.01
optimize 1 0.1 <0.01