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 196 134425517000 196 0 100 1747 11636 9 59 2024-06-20 13:30:48.884794 2024-06-20 13:31:43.364220 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 192 101227601000 192 0 100 1618 10880 8 57 2024-06-20 13:30:48.754470 2024-06-20 13:31:41.135492 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 14 74789033000 14 0 100 14 1425 1 102 2024-06-20 13:30:48.492136 2024-06-20 13:31:41.956843 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 49 58323759000 49 0 100 49 6746 1 138 2024-06-20 13:30:48.629631 2024-06-20 13:31:44.435255 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 3 38279949000 3 0 100 3 177 1 59 2024-06-20 13:30:58.517400 2024-06-20 13:31:22.529353 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL 57 28592631000 57 0 100 57 228 1 4 2024-06-20 13:30:48.938248 2024-06-20 13:31:43.377225 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema 48 24903363000 48 0 100 48 192 1 4 2024-06-20 13:30:48.776119 2024-06-20 13:31:41.147521 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql 14 19328969000 14 0 100 3808 4382 272 313 2024-06-20 13:30:49.269404 2024-06-20 13:31:44.004923 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema 36 19294594000 36 0 100 900 900 25 25 2024-06-20 13:30:48.627093 2024-06-20 13:31:44.432182 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... NULL 91 17052523000 91 0 100 91 15743 1 173 2024-06-20 13:30:48.938783 2024-06-20 13:31:43.378127 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql 28 14027919000 28 0 100 28 112 1 4 2024-06-20 13:30:48.601567 2024-06-20 13:31:44.043897 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... NULL 6 12793672000 6 0 100 0 492 0 82 2024-06-20 13:30:56.559839 2024-06-20 13:31:34.510463 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... vedettfak 1 12293846000 1 0 100 1 38 1 38 2024-06-20 13:31:17.602708 2024-06-20 13:31:17.602708 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... Portfolio_Marcus 20 10622268000 20 0 100 168 1086 8 54 2024-06-20 13:30:54.003679 2024-06-20 13:30:57.735641 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... carrental 22 10170798000 22 0 100 22 88 1 4 2024-06-20 13:30:56.094077 2024-06-20 13:31:43.580917 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... carrental 49 9860606000 49 0 100 49 8477 1 173 2024-06-20 13:30:56.094426 2024-06-20 13:31:43.581715 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT * FROM `film` LIMIT ?, ... sakila 1 9273287000 1 0 100 25 25 25 25 2024-06-20 13:30:58.503517 2024-06-20 13:30:58.503517 bc7c7ea1ea0ee83136859c20a5bac2bb70630a0a8e5c8313da...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 36 8954104000 36 0 100 36 0 1 0 2024-06-20 13:30:48.630113 2024-06-20 13:31:44.435939 00e2f0d84fa651f12d7029618430a48906da993321f506b59a...
SELECT * FROM `INNODB_BUFFER_PAGE_LRU` LIMIT ?, ..... information_schema 1 7365395000 1 0 100 25 25 25 25 2024-06-20 13:31:23.978658 2024-06-20 13:31:23.978658 d84467896fc5af45b7a76364037e59e22e87b89b1912308334...
SELECT * FROM `INNODB_METRICS` LIMIT ?, ... information_schema 2 6206874000 2 0 100 50 50 25 25 2024-06-20 13:31:05.285911 2024-06-20 13:31:10.301810 43ad4a52f080cd0cc6fa4c2a41e808d41d0c084be1c77179b6...
SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co... mysql 14 6019939000 14 0 100 574 1148 41 82 2024-06-20 13:30:49.267915 2024-06-20 13:31:44.003745 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 11 5957567000 11 0 100 101 680 9 62 2024-06-20 13:30:58.653847 2024-06-20 13:31:22.604099 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT * FROM `country` LIMIT ?, ... sakila 1 5855305000 1 0 100 25 25 25 25 2024-06-20 13:31:22.513568 2024-06-20 13:31:22.513568 d7530f91b1e370283b7520ecf25b5bf015e9f9fef6b4d88d0a...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys 12 5682141000 12 0 100 102 717 9 60 2024-06-20 13:31:31.737788 2024-06-20 13:31:40.618030 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `ENGINE` FROM `information_schema` . `ENGIN... information_schema 75 5613499000 75 0 100 75 675 1 9 2024-06-20 13:30:49.541069 2024-06-20 13:31:12.179260 7a7ef781f8a87ecaafaca60612366942c66b7cb3d2ea562d5d...
Query results operations