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
Customize 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` . ... performance_schema 880 428345776000 880 0 100 7458 50204 8 57 2024-06-15 18:45:49.020859 2024-06-15 18:57:48.156856 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 220 245771301000 220 0 100 220 90386 1 411 2024-06-15 18:45:48.889041 2024-06-15 18:57:48.026175 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 14 219840111000 14 0 100 14 5767 1 412 2024-06-15 18:46:02.169694 2024-06-15 18:57:43.270651 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema 220 111791683000 220 0 100 220 880 1 4 2024-06-15 18:45:49.042369 2024-06-15 18:57:48.169062 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema 173 85584330000 173 0 100 1668 11068 10 64 2024-06-15 18:45:50.275437 2024-06-15 18:57:44.645780 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 106 80933687000 106 0 100 1004 6596 9 62 2024-06-15 18:46:07.947748 2024-06-15 18:56:56.987552 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql 90 45231574000 90 0 100 90 360 1 4 2024-06-15 18:45:52.515055 2024-06-15 18:57:47.992206 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... NULL 6 30299077000 6 0 100 0 492 0 82 2024-06-15 18:46:23.086962 2024-06-15 18:47:00.069135 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f...
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema 104 29272843000 104 0 100 2600 2600 25 25 2024-06-15 18:45:48.880629 2024-06-15 18:57:48.023852 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...
SELECT * FROM `country` LIMIT ?, ... sakila 4 29138537000 4 0 100 100 100 25 25 2024-06-15 18:46:02.059046 2024-06-15 18:54:58.853435 d7530f91b1e370283b7520ecf25b5bf015e9f9fef6b4d88d0a...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 104 28941269000 104 0 100 104 0 1 0 2024-06-15 18:45:48.890090 2024-06-15 18:57:48.026695 00e2f0d84fa651f12d7029618430a48906da993321f506b59a...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql 25 28050131000 25 0 100 6800 7825 272 313 2024-06-15 18:46:04.171781 2024-06-15 18:57:39.392448 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL 46 27056142000 46 0 100 46 184 1 4 2024-06-15 18:46:07.965410 2024-06-15 18:57:33.509475 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 47 25345223000 47 0 100 466 3110 10 66 2024-06-15 18:46:02.262456 2024-06-15 18:57:43.333955 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... information_schema 50 21462861000 50 0 100 50 200 1 4 2024-06-15 18:45:50.297228 2024-06-15 18:57:44.658307 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 81 20930912000 81 0 100 81 0 1 0 2024-06-15 18:45:49.090863 2024-06-15 18:57:41.384356 696f372cde401cebf246d3df25ec3dc57b0631201839ba3d19...
SELECT * FROM `table_io_waits_summary_by_table` LI... performance_schema 81 18494501000 81 0 100 2025 2025 25 25 2024-06-15 18:45:49.088277 2024-06-15 18:57:41.381657 655b4753a0dac187bc653579603616fcda59e9d63159157fda...
SELECT `ENGINE` FROM `information_schema` . `ENGIN... information_schema 250 17899457000 250 0 100 250 2250 1 9 2024-06-15 18:46:17.085852 2024-06-15 18:56:03.219083 7a7ef781f8a87ecaafaca60612366942c66b7cb3d2ea562d5d...
SELECT `TABLESPACE_NAME` FROM `information_schema`... information_schema 250 17613153000 250 0 100 0 0 0 0 2024-06-15 18:46:17.084777 2024-06-15 18:56:03.218815 1b9f8b5127195ff2666a798e5069445bfb51943ac52a3c6730...
SELECT ? FROM `performance_schema` . `table_lock_w... performance_schema 104 16874731000 104 0 100 104 104 1 1 2024-06-15 18:45:49.060802 2024-06-15 18:57:48.187332 0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys 28 13370466000 28 0 100 238 1673 9 60 2024-06-15 18:51:32.085439 2024-06-15 18:57:46.547524 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM `performance_schema` . `table_io_wai... performance_schema 81 13040716000 81 0 100 81 81 1 1 2024-06-15 18:45:49.197139 2024-06-15 18:57:41.488766 9aee979c260990db59b36dc80103740e28605326d73688af7e...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... mysql 63 11700076000 63 0 100 63 10899 1 173 2024-06-15 18:45:52.515487 2024-06-15 18:57:47.992685 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... NULL 48 9827193000 48 0 100 48 8304 1 173 2024-06-15 18:46:36.666012 2024-06-15 18:57:33.512471 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT * FROM `user` LIMIT ?, ... mysql 56 9761742000 56 0 100 504 504 9 9 2024-06-15 18:45:52.322761 2024-06-15 18:57:37.983344 ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13...
Query results operations