Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Set default





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 `events_statements_summary_by_digest`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
SCHEMA_NAME DIGEST DIGEST_TEXT COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED SUM_CPU_TIME MAX_CONTROLLED_MEMORY MAX_TOTAL_MEMORY COUNT_SECONDARY FIRST_SEEN LAST_SEEN QUANTILE_95 QUANTILE_99 QUANTILE_999 QUERY_SAMPLE_TEXT QUERY_SAMPLE_SEEN QUERY_SAMPLE_TIMER_WAIT
NULL a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 2501 1988860895300 135492025 795072790 28121160265 0 0 0 0 2501 2501 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17208 50128 0 2025-09-15 09:18:39.320217 2025-09-17 22:12:57.935302 2884031503 5248074602 10000000000 SELECT @@version, @@version_comment 2025-09-17 22:12:54.379928 1368888500
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 2501 667956686430 88558705 267072940 2710119865 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8968 41888 0 2025-09-15 09:18:39.572651 2025-09-17 22:12:57.939215 660693448 870963589 1905460717 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2025-09-17 22:12:54.385032 343898315
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 2501 1362730736670 92469815 544761750 151734026735 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8968 41888 0 2025-09-15 09:18:39.573889 2025-09-17 22:12:57.939483 549540873 9549925860 45708818961 SET lc_messages = 'en_US' 2025-09-17 22:12:54.679622 280482460
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 4980 5087666313370 259250720 1021358440 75810162590 79443000000 4980 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 48024 241509 0 2025-09-15 09:18:40.094015 2025-09-17 22:12:57.980797 3801893963 5495408738 23988329190 SHOW TABLES FROM `phpmyadmin` 2025-09-17 22:12:54.404739 2117866065
NULL 2c24b751963f72784d23be8c48ef2cf31edaa6e9ab5061a690... SHOW TABLES FROM `sys` 1376 7529093200735 2256431105 5471642890 130708737470 38892000000 0 0 0 138976 283456 0 0 0 0 0 0 1376 0 0 138976 1376 0 0 0 1695648 3096835 0 2025-09-15 09:18:40.161916 2025-09-17 20:45:47.229028 14454397707 23988329190 104712854805 SHOW TABLES FROM `sys` 2025-09-17 20:44:57.893310 12911691570
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 2475 833014747475 116495205 336355460 17180668135 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8968 41888 0 2025-09-15 09:18:42.411410 2025-09-17 22:12:57.980188 549540873 831763771 17378008287 SET collation_connection = 'utf8mb4_unicode_ci' 2025-09-17 22:12:56.592353 453409395
NULL cee80b858661a6e35dec1954fbc022aebad05795b5f881fce9... SHOW FULL FIELDS FROM `sys` . `x$io_global_by_wait... 4 39805042660 3658284675 9951260665 25483116570 143000000 0 0 0 56 236 0 4 0 0 0 0 4 0 0 56 4 0 0 0 1486520 1728514 0 2025-09-15 09:18:43.147586 2025-09-17 02:19:58.259257 26302679918 26302679918 26302679918 SHOW FULL COLUMNS FROM `sys`.`x$io_global_by_wait_... 2025-09-17 02:19:58.259257 3658284675
NULL 5836930af07fd3af38966f54d0ac5fadba2559fbaa76d17946... SHOW INDEXES FROM `sys` . `x$io_global_by_wait_by_... 9 26921846320 1930691515 2991161055 8187070690 209000000 0 0 0 0 27 0 9 0 0 0 0 9 0 0 0 9 0 0 0 1453608 2477676 0 2025-09-15 09:18:43.229806 2025-09-17 20:41:38.738699 8317637711 8317637711 8317637711 SHOW INDEXES FROM `sys`.`x$io_global_by_wait_by_la... 2025-09-17 20:41:37.842168 2222627940
NULL 8a4675bb5f23844991a9f25bd418d7919fbf8025fb9e3f0f0e... SELECT @@`character_set_connection` 161 39156357130 140241230 243047550 654552195 0 0 0 0 161 161 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1069912 1315948 0 2025-09-15 09:18:43.230790 2025-09-17 22:08:15.577473 416869383 549540873 660693448 SELECT @@character_set_connection 2025-09-17 22:08:15.577473 268469765
sys a72b965922848d2b5f697f9c499411910581b77921bbc4deaa... SHOW TABLES LIKE ? 348 1191292817120 1928177230 3423059345 9679438520 8998000000 0 0 0 348 36196 0 0 0 0 0 0 348 0 0 348 348 0 0 0 1696288 2286215 0 2025-09-15 09:18:43.288846 2025-09-17 20:37:49.832099 6309573444 7943282347 10000000000 SHOW TABLES LIKE 'x$statements_with_temp_tables' 2025-09-17 20:37:49.832099 3950221100
sys c87ed7947946bf1451fedc1c62d3c1027deabd93f4e28d134a... SHOW FIELDS FROM `sys` . `x$io_global_by_wait_by_l... 15 59005240380 2114234320 3933459200 8252721465 379000000 0 0 0 210 885 0 15 0 0 0 0 15 0 0 210 15 0 0 0 1486520 2498222 0 2025-09-15 09:18:43.660238 2025-09-17 08:51:18.919689 8317637711 8317637711 8317637711 SHOW  COLUMNS FROM `sys`.`x$io_global_by_wait_by_l... 2025-09-17 08:51:18.919689 7075477355
sys 5836930af07fd3af38966f54d0ac5fadba2559fbaa76d17946... SHOW INDEXES FROM `sys` . `x$io_global_by_wait_by_... 31 78893514095 1599085260 2544735785 5793750735 661000000 0 0 0 0 93 0 31 0 0 0 0 31 0 0 0 31 0 0 0 1453608 2462600 0 2025-09-15 09:18:43.663166 2025-09-17 08:51:18.923021 4168693834 6025595860 6025595860 SHOW INDEXES FROM `sys`.`x$io_global_by_wait_by_la... 2025-09-17 08:51:18.923021 2878018230
sys 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 445 125166694600 139123770 281041190 4784963720 0 0 0 0 445 445 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1069912 2483878 0 2025-09-15 09:18:44.005704 2025-09-17 20:45:44.330478 524807460 724435960 4786300923 SELECT CURRENT_USER() 2025-09-17 20:44:48.883475 471009390
sys 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 171 82152586185 197790420 480228435 2387453290 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1061672 2477526 0 2025-09-15 09:18:44.006936 2025-09-17 20:44:48.883988 870963589 2290867652 2398832919 SHOW GRANTS 2025-09-17 20:44:48.883988 382171320
sys e8b67e76bb58f62c704e6904b349719537675fef0a968c067b... SELECT ( COUNT ( `DB_first_level` ) DIV ? ) * ? FR... 646 1711381329685 947047350 2648938930 141022893270 16901000000 0 0 0 646 1938 0 1292 646 0 0 0 1292 0 0 0 0 646 0 0 1484152 2865201 0 2025-09-15 09:18:44.018781 2025-09-17 20:45:47.331817 4570881896 11481536214 144543977074 SELECT (COUNT(DB_first_level) DIV 100) * 100 from ... 2025-09-17 20:44:48.886276 2070932745
sys 61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e... SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `... 646 2237522564340 1760278865 3463567270 19820946750 17885000000 0 0 0 2584 13566 0 1938 1938 0 0 0 1938 0 0 5168 1292 646 0 0 2604080 4023934 0 2025-09-15 09:18:44.909038 2025-09-17 20:45:47.460489 6606934480 7943282347 19952623149 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... 2025-09-17 20:44:58.014189 3812214790
sys 5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33... SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS... 1292 1659133649290 729980745 1283961540 14247615000 31634000000 0 0 0 1292 5168 0 2584 1292 0 0 0 2584 0 0 0 0 1292 0 0 1484152 2873441 0 2025-09-15 09:18:45.192357 2025-09-17 20:45:47.468931 2290867652 3467368504 12022644346 SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I... 2025-09-17 20:44:48.913489 2133789870
sys 2bf37377c7e7540a4a6efcec7238d7f74dc339142b6b2cc7df... SELECT TABLE_NAME FROM `information_schema` . `VIE... 29701 47852559916630 938387035 1611097955 253929375480 686519000000 0 0 0 29692 178179 0 0 0 0 0 0 29701 0 0 0 0 0 0 0 1292560 1809112 0 2025-09-15 09:18:45.886450 2025-09-17 20:42:54.171720 2290867652 3630780547 100000000000 SELECT TABLE_NAME FROM information_schema.VIEWS WH... 2025-09-17 20:42:53.937373 3397078400
sys 04929b6fd631894143682b2b8dba2905f429f484c8d3a6df1c... SELECT TABLE_NAME FROM `information_schema` . `VIE... 794 1387392520140 973028295 1747148710 47393713520 19643000000 0 0 0 322 3348 0 0 0 0 0 0 794 0 0 0 0 0 0 0 1224008 1813616 0 2025-09-15 09:18:45.953470 2025-09-17 20:42:54.174169 3311311214 4786300923 47863009232 SELECT TABLE_NAME FROM information_schema.VIEWS WH... 2025-09-17 20:42:54.174169 2225700955
sys caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 438 270238704180 362336405 616837920 2521269125 10068000000 0 0 0 438 438 0 0 0 0 0 0 438 0 0 0 0 0 0 0 1069912 2501425 0 2025-09-15 09:18:45.954565 2025-09-17 20:45:47.484063 1148153621 1584893192 2630267991 SELECT 1 FROM mysql.user LIMIT 1 2025-09-17 20:45:47.484063 948723540
sys 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... 624 1291380915670 892571175 2069256555 59159729225 14282000000 0 0 0 624 1248 0 4368 0 0 0 0 4992 0 0 0 0 624 0 0 1445000 3650099 0 2025-09-15 09:18:45.958477 2025-09-17 20:45:47.485244 3801893963 15848931924 60255958607 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 2025-09-17 20:44:58.042303 1611377320
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 888 787762646045 245003105 886983875 13518192985 22707000000 0 0 0 888 888 0 0 0 0 0 0 888 0 0 0 0 0 0 0 1079424 2907451 0 2025-09-15 09:40:45.814378 2025-09-17 22:12:58.036274 2398832919 3311311214 13803842646 SELECT 1 FROM mysql.user LIMIT 1 2025-09-17 22:12:55.796957 890336255
mysql 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 158 954835766835 2070094650 6043223680 34313844220 3407000000 0 0 0 158 158 0 158 0 0 0 0 316 0 0 0 0 158 0 0 1136304 1219225 0 2025-09-15 09:40:45.979299 2025-09-17 20:56:15.421750 13182567385 20892961308 34673685045 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2025-09-17 20:56:15.421750 13629659620
mysql 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 441 141533851855 136050755 320711020 895923555 0 0 0 0 441 441 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1069912 1606833 0 2025-09-15 09:40:46.074691 2025-09-17 22:12:57.856576 549540873 724435960 912010839 SELECT CURRENT_USER() 2025-09-17 22:12:54.977092 373790370
mysql 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 239 121049413230 191923755 506209380 4562030450 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1067088 1596549 0 2025-09-15 09:40:46.075502 2025-09-17 22:12:57.669509 954992586 1148153621 4570881896 SHOW GRANTS 2025-09-17 22:12:05.553882 408152265
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view