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` . ... NULL 1071 777329214000 1071 0 100 9719 63415 9 59 2024-06-21 07:46:01.295535 2024-06-21 07:51:07.575636 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 1031 687423884000 1031 0 100 8743 58793 8 57 2024-06-21 07:46:01.190947 2024-06-21 07:51:07.194893 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 259 333862990000 259 0 100 259 35684 1 138 2024-06-21 07:46:01.091810 2024-06-21 07:51:07.029734 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL 331 190042386000 331 0 100 331 1324 1 4 2024-06-21 07:46:01.351073 2024-06-21 07:51:07.591854 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema 259 165118017000 259 0 100 259 1036 1 4 2024-06-21 07:46:01.226524 2024-06-21 07:51:07.213977 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `ENGINE` FROM `information_schema` . `ENGIN... information_schema 1400 137614011000 1400 0 100 1400 12600 1 9 2024-06-21 07:46:02.184819 2024-06-21 07:51:06.132394 7a7ef781f8a87ecaafaca60612366942c66b7cb3d2ea562d5d...
SELECT `TABLESPACE_NAME` FROM `information_schema`... information_schema 1125 108542160000 1125 0 100 0 0 0 0 2024-06-21 07:46:02.173301 2024-06-21 07:50:54.404160 1b9f8b5127195ff2666a798e5069445bfb51943ac52a3c6730...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys 144 102659818000 144 0 100 1211 8500 8 59 2024-06-21 07:46:03.669008 2024-06-21 07:51:00.195489 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... information_schema 148 88928836000 148 0 100 148 592 1 4 2024-06-21 07:46:02.132348 2024-06-21 07:51:06.184589 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql 127 80069151000 127 0 100 127 508 1 4 2024-06-21 07:46:00.925636 2024-06-21 07:51:02.138763 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... NULL 317 76820317000 317 0 100 317 54841 1 173 2024-06-21 07:46:01.351481 2024-06-21 07:51:07.592323 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... sys 291 70348745000 291 0 100 291 50343 1 173 2024-06-21 07:48:52.596396 2024-06-21 07:48:55.186438 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 8 61780393000 8 0 100 8 471 1 59 2024-06-21 07:46:12.204188 2024-06-21 07:50:25.552753 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... BI22110308 119 61558211000 119 0 100 119 476 1 4 2024-06-21 07:47:02.322068 2024-06-21 07:51:04.780805 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 176 61222516000 176 0 100 176 0 1 0 2024-06-21 07:46:01.092343 2024-06-21 07:51:07.030633 00e2f0d84fa651f12d7029618430a48906da993321f506b59a...
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema 176 60071573000 176 0 100 4400 4400 25 25 2024-06-21 07:46:01.086710 2024-06-21 07:51:07.027397 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... BI22110308 268 57719343000 268 0 100 268 46364 1 173 2024-06-21 07:47:02.322435 2024-06-21 07:51:04.781674 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co... NULL 141 40576826000 141 0 100 5781 11562 41 82 2024-06-21 07:46:01.273104 2024-06-21 07:51:07.519068 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql 33 39100321000 33 0 100 8976 10329 272 313 2024-06-21 07:46:10.150107 2024-06-21 07:50:52.688015 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT ? FROM `performance_schema` . `table_lock_w... performance_schema 176 30959924000 176 0 100 176 176 1 1 2024-06-21 07:46:01.347808 2024-06-21 07:51:07.238740 0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593...
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... NULL 44 27717411000 44 0 100 0 3608 0 82 2024-06-21 07:47:07.432286 2024-06-21 07:51:06.703359 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 32 22156574000 32 0 100 331 2101 10 66 2024-06-21 07:46:12.370667 2024-06-21 07:50:25.604902 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 59 20326302000 59 0 100 59 0 1 0 2024-06-21 07:46:03.658751 2024-06-21 07:51:05.141569 696f372cde401cebf246d3df25ec3dc57b0631201839ba3d19...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... sys 36 19955437000 36 0 100 36 144 1 4 2024-06-21 07:46:03.734444 2024-06-21 07:51:00.211109 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... mysql 76 18390855000 76 0 100 76 13148 1 173 2024-06-21 07:46:02.631287 2024-06-21 07:51:02.139794 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
Query results operations