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 961 507556914000 960 0 100 8173 54742 9 57 2024-06-16 00:15:55.540116 2024-06-16 00:20:53.743581 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM `information_schema` . `INNODB_BUFFE... information_schema 6 398568656000 6 0 100 6 6 1 1 2024-06-16 00:16:00.615097 2024-06-16 00:18:59.670561 5367402c4b2a77c0167e6f11480845120ee5d11a0ef54ddc76...
SELECT ? FROM `information_schema` . `INNODB_COLUM... information_schema 2 295719429000 2 0 100 2 2 1 1 2024-06-16 00:19:06.706193 2024-06-16 00:19:06.933592 548c02dda47c1454923b30fc7f703a1ebf478276c85df39cd2...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys 2 282214468000 2 0 100 2 2 1 1 2024-06-16 00:16:50.368819 2024-06-16 00:16:50.516912 ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77...
SELECT `a` . `actor_id` AS `actor_id` , `a` . `fir... NULL 1 278181396000 1 0 100 1 322799 1 322799 2024-06-16 00:17:57.119309 2024-06-16 00:17:57.119309 91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 377 233025296000 377 0 100 3476 23220 9 62 2024-06-16 00:15:58.218356 2024-06-16 00:20:58.943557 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys 371 218840522000 371 0 100 3161 21958 9 59 2024-06-16 00:15:56.052008 2024-06-16 00:20:43.264757 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys 2 132773635000 2 0 100 2 2 1 1 2024-06-16 00:16:50.630966 2024-06-16 00:16:50.758687 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema 243 125604351000 243 0 100 243 972 1 4 2024-06-16 00:15:55.565164 2024-06-16 00:20:53.756124 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL 129 72067542000 129 0 100 129 516 1 4 2024-06-16 00:15:58.242440 2024-06-16 00:20:58.887856 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql 110 63331151000 110 0 100 110 440 1 4 2024-06-16 00:15:55.792537 2024-06-16 00:20:59.635148 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... information_schema 136 61181475000 136 0 100 136 544 1 4 2024-06-16 00:15:55.889639 2024-06-16 00:20:54.666629 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... sys 96 45891042000 96 0 100 96 384 1 4 2024-06-16 00:15:56.084913 2024-06-16 00:20:43.278399 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql 29 42671379000 29 0 100 7888 9077 272 313 2024-06-16 00:15:56.303512 2024-06-16 00:20:54.979549 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 75 38124727000 75 0 100 75 0 1 0 2024-06-16 00:15:58.025437 2024-06-16 00:20:53.607013 00e2f0d84fa651f12d7029618430a48906da993321f506b59a...
SELECT `ENGINE` FROM `information_schema` . `ENGIN... information_schema 400 31136353000 400 0 100 400 3600 1 9 2024-06-16 00:15:58.470782 2024-06-16 00:20:17.303402 7a7ef781f8a87ecaafaca60612366942c66b7cb3d2ea562d5d...
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... NULL 1 29133980000 1 0 100 1 1 1 1 2024-06-16 00:18:09.425443 2024-06-16 00:18:09.425443 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema 62 29061342000 62 0 100 62 0 1 0 2024-06-16 00:15:58.772071 2024-06-16 00:20:46.107000 696f372cde401cebf246d3df25ec3dc57b0631201839ba3d19...
SELECT * FROM `INNODB_TABLES` LIMIT ?, ... (unknow... information_schema 1 28674176000 1 0 100 25 25 25 25 2024-06-16 00:16:49.711953 2024-06-16 00:16:49.711953 930d4e73ee6a8d446ee882bf4faa2cae7171cc914aacebd0d6...
SELECT `TABLESPACE_NAME` FROM `information_schema`... information_schema 375 27516312000 375 0 100 0 0 0 0 2024-06-16 00:15:58.469015 2024-06-16 00:20:17.303039 1b9f8b5127195ff2666a798e5069445bfb51943ac52a3c6730...
SELECT `extract_schema_from_file_name` ( `performa... NULL 1 27188854000 1 0 100 1 1 1 1 2024-06-16 00:17:08.879632 2024-06-16 00:17:08.879632 bd914fd84f93d2b27f3871dfcd403dfa26335a4f26eda232ed...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 7 27134896000 7 0 100 7 410 1 59 2024-06-16 00:16:12.281240 2024-06-16 00:20:55.032889 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema 75 21827257000 75 0 100 1875 1875 25 25 2024-06-16 00:15:58.020307 2024-06-16 00:20:53.603784 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...
SELECT `performance_schema` . `global_status` . `V... sys 2 21687439000 2 0 100 0 568 0 284 2024-06-16 00:17:02.168996 2024-06-16 00:17:02.293844 ad4e921c352449e5386e281964b1a537d67c94f16de631b046...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 37 21143560000 37 0 100 331 2222 9 60 2024-06-16 00:16:12.399685 2024-06-16 00:20:55.147938 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
Query results operations