Drop files here

SQL upload ( 0 ) x -

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
Restore default values
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Browse mode
Customise browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `x$statements_with_full_table_scans`
query db exec_count total_latency no_index_used_count no_good_index_used_count no_index_used_pct rows_sent rows_examined rows_sent_avg rows_examined_avg first_seen last_seen digest
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 55 37152837000 55 0 100 461 3022 8 55 2024-06-15 19:00:47.711136 2024-06-15 19:00:58.550353 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 2 14834505000 2 0 100 2 202 1 101 2024-06-15 19:00:48.231912 2024-06-15 19:00:58.382792 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 1 14158571000 1 0 100 1 58 1 58 2024-06-15 19:00:47.858012 2024-06-15 19:00:47.858012 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 24 14053707000 24 0 100 198 1326 8 55 2024-06-15 19:00:48.105265 2024-06-15 19:00:57.889182 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql 14 7605981000 14 0 100 130 862 9 62 2024-06-15 19:00:48.284730 2024-06-15 19:00:58.443010 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL 14 6511570000 14 0 100 14 56 1 4 2024-06-15 19:00:47.742352 2024-06-15 19:00:58.563626 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT * FROM `staff` LIMIT ?, ... sakila 1 6465668000 1 0 100 2 2 2 2 2024-06-15 19:00:47.798093 2024-06-15 19:00:47.798093 7179f61b49b0d32a13a844ccc0067af92d2002b32870b6c213...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 6 5865896000 6 0 100 6 822 1 137 2024-06-15 19:00:47.979764 2024-06-15 19:00:57.804527 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... NULL 26 4742496000 26 0 100 26 4498 1 173 2024-06-15 19:00:47.742830 2024-06-15 19:00:58.564498 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema 4 4232318000 4 0 100 100 100 25 25 2024-06-15 19:00:47.977353 2024-06-15 19:00:49.569748 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema 7 4007261000 7 0 100 65 430 9 61 2024-06-15 19:00:58.075166 2024-06-15 19:00:58.197210 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema 6 3358438000 6 0 100 6 24 1 4 2024-06-15 19:00:48.127060 2024-06-15 19:00:57.901969 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... NULL 2 2802573000 2 0 100 544 626 272 313 2024-06-15 19:00:48.364264 2024-06-15 19:00:53.651184 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 4 2234198000 4 0 100 33 223 8 56 2024-06-15 19:00:47.892256 2024-06-15 19:00:47.906866 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql 4 2231080000 4 0 100 4 16 1 4 2024-06-15 19:00:48.307231 2024-06-15 19:00:58.455069 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql 2 1824157000 2 0 100 544 626 272 313 2024-06-15 19:00:49.758373 2024-06-15 19:00:53.237101 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT * FROM `table_io_waits_summary_by_table` LI... performance_schema 2 1694120000 2 0 100 50 50 25 25 2024-06-15 19:00:57.456281 2024-06-15 19:00:57.802337 655b4753a0dac187bc653579603616fcda59e9d63159157fda...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 1 1332248000 1 0 100 1 101 1 101 2024-06-15 19:00:58.028063 2024-06-15 19:00:58.028063 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 4 1283237000 4 0 100 4 0 1 0 2024-06-15 19:00:47.980260 2024-06-15 19:00:49.573478 00e2f0d84fa651f12d7029618430a48906da993321f506b59a...
SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co... NULL 2 973674000 2 0 100 82 164 41 82 2024-06-15 19:00:48.362651 2024-06-15 19:00:53.649266 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... information_schema 2 869436000 2 0 100 2 8 1 4 2024-06-15 19:00:58.102663 2024-06-15 19:00:58.209738 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM `performance_schema` . `table_lock_w... performance_schema 4 676965000 4 0 100 4 4 1 1 2024-06-15 19:00:48.144758 2024-06-15 19:00:49.739341 0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... mysql 2 570754000 2 0 100 2 346 1 173 2024-06-15 19:00:48.308037 2024-06-15 19:00:58.455507 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co... mysql 2 554542000 2 0 100 82 164 41 82 2024-06-15 19:00:49.757052 2024-06-15 19:00:53.235958 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... sakila 1 532931000 1 0 100 1 4 1 4 2024-06-15 19:00:47.928133 2024-06-15 19:00:47.928133 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
Query results operations