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: 14,120,645 Documentation

  • ø per hour: 45,427
  • ø per minute: 757
  • ø per second: 13
Statements # ø per hour %
select 7,370 k 23.7 k 52.19
stmt execute 5,286 k 17 k 37.43
stmt prepare 480 k 1,543.5 3.40
stmt close 479 k 1,541.1 3.39
show tables 138 k 443.4 0.98
show fields 106 k 339.6 0.75
change db 88,666 285.2 0.63
set option 74,972 241.2 0.53
show keys 36,902 118.7 0.26
show variables 14,037 45.2 0.10
replace 11,194 36 0.08
show create table 8,539 27.5 0.06
update 7,168 23.1 0.05
show warnings 5,364 17.3 0.04
insert 4,195 13.5 0.03
begin 3,609 11.6 0.03
commit 2,924 9.4 0.02
show storage engines 1,530 4.9 0.01
show grants 916 2.9 0.01
show binlogs 745 2.4 0.01
rollback 660 2.1 <0.01
show table status 282 0.9 <0.01
show slave status 211 0.7 <0.01
show master status 205 0.7 <0.01
rollback to savepoint 164 0.5 <0.01
delete 153 0.5 <0.01
show status 38 0.1 <0.01
unlock tables 27 0.1 <0.01
release savepoint 25 0.1 <0.01
savepoint 25 0.1 <0.01
show events 25 0.1 <0.01
create table 13 <0.1 <0.01
alter table 11 <0.1 <0.01
show function status 8 <0.1 <0.01
show procedure status 8 <0.1 <0.01
grant 7 <0.1 <0.01
show package status 7 <0.1 <0.01
show package body status 7 <0.1 <0.01
flush 6 <0.1 <0.01
show processlist 5 <0.1 <0.01
create db 3 <0.1 <0.01
create user 3 <0.1 <0.01
rename table 3 <0.1 <0.01
show engine status 3 <0.1 <0.01
update multi 3 <0.1 <0.01
lock tables 2 <0.1 <0.01
revoke 2 <0.1 <0.01
drop db 1 <0.1 <0.01
drop table 1 <0.1 <0.01