Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: information_schema »View: PROCESSLIST
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0245 seconds.)
SELECT * FROM `PROCESSLIST`
ID USER HOST DB COMMAND TIME STATE INFO TIME_MS STAGE MAX_STAGE PROGRESS MEMORY_USED EXAMINED_ROWS QUERY_ID INFO_BINARY TID
2536264 root localhost NULLSleep 0 NULL28.399 0 0 0.000 60328 0 63898910 NULL2860942
2536263 pma localhost NULLSleep 0 NULL96.827 0 0 0.000 60872 0 0 NULL2860941
2536262 root localhost test Query 0 Writing to net
SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I...
9.494 0 0 0.000 75624 18 63898922 [BLOB - 138 B]2860940
2536261 pma localhost NULLSleep 0 NULL30.518 0 0 0.000 59272 0 63898906 NULL2860939
2536260 root localhost mysql Sleep 0 NULL5.590 0 0 0.000 59272 0 63898921 NULL2860938
2536259 root localhost information_schema Query 0 Filling schema table
SELECT * FROM `PROCESSLIST` LIMIT 0, 25
0.288 0 0 0.000 76384 0 63898924 [BLOB - 39 B]2860937
2536258 pma localhost NULLSleep 0 NULL72.070 0 0 0.000 59272 0 63898888 NULL2860936
2536257 pma localhost NULLSleep 0 NULL58.253 0 0 0.000 59272 0 63898897 NULL2860935
2536256 root localhost performance_schema Sleep 0 NULL13.930 0 0 0.000 59272 0 63898918 NULL2860934
2536255 pma localhost NULLSleep 0 NULL75.192 0 0 0.000 59272 0 63898886 NULL2860933
2536254 root localhost mysql Sleep 0 NULL11.286 0 0 0.000 59272 0 63898920 NULL2860932
2536253 pma localhost NULLSleep 0 NULL13.459 0 0 0.000 59272 0 63898919 NULL2860931
2536252 root localhost phpmyadmin Sleep 0 NULL5.668 0 0 0.000 59272 0 63898923 NULL2860930
2536251 pma localhost NULLSleep 0 NULL15.269 0 0 0.000 59272 0 63898917 NULL2860929