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 `PLUGIN_NAME` , `PLUGIN ... UGINS` WHERE `P... mysql 11 11.19 ms 11 11 1 100 2024-09-26 06:01:07.030653 2024-09-26 06:05:08.253031 da64fef78148590bc22ae2f4a50212e867078d1a1ab3eb530a...
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... sys 3 162.33 ms 9 2 3 22 2024-09-26 06:04:00.367277 2024-09-26 06:04:00.630322 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ... information_schema 2 513.59 ms 2 2 1 100 2024-09-26 06:03:52.350824 2024-09-26 06:04:00.113572 9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c...
SELECT ? FROM `information_sch ... . `INNODB_BUFFE... information_schema 2 24.61 ms 2 2 1 100 2024-09-26 06:03:52.469664 2024-09-26 06:04:00.327428 5367402c4b2a77c0167e6f11480845120ee5d11a0ef54ddc76...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... NULL 487 289.05 ms 3409 0 7 0 2024-09-26 06:01:04.516581 2024-09-26 06:05:10.251511 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL 1195 899.16 ms 2755 0 2 0 2024-09-26 06:01:04.442633 2024-09-26 06:05:10.236241 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema 1040 610.79 ms 2340 0 2 0 2024-09-26 06:01:06.576706 2024-09-26 06:05:09.272616 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... information_schema 2222 2.81 s 2207 0 1 0 2024-09-26 06:01:08.435471 2024-09-26 06:05:07.584013 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... performance_schema 260 148.44 ms 1820 0 7 0 2024-09-26 06:01:06.638751 2024-09-26 06:05:09.286148 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql 854 488.39 ms 1750 0 2 0 2024-09-26 06:01:04.743414 2024-09-26 06:05:09.446900 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... mysql 206 119.52 ms 1442 0 7 0 2024-09-26 06:01:04.787242 2024-09-26 06:05:09.465885 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... information_schema 1410 565.00 ms 1258 0 1 0 2024-09-26 06:01:08.497327 2024-09-26 06:05:09.551950 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... information_schema 154 76.63 ms 1078 0 7 0 2024-09-26 06:01:08.516025 2024-09-26 06:05:09.565019 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `ENGINE` FROM `informat ... . `ENGINES` WHE... information_schema 754 67.26 ms 754 0 1 0 2024-09-26 06:02:35.057918 2024-09-26 06:05:09.525810 7a7ef781f8a87ecaafaca60612366942c66b7cb3d2ea562d5d...
SELECT `TABLESPACE_NAME` FROM  ... S` WHERE `TABLE... information_schema 750 66.87 ms 750 0 1 0 2024-09-26 06:02:35.056383 2024-09-26 06:05:09.525410 1b9f8b5127195ff2666a798e5069445bfb51943ac52a3c6730...
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... information_schema 563 380.00 ms 557 0 1 0 2024-09-26 06:01:08.423196 2024-09-26 06:05:10.260227 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SHOW SESSION VARIABLES LIKE ? performance_schema 520 453.13 ms 520 0 1 0 2024-09-26 06:01:06.335441 2024-09-26 06:05:09.260426 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... performance_schema 520 591.72 ms 520 0 1 0 2024-09-26 06:01:06.348652 2024-09-26 06:05:09.141028 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... fy1 200 121.30 ms 441 0 2 0 2024-09-26 06:03:24.703927 2024-09-26 06:05:02.072271 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... muhammad waqas 172 102.05 ms 378 0 2 0 2024-09-26 06:02:56.926868 2024-09-26 06:05:10.223042 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... fy1 52 26.86 ms 364 0 7 0 2024-09-26 06:03:23.311672 2024-09-26 06:05:02.086531 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... muhammad waqas 48 26.84 ms 336 0 7 0 2024-09-26 06:02:53.001900 2024-09-26 06:05:10.241032 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SHOW SESSION VARIABLES LIKE ? information_schema 297 262.94 ms 297 0 1 0 2024-09-26 06:01:08.419500 2024-09-26 06:05:10.237380 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...
SELECT `PRIVILEGE_TYPE` FROM ` ... ` = ? AND `PRIV... NULL 292 65.18 ms 292 0 1 0 2024-09-26 06:01:04.517259 2024-09-26 06:05:10.254367 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 309 324.97 ms 282 0 1 0 2024-09-26 06:01:06.049763 2024-09-26 06:05:09.392787 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
Query results operations