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 `col` . `name` AS `COLL ... er_set_id` = `c... information_schema * 1689 0 0 1.90 s 4.52 ms 1.12 ms 215.42 ms 3004 2 71228 42 0 0 1664 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-24 15:00:57.567995 2024-06-24 15:02:46.065716
SELECT `COMMENT` FROM `informa ... . `ENGINES` WHE... information_schema * 1452 0 0 1.18 s 1.06 s 811.61 us 1.12 s 1452 1 13068 9 0 0 1452 0 0 0 15da2ac5321783445612727df537cde176602ae2b426c30e53... 2024-06-24 15:01:07.294253 2024-06-24 15:02:46.805578
SELECT `cat` . `name` AS `CATA ... database` ( `sc... information_schema * 1848 0 0 730.96 ms 3.57 ms 395.54 us 319.88 ms 8579 5 52694 29 0 0 1754 0 13146 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-24 15:00:57.619649 2024-06-24 15:02:47.139370
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 1135 0 3 673.63 ms 3.65 ms 593.50 us 254.32 ms 10663 9 64445 57 0 0 2200 0 16679 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-24 15:00:56.006208 2024-06-24 15:02:47.210358
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... mysql 281 0 0 610.21 ms 88.85 ms 2.17 ms 108.63 ms 512 2 11397 41 0 0 281 0 512 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-24 15:00:55.927007 2024-06-24 15:02:47.151213
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... information_schema * 784 0 0 607.68 ms 29.71 ms 775.10 us 319.28 ms 11162 14 54657 70 0 0 387 0 8393 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-24 15:00:57.570041 2024-06-24 15:02:47.114114
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 886 0 0 600.26 ms 4.17 ms 677.49 us 222.62 ms 8234 9 54189 61 0 0 2020 0 15192 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-24 15:00:55.819592 2024-06-24 15:02:46.691009
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sys 1870 0 0 559.64 ms 6.81 ms 299.27 us 306.05 ms 1864 1 11202 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-24 15:01:05.769714 2024-06-24 15:02:36.084090
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... information_schema * 787 0 0 543.88 ms 31.16 ms 691.09 us 326.86 ms 26 0 3446 4 0 0 784 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-24 15:00:57.570741 2024-06-24 15:02:47.113036
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL * 455 0 0 543.83 ms 14.48 ms 1.20 ms 250.40 ms 15150 33 104053 229 0 0 151 0 15130 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-24 15:00:55.850424 2024-06-24 15:02:47.089926
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema * 783 0 0 478.73 ms 3.37 ms 611.40 us 174.42 ms 6648 8 44754 57 0 0 1762 0 12122 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-24 15:00:57.218569 2024-06-24 15:02:46.621482
ALTER TABLE `Vehicles` ADD PRI ... alPointID` ( `R... klo 1 0 0 467.86 ms 467.86 ms 467.86 ms 65.00 us 0 0 0 0 0 0 0 0 0 0 e03a550556b34857110ec0c7d50cce33c342f62eae71c0ee12... 2024-06-24 15:02:32.519409 2024-06-24 15:02:32.519409
ALTER TABLE `Parks` ADD PRIMARY KEY ( `ParkID` ) klo 1 0 0 462.54 ms 462.54 ms 462.54 ms 586.00 us 0 0 0 0 0 0 0 0 0 0 cdad32ee652719aa0fd50385be95a40a96d5299a582570d440... 2024-06-24 15:02:31.143148 2024-06-24 15:02:31.143148
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 466 0 0 455.31 ms 3.65 ms 977.06 us 186.00 ms 14961 32 76840 165 0 0 386 0 14597 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-24 15:00:55.899909 2024-06-24 15:02:47.152884
ALTER TABLE `Rentals` ADD PRIM ... EY `VehicleID` ... klo 1 0 0 454.98 ms 454.98 ms 454.98 ms 123.00 us 0 0 0 0 0 0 0 0 0 0 eb90c809beeecea410ca28869043ac88ca45bd81f8ee1fb7c8... 2024-06-24 15:02:32.043537 2024-06-24 15:02:32.043537
ALTER TABLE `RentalPoints` MOD ... INCREMENT , AUT... klo 1 0 1 454.91 ms 454.91 ms 454.91 ms 88.00 us 0 0 0 0 5 5 0 0 0 0 39b56f03fe5456be5d530a386cd95bcd1a0115907225290ef3... 2024-06-24 15:02:33.330577 2024-06-24 15:02:33.330577
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... performance_schema 388 0 0 450.98 ms 5.97 ms 1.16 ms 156.02 ms 20380 53 103050 266 0 0 387 0 20373 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-24 15:00:57.152170 2024-06-24 15:02:46.476721
ALTER TABLE `RentalPoints` ADD ...  ADD KEY `ParkI... klo 1 0 0 433.87 ms 433.87 ms 433.87 ms 99.00 us 0 0 0 0 0 0 0 0 0 0 3f8bab3b8c2f960fe706493993d86593ca6c7a5bb9c43a4cd8... 2024-06-24 15:02:31.582479 2024-06-24 15:02:31.582479
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql * 209 0 0 433.62 ms 34.94 ms 2.07 ms 98.92 ms 401 2 85137 407 0 0 203 0 401 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-24 15:00:55.950189 2024-06-24 15:02:47.230745
ALTER TABLE `Rentals` MODIFY ` ... INCREMENT , AUT... klo 1 0 1 430.35 ms 430.35 ms 430.35 ms 95.00 us 0 0 0 0 5 5 0 0 0 0 fa096e2d18c8dd33ed4b7bff3d9230124832394ef452267df3... 2024-06-24 15:02:33.766161 2024-06-24 15:02:33.766161
ALTER TABLE `Vehicles` MODIFY  ... INCREMENT , AUT... klo 1 0 1 390.06 ms 390.06 ms 390.06 ms 265.00 us 0 0 0 0 5 5 0 0 0 0 2c7f8dd40d320b27fd03e5feefdb4d311a88ed00523aa06d46... 2024-06-24 15:02:34.172569 2024-06-24 15:02:34.172569
SHOW SESSION VARIABLES LIKE ? information_schema * 402 0 0 354.41 ms 2.92 ms 881.62 us 35.18 ms 402 1 230748 574 0 0 402 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-24 15:00:57.564583 2024-06-24 15:02:46.820677
SELECT `cat` . `name` AS `TABL ...  , ( `tbl` . `h... information_schema * 38 0 0 352.56 ms 36.42 ms 9.28 ms 13.06 ms 290 8 13897 366 0 0 1 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-24 15:01:14.639034 2024-06-24 15:02:47.172345
ALTER TABLE `Parks` MODIFY `Pa ... INCREMENT , AUT... klo 1 0 1 345.38 ms 345.38 ms 345.38 ms 846.00 us 0 0 0 0 5 5 0 0 0 0 2366b7d21cf14746c5a2678003488c0ac58664b84fcb6653e8... 2024-06-24 15:02:32.869633 2024-06-24 15:02:32.869633
SHOW SESSION VARIABLES LIKE ? performance_schema * 376 0 0 323.60 ms 2.80 ms 860.65 us 33.64 ms 376 1 215824 574 0 0 376 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-24 15:00:57.145731 2024-06-24 15:02:46.600656
Query results operations