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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





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

Questions since startup: 16,608,938 Documentation

  • ø per hour: 60,211
  • ø per minute: 1,004
  • ø per second: 17
Statements # ø per hour %
select 9,426 k 34.2 k 56.76
change db 2,274 k 8,244.8 13.69
set option 1,900 k 6,888.1 11.44
show fields 640 k 2,321.3 3.86
show tables 519 k 1,882.5 3.13
show create table 454 k 1,645.9 2.73
show table status 354 k 1,282.7 2.13
show triggers 352 k 1,275.5 2.12
insert 218 k 789.9 1.31
show keys 156 k 564.2 0.94
delete 144 k 520.7 0.86
update 60,851 220.6 0.37
replace 35,570 128.9 0.21
show grants 24,416 88.5 0.15
show variables 24,226 87.8 0.15
commit 7,169 26 0.04
show warnings 5,840 21.2 0.04
show storage engines 4,822 17.5 0.03
create table 3,979 14.4 0.02
drop table 2,583 9.4 0.02
truncate 407 1.5 <0.01
stmt close 297 1.1 <0.01
stmt execute 297 1.1 <0.01
stmt prepare 297 1.1 <0.01
show collations 290 1.1 <0.01
show binlogs 277 1 <0.01
show slave status 145 0.5 <0.01
show master status 137 0.5 <0.01
show status 40 0.1 <0.01
rollback 12 <0.1 <0.01
insert select 10 <0.1 <0.01
alter table 7 <0.1 <0.01
show charsets 6 <0.1 <0.01
show processlist 6 <0.1 <0.01
show databases 5 <0.1 <0.01
flush 4 <0.1 <0.01
show engine status 3 <0.1 <0.01
load 2 <0.1 <0.01
create db 1 <0.1 <0.01
create trigger 1 <0.1 <0.01
drop trigger 1 <0.1 <0.01