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` 3426 2448520244080 135492025 714615670 28121160265 0 0 0 0 3426 3426 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 23:59:49.580146 2630267991 5248074602 10000000000 SELECT @@version, @@version_comment 2025-09-17 23:59:43.368507 1685129680
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 3426 875957059085 88558705 255618975 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 23:59:49.585271 630957344 831763771 1905460717 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2025-09-17 23:59:43.385011 784456920
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 3426 1664734079445 92469815 485815735 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 23:59:49.585650 524807460 9549925860 43651583224 SET lc_messages = 'en_US' 2025-09-17 23:59:43.386081 513193505
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 6832 6517563659530 259250720 953752110 75810162590 104990000000 6832 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 23:59:49.636051 3311311214 5248074602 19952623149 SHOW TABLES FROM `phpmyadmin` 2025-09-17 23:59:43.429018 3583414855
NULL 2c24b751963f72784d23be8c48ef2cf31edaa6e9ab5061a690... SHOW TABLES FROM `sys` 1392 7643241460370 2256431105 5490639710 130708737470 39683000000 0 0 0 140592 286752 0 0 0 0 0 0 1392 0 0 140592 1392 0 0 0 1695648 3117187 0 2025-09-15 09:18:40.161916 2025-09-17 23:59:48.555800 14454397707 23988329190 104712854805 SHOW TABLES FROM `sys` 2025-09-17 23:59:48.555800 9356492580
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 3400 1116962730300 116495205 328253875 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 23:59:49.634900 549540873 794328234 15848931924 SET collation_connection = 'utf8mb4_unicode_ci' 2025-09-17 23:59:43.496214 506488745
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_... 10 29043623495 1930691515 2904278540 8187070690 227000000 0 0 0 0 30 0 10 0 0 0 0 10 0 0 0 10 0 0 0 1453608 2477676 0 2025-09-15 09:18:43.229806 2025-09-17 23:59:48.187312 8317637711 8317637711 8317637711 SHOW INDEXES FROM `sys`.`x$io_global_by_wait_by_la... 2025-09-17 23:59:48.187312 2121777175
NULL 8a4675bb5f23844991a9f25bd418d7919fbf8025fb9e3f0f0e... SELECT @@`character_set_connection` 245 59606992590 140241230 243047550 654552195 0 0 0 0 245 245 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 23:59:48.762306 416869383 524807460 660693448 SELECT @@character_set_connection 2025-09-17 23:59:48.762306 279085635
sys a72b965922848d2b5f697f9c499411910581b77921bbc4deaa... SHOW TABLES LIKE ? 350 1203703607245 1928177230 3438983150 9679438520 9096000000 0 0 0 350 36404 0 0 0 0 0 0 350 0 0 350 350 0 0 0 1696288 2286215 0 2025-09-15 09:18:43.288846 2025-09-17 23:23:23.034194 6309573444 7943282347 10000000000 SHOW TABLES LIKE 'x$innodb_lock_waits' 2025-09-17 23:23:23.034194 5879236425
sys c87ed7947946bf1451fedc1c62d3c1027deabd93f4e28d134a... SHOW FIELDS FROM `sys` . `x$io_global_by_wait_by_l... 16 64565441975 2114234320 4035148060 8252721465 408000000 0 0 0 224 944 0 16 0 0 0 0 16 0 0 224 16 0 0 0 1486520 2498222 0 2025-09-15 09:18:43.660238 2025-09-17 22:34:41.208509 8317637711 8317637711 8317637711 SHOW  COLUMNS FROM `sys`.`x$io_global_by_wait_by_l... 2025-09-17 22:34:41.208509 5560201595
sys 5836930af07fd3af38966f54d0ac5fadba2559fbaa76d17946... SHOW INDEXES FROM `sys` . `x$io_global_by_wait_by_... 32 81171176940 1599085260 2536354835 5793750735 679000000 0 0 0 0 96 0 32 0 0 0 0 32 0 0 0 32 0 0 0 1453608 2462600 0 2025-09-15 09:18:43.663166 2025-09-17 22:34:41.210858 4168693834 6025595860 6025595860 SHOW INDEXES FROM `sys`.`x$io_global_by_wait_by_la... 2025-09-17 22:34:41.210858 2277662845
sys 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 450 127153259115 139123770 282438015 4784963720 0 0 0 0 450 450 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 23:23:23.103373 524807460 724435960 4786300923 SELECT CURRENT_USER() 2025-09-17 23:23:23.103373 469053835
sys 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 173 83232890640 197790420 481066530 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 23:23:23.104252 870963589 2290867652 2398832919 SHOW GRANTS 2025-09-17 23:23:23.104252 559568095
sys e8b67e76bb58f62c704e6904b349719537675fef0a968c067b... SELECT ( COUNT ( `DB_first_level` ) DIV ? ) * ? FR... 651 1726855915765 947047350 2652570675 141022893270 17038000000 0 0 0 651 1953 0 1302 651 0 0 0 1302 0 0 0 0 651 0 0 1484152 2865201 0 2025-09-15 09:18:44.018781 2025-09-17 23:23:23.108655 4570881896 11481536214 144543977074 SELECT (COUNT(DB_first_level) DIV 100) * 100 from ... 2025-09-17 23:23:23.108655 4106665500
sys 61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e... SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `... 651 2257263612700 1760278865 3467199015 19820946750 18028000000 0 0 0 2604 13671 0 1953 1953 0 0 0 1953 0 0 5208 1302 651 0 0 2604080 4023934 0 2025-09-15 09:18:44.909038 2025-09-17 23:23:23.129993 6606934480 7943282347 19952623149 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... 2025-09-17 23:23:23.129993 3662754515
sys 5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33... SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS... 1302 1675050749530 729980745 1286475825 14247615000 31999000000 0 0 0 1302 5208 0 2604 1302 0 0 0 2604 0 0 0 0 1302 0 0 1484152 2873441 0 2025-09-15 09:18:45.192357 2025-09-17 23:23:23.147654 2290867652 3467368504 12022644346 SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I... 2025-09-17 23:23:23.140928 1827605830
sys 2bf37377c7e7540a4a6efcec7238d7f74dc339142b6b2cc7df... SELECT TABLE_NAME FROM `information_schema` . `VIE... 29705 47864287100600 938387035 1611097955 253929375480 686658000000 0 0 0 29696 178203 0 0 0 0 0 0 29705 0 0 0 0 0 0 0 1292560 1809112 0 2025-09-15 09:18:45.886450 2025-09-17 23:23:23.182523 2290867652 3630780547 100000000000 SELECT TABLE_NAME FROM information_schema.VIEWS WH... 2025-09-17 23:23:23.176772 3673091020
sys 04929b6fd631894143682b2b8dba2905f429f484c8d3a6df1c... SELECT TABLE_NAME FROM `information_schema` . `VIE... 796 1392034728345 973028295 1748545535 47393713520 19697000000 0 0 0 322 3354 0 0 0 0 0 0 796 0 0 0 0 0 0 0 1224008 1813616 0 2025-09-15 09:18:45.953470 2025-09-17 23:23:23.185208 3311311214 4786300923 47863009232 SELECT TABLE_NAME FROM information_schema.VIEWS WH... 2025-09-17 23:23:23.185208 2472659615
sys caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 443 274496226780 362336405 619352205 2521269125 10199000000 0 0 0 443 443 0 0 0 0 0 0 443 0 0 0 0 0 0 0 1069912 2501425 0 2025-09-15 09:18:45.954565 2025-09-17 23:23:23.186611 1148153621 1584893192 2630267991 SELECT 1 FROM mysql.user LIMIT 1 2025-09-17 23:23:23.186611 1086729850
sys 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... 629 1301750106375 892571175 2069535920 59159729225 14451000000 0 0 0 629 1258 0 4403 0 0 0 0 5032 0 0 0 0 629 0 0 1445000 3650099 0 2025-09-15 09:18:45.958477 2025-09-17 23:23:23.190014 3801893963 15848931924 60255958607 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 2025-09-17 23:23:23.190014 3063237225
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 1278 1061733666625 245003105 830552145 13518192985 31581000000 0 0 0 1278 1278 0 0 0 0 0 0 1278 0 0 0 0 0 0 0 1079424 2907451 0 2025-09-15 09:40:45.814378 2025-09-17 23:59:49.700534 1995262314 3311311214 7585775750 SELECT 1 FROM mysql.user LIMIT 1 2025-09-17 23:59:49.700534 950120365
mysql 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 316 1660372633065 2023720060 5254296920 34313844220 5760000000 0 0 0 316 316 0 316 0 0 0 0 632 0 0 0 0 316 0 0 1136304 1223436 0 2025-09-15 09:40:45.979299 2025-09-17 23:59:45.687975 11481536214 19952623149 34673685045 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2025-09-17 23:59:45.687975 6020315750
mysql 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 705 213678186915 136050755 302831660 1539580515 0 0 0 0 705 705 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 23:59:45.701814 524807460 691830970 1584893192 SELECT CURRENT_USER() 2025-09-17 23:59:45.701814 261765005
mysql 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 368 176594159355 191923755 479669705 8932975240 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 23:57:04.450158 870963589 1318256738 9120108393 SHOW GRANTS 2025-09-17 23:57:04.450158 262323735
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view