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 `statements_with_temp_tables`
query db exec_count total_latency memory_tmp_tables disk_tmp_tables avg_tmp_tables_per_query tmp_tables_to_disk_pct first_seen last_seen digest
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ... information_schema 15 1.86 s 15 15 1 100 2024-09-26 06:36:06.215842 2024-09-26 06:38:08.780146 9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c...
SELECT ? FROM `information_sch ... . `INNODB_BUFFE... information_schema 15 275.17 ms 15 15 1 100 2024-09-26 06:36:06.568966 2024-09-26 06:38:08.978167 5367402c4b2a77c0167e6f11480845120ee5d11a0ef54ddc76...
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... sys 9 594.88 ms 27 6 3 22 2024-09-26 06:37:28.478120 2024-09-26 06:37:33.645004 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1...
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... sys 6 369.14 ms 18 4 3 22 2024-09-26 06:36:15.554481 2024-09-26 06:36:43.619025 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... sys 3 74.44 ms 9 2 3 22 2024-09-26 06:37:41.749356 2024-09-26 06:37:41.982537 ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77...
SELECT `PLUGIN_NAME` , `PLUGIN ... UGINS` WHERE `P... mysql 1 1.40 ms 1 1 1 100 2024-09-26 06:37:05.895342 2024-09-26 06:37:05.895342 da64fef78148590bc22ae2f4a50212e867078d1a1ab3eb530a...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema 1507 1.24 s 3391 0 2 0 2024-09-26 06:36:06.425452 2024-09-26 06:38:11.415775 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... information_schema 2755 4.20 s 2729 0 1 0 2024-09-26 06:36:06.752557 2024-09-26 06:38:10.429003 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... performance_schema 377 324.12 ms 2639 0 7 0 2024-09-26 06:36:06.507561 2024-09-26 06:38:11.442544 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... information_schema 2245 1.30 s 2362 0 1 0 2024-09-26 06:36:06.447970 2024-09-26 06:38:10.390831 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql 1093 877.41 ms 2147 0 2 0 2024-09-26 06:36:05.997422 2024-09-26 06:38:11.489881 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... information_schema 284 224.97 ms 1988 0 7 0 2024-09-26 06:36:06.499144 2024-09-26 06:38:10.407841 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `ENGINE` FROM `informat ... . `ENGINES` WHE... information_schema 1925 201.58 ms 1925 0 1 0 2024-09-26 06:36:06.941328 2024-09-26 06:38:09.508620 7a7ef781f8a87ecaafaca60612366942c66b7cb3d2ea562d5d...
SELECT `TABLESPACE_NAME` FROM  ... S` WHERE `TABLE... information_schema 1825 204.27 ms 1825 0 1 0 2024-09-26 06:36:06.938472 2024-09-26 06:38:09.508283 1b9f8b5127195ff2666a798e5069445bfb51943ac52a3c6730...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... mysql 248 213.20 ms 1736 0 7 0 2024-09-26 06:36:06.041496 2024-09-26 06:38:11.507514 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... NULL 207 177.66 ms 1445 0 7 0 2024-09-26 06:36:08.064086 2024-09-26 06:38:09.724849 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... information_schema 1038 848.18 ms 1035 0 1 0 2024-09-26 06:36:06.233588 2024-09-26 06:38:10.329335 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL 360 332.31 ms 843 0 2 0 2024-09-26 06:36:08.015139 2024-09-26 06:38:09.708577 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... performance_schema 750 1.09 s 750 0 1 0 2024-09-26 06:36:06.023472 2024-09-26 06:38:11.347793 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SHOW SESSION VARIABLES LIKE ? performance_schema 747 944.06 ms 747 0 1 0 2024-09-26 06:36:05.997802 2024-09-26 06:38:11.399245 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...
SHOW SESSION VARIABLES LIKE ? information_schema 548 746.46 ms 548 0 1 0 2024-09-26 06:36:05.987671 2024-09-26 06:38:10.377411 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... information_schema 1017 1.00 s 518 0 1 0 2024-09-26 06:36:06.231527 2024-09-26 06:38:10.328458 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... INFS1200_RELEASE 191 173.06 ms 415 0 2 0 2024-09-26 06:36:06.208192 2024-09-26 06:37:04.277011 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 452 557.63 ms 386 0 1 0 2024-09-26 06:36:06.657745 2024-09-26 06:38:11.443452 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... performance_schema 377 515.38 ms 377 0 1 0 2024-09-26 06:36:06.011105 2024-09-26 06:38:11.346535 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
Query results operations