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 IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... NULL 1 461488971000 1 0 100 1 1 1 1 2024-06-15 19:54:25.780309 2024-06-15 19:54:25.780309 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 595 390614132000 595 0 100 5472 35648 9 60 2024-06-15 19:45:49.394710 2024-06-15 19:56:48.944623 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 737 358916951000 736 0 100 6159 41356 8 56 2024-06-15 19:45:48.756224 2024-06-15 19:56:51.596270 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... pw 314 167826554000 314 0 100 2924 18702 9 60 2024-06-15 19:53:58.494782 2024-06-15 19:56:47.757846 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql 352 160658528000 352 0 100 352 1408 1 4 2024-06-15 19:46:07.935275 2024-06-15 19:56:31.629724 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys 270 141117298000 270 0 100 2300 15890 9 59 2024-06-15 19:46:05.334199 2024-06-15 19:49:41.894416 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... NULL 4 114559889000 4 0 100 4 30 1 8 2024-06-15 19:49:23.896727 2024-06-15 19:50:51.455118 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL 203 112068447000 203 0 100 203 812 1 4 2024-06-15 19:45:49.419209 2024-06-15 19:56:48.885359 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema 184 93770354000 184 0 100 184 736 1 4 2024-06-15 19:45:48.777614 2024-06-15 19:56:51.608394 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql 54 83238670000 54 0 100 14688 16902 272 313 2024-06-15 19:46:07.864193 2024-06-15 19:56:29.927653 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 129 67890807000 129 0 100 1203 7881 9 61 2024-06-15 19:45:54.236236 2024-06-15 19:56:33.966480 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... mysql 333 62865383000 333 0 100 333 57609 1 173 2024-06-15 19:46:14.010427 2024-06-15 19:56:31.630181 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... NULL 32 54625928000 32 0 100 36 2840 1 89 2024-06-15 19:45:57.038728 2024-06-15 19:54:21.418806 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... pw 78 35759839000 78 0 100 78 312 1 4 2024-06-15 19:53:58.517531 2024-06-15 19:56:47.770310 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT * FROM `INNODB_INDEXES` LIMIT ?, ... (unkno... information_schema 1 35418726000 1 0 100 25 25 25 25 2024-06-15 19:52:12.986347 2024-06-15 19:52:12.986347 3da1741a0a7f319de2ab6a85698f9d945297a6a0e484b7dca0...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... NULL 172 31376386000 172 0 100 172 29756 1 173 2024-06-15 19:45:49.419596 2024-06-15 19:56:48.958267 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... Stefano 16 31253159000 16 0 100 16 592 1 37 2024-06-15 19:55:12.935636 2024-06-15 19:56:50.585418 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... Stefano 61 30930352000 61 0 100 571 3514 9 58 2024-06-15 19:55:12.983328 2024-06-15 19:56:50.637402 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 101 30441709000 101 0 100 101 0 1 0 2024-06-15 19:45:48.689163 2024-06-15 19:56:51.515438 696f372cde401cebf246d3df25ec3dc57b0631201839ba3d19...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... sys 69 29809151000 69 0 100 69 276 1 4 2024-06-15 19:46:05.358673 2024-06-15 19:49:41.908916 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... information_schema 61 26773899000 61 0 100 61 244 1 4 2024-06-15 19:45:58.113703 2024-06-15 19:56:19.087888 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 82 26544029000 82 0 100 82 0 1 0 2024-06-15 19:46:14.627651 2024-06-15 19:56:30.484597 00e2f0d84fa651f12d7029618430a48906da993321f506b59a...
SELECT `lower` ( `performance_schema` . `global_st... sys 2 25823700000 2 0 100 2 14726 1 7363 2024-06-15 19:49:17.850364 2024-06-15 19:49:17.943286 93cb31408701834f7f5c55f7eb58b1e357dabb7f0220763115...
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema 82 25346379000 82 0 100 2050 2050 25 25 2024-06-15 19:46:14.624239 2024-06-15 19:56:30.481777 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... Table_insertion 47 24518346000 47 0 100 407 2671 9 57 2024-06-15 19:56:09.095219 2024-06-15 19:56:52.705613 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
Query results operations