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: 135,875,115 Documentation

  • ø per hour: 89,546
  • ø per minute: 1,492
  • ø per second: 25
Statements # ø per hour %
set option 83,724 k 55.2 k 61.62
select 29,314 k 19.3 k 21.57
commit 20,734 k 13.7 k 15.26
update 1,104 k 727.4 0.81
show variables 149 k 98.2 0.11
show tables 129 k 85.1 0.09
show collations 120 k 79 0.09
change db 114 k 75.3 0.08
show fields 92,776 61.1 0.07
show keys 83,731 55.2 0.06
insert 76,269 50.3 0.06
stmt prepare 49,263 32.5 0.04
stmt close 49,261 32.5 0.04
stmt execute 49,261 32.5 0.04
show grants 24,753 16.3 0.02
show create table 20,435 13.5 0.02
delete 13,099 8.6 0.01
insert select 13,083 8.6 0.01
show warnings 7,099 4.7 0.01
show storage engines 3,746 2.5 <0.01
show binlogs 3,495 2.3 <0.01
show table status 1,047 0.7 <0.01
show slave status 268 0.2 <0.01
show master status 251 0.2 <0.01
show status 160 0.1 <0.01
show charsets 27 <0.1 <0.01
show processlist 18 <0.1 <0.01
show databases 12 <0.1 <0.01
show engine status 12 <0.1 <0.01
show function status 12 <0.1 <0.01
show procedure status 12 <0.1 <0.01
flush 7 <0.1 <0.01
create table 2 <0.1 <0.01
stmt reset 2 <0.1 <0.01
truncate 2 <0.1 <0.01
rollback 1 <0.1 <0.01
show triggers 1 <0.1 <0.01