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 `statement_analysis`
query db full_scan exec_count err_count warn_count total_latency max_latency avg_latency lock_latency rows_sent rows_sent_avg rows_examined rows_examined_avg rows_affected rows_affected_avg tmp_tables tmp_disk_tables rows_sorted sort_merge_passes digest first_seen last_seen
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sys 13232 0 0 3.56 s 2.20 ms 268.94 us 1.92 s 13215 1 79341 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-26 01:31:36.428411 2024-06-26 01:33:48.350685
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... information_schema * 2959 0 0 3.30 s 7.79 ms 1.12 ms 364.13 ms 3672 1 123720 42 0 0 2928 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-26 01:31:03.146501 2024-06-26 01:33:46.757539
SELECT `cat` . `name` AS `TABL ...  , ( `tbl` . `h... information_schema * 33 0 0 2.83 s 360.82 ms 85.80 ms 11.80 ms 286 9 9676 293 0 0 0 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-26 01:31:30.442591 2024-06-26 01:33:23.129413
SELECT `a` . `actor_id` AS `ac ... irst_name` , `a... sakila * 7 0 0 1.18 s 316.99 ms 168.69 ms 1.21 ms 4 1 1291196 184457 0 0 12 0 800 0 91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6... 2024-06-26 01:31:04.722537 2024-06-26 01:33:16.776518
SELECT `cat` . `name` AS `CATA ... database` ( `sc... information_schema * 2308 0 0 815.34 ms 2.94 ms 353.27 us 361.90 ms 9570 4 58847 25 0 0 1889 0 14522 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 01:31:03.235591 2024-06-26 01:33:48.425202
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... mysql 364 0 0 717.92 ms 76.57 ms 1.97 ms 131.76 ms 703 2 16925 46 0 0 364 0 703 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-26 01:31:02.440278 2024-06-26 01:33:48.495124
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema * 1254 0 0 707.48 ms 2.81 ms 564.18 us 257.11 ms 10848 9 72892 58 0 0 2822 0 19816 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 01:31:02.898266 2024-06-26 01:33:48.088005
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... performance_schema 626 0 0 689.68 ms 6.33 ms 1.10 ms 239.58 ms 35524 57 179484 287 0 0 625 0 35517 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-26 01:31:02.758999 2024-06-26 01:33:48.039609
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 1276 0 1 681.97 ms 2.40 ms 534.46 us 252.86 ms 11213 9 70867 56 0 0 2563 0 18730 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 01:31:02.517913 2024-06-26 01:33:48.565953
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 638 0 0 613.60 ms 8.53 ms 961.75 us 242.33 ms 22920 36 117063 183 0 0 551 0 22510 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-26 01:31:02.364888 2024-06-26 01:33:48.507488
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... information_schema 831 0 0 587.20 ms 3.98 ms 706.62 us 299.56 ms 11541 14 55488 67 0 0 427 0 8719 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-26 01:31:03.130508 2024-06-26 01:33:48.398444
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... information_schema * 857 0 0 568.34 ms 32.79 ms 663.18 us 311.87 ms 78 0 5826 7 0 0 848 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-26 01:31:03.131667 2024-06-26 01:33:48.399112
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL * 425 0 0 545.49 ms 17.00 ms 1.28 ms 269.09 ms 18181 43 55403 130 0 0 72 0 18181 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 01:31:02.339929 2024-06-26 01:33:48.377655
SHOW SESSION VARIABLES LIKE ? performance_schema * 614 0 0 530.31 ms 5.10 ms 863.69 us 53.37 ms 614 1 352436 574 0 0 614 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-26 01:31:02.748209 2024-06-26 01:33:48.076727
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql * 279 0 0 412.31 ms 21.91 ms 1.48 ms 118.17 ms 375 1 28915 104 0 0 276 0 375 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 01:31:02.463224 2024-06-26 01:33:48.506193
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 581 0 0 408.81 ms 6.83 ms 703.64 us 145.30 ms 5596 10 35683 61 0 0 1331 0 10368 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 01:31:02.267319 2024-06-26 01:33:48.348438
SHOW SESSION VARIABLES LIKE ? information_schema * 446 0 0 377.08 ms 2.97 ms 845.47 us 37.96 ms 446 1 256004 574 0 0 446 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-26 01:31:03.126910 2024-06-26 01:33:48.414842
SELECT `cs` . `name` AS `CHARA ... ation_id` = `co... information_schema * 2263 0 0 343.14 ms 1.12 ms 151.63 us 205.83 ms 2999 1 3831 2 0 0 0 0 0 0 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78... 2024-06-26 01:31:03.128360 2024-06-26 01:33:46.755068
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... mysql 981 0 0 343.00 ms 1.69 ms 349.64 us 191.00 ms 0 0 2943 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-26 01:31:02.363078 2024-06-26 01:33:48.505113
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... performance_schema * 316 0 0 324.33 ms 4.58 ms 1.03 ms 147.90 ms 316 1 43781 139 0 0 316 0 316 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 01:31:02.755769 2024-06-26 01:33:48.038380
SHOW SESSION VARIABLES LIKE ? mysql * 363 0 0 318.15 ms 3.82 ms 876.44 us 31.38 ms 363 1 208362 574 0 0 363 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-26 01:31:02.360140 2024-06-26 01:33:48.554282
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 61 0 0 297.70 ms 55.68 ms 4.88 ms 24.50 ms 96 2 1217 20 0 0 61 0 96 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-26 01:31:04.649298 2024-06-26 01:33:45.542366
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... performance_schema 741 0 0 277.03 ms 3.00 ms 373.86 us 153.59 ms 0 0 2223 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-26 01:31:02.753718 2024-06-26 01:33:48.037239
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila * 27 0 0 274.53 ms 207.05 ms 10.17 ms 14.32 ms 159 6 1827 68 0 0 23 0 159 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 01:31:04.664707 2024-06-26 01:33:45.572921
SELECT `t` . `THREAD_ID` AS `t ... T_NUMBER_OF_BYT... sys * 9 0 0 270.58 ms 65.42 ms 30.06 ms 2.59 ms 78 9 78 9 0 0 24 0 560 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-26 01:31:42.726453 2024-06-26 01:32:43.983597
Query results operations