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 918 553424497000 918 0 100 7588 50844 8 55 2024-06-16 02:30:49.130162 2024-06-16 02:35:10.008045 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 439 221262633000 439 0 100 3629 24300 8 55 2024-06-16 02:30:49.039439 2024-06-16 02:35:01.987728 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql 268 140186275000 268 0 100 2530 16068 9 60 2024-06-16 02:30:49.230120 2024-06-16 02:35:10.286989 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL 232 119643918000 232 0 100 232 928 1 4 2024-06-16 02:30:49.159603 2024-06-16 02:35:10.021601 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 110 108919639000 110 0 100 110 15070 1 137 2024-06-16 02:30:48.891935 2024-06-16 02:35:01.903109 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 5 88785164000 5 0 100 5 290 1 58 2024-06-16 02:30:57.380230 2024-06-16 02:35:04.873008 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... NULL 441 83315651000 441 0 100 441 76293 1 173 2024-06-16 02:30:49.160059 2024-06-16 02:35:10.022436 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema 110 59441544000 110 0 100 110 440 1 4 2024-06-16 02:30:49.061589 2024-06-16 02:35:02.004163 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql 19 36945560000 19 0 100 5168 5947 272 313 2024-06-16 02:30:49.521848 2024-06-16 02:35:10.260351 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql 70 35118259000 70 0 100 70 280 1 4 2024-06-16 02:30:49.285006 2024-06-16 02:35:10.301032 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... Portfolio_Marcus 40 22662354000 40 0 100 330 2130 8 53 2024-06-16 02:31:30.968505 2024-06-16 02:31:46.664281 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema 64 22168227000 64 0 100 1600 1600 25 25 2024-06-16 02:30:48.881621 2024-06-16 02:35:01.462512 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 64 20633313000 64 0 100 64 0 1 0 2024-06-16 02:30:48.893409 2024-06-16 02:35:01.466412 00e2f0d84fa651f12d7029618430a48906da993321f506b59a...
SELECT `ENGINE` FROM `information_schema` . `ENGIN... information_schema 225 17862837000 225 0 100 225 2025 1 9 2024-06-16 02:31:30.261426 2024-06-16 02:34:40.710839 7a7ef781f8a87ecaafaca60612366942c66b7cb3d2ea562d5d...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... information_schema 35 16662364000 35 0 100 35 140 1 4 2024-06-16 02:31:03.869977 2024-06-16 02:35:06.287320 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys 30 16073955000 30 0 100 262 1808 9 60 2024-06-16 02:30:51.429207 2024-06-16 02:34:45.456761 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
( SELECT `User` , `Host` , `Select_priv` , `Insert... NULL 19 16019531000 19 0 100 76 418 4 22 2024-06-16 02:31:57.791774 2024-06-16 02:34:50.948705 d1a3131f33f7939484023b450706e7c8cd6c56644a0eab0775...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... Stefano 2 14043177000 2 0 100 2 72 1 36 2024-06-16 02:34:55.430586 2024-06-16 02:34:55.435750 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 20 12677926000 20 0 100 194 1290 10 65 2024-06-16 02:30:57.489708 2024-06-16 02:35:04.917223 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 42 12338629000 42 0 100 42 0 1 0 2024-06-16 02:30:52.758963 2024-06-16 02:35:01.903609 696f372cde401cebf246d3df25ec3dc57b0631201839ba3d19...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... vedettfak 1 11969567000 1 0 100 1 37 1 37 2024-06-16 02:31:21.014006 2024-06-16 02:31:21.014006 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `TABLESPACE_NAME` FROM `information_schema`... information_schema 150 11557601000 150 0 100 0 0 0 0 2024-06-16 02:31:30.260323 2024-06-16 02:34:40.710337 1b9f8b5127195ff2666a798e5069445bfb51943ac52a3c6730...
SELECT ? FROM `performance_schema` . `table_lock_w... performance_schema 64 10591670000 64 0 100 64 64 1 1 2024-06-16 02:30:49.080470 2024-06-16 02:35:01.629614 0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593...
SELECT * FROM `address` LIMIT ?, ... sakila 1 10581871000 1 0 100 25 25 25 25 2024-06-16 02:30:57.366384 2024-06-16 02:30:57.366384 51ce3c6b58f77580fcee8cc8ac452385e8c972488ad415d83c...
SELECT * FROM `table_io_waits_summary_by_table` LI... performance_schema 42 10200418000 42 0 100 1050 1050 25 25 2024-06-16 02:30:52.756703 2024-06-16 02:35:01.900904 655b4753a0dac187bc653579603616fcda59e9d63159157fda...
Query results operations