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 `x$session`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
thd_id conn_id user db command state time current_statement execution_engine statement_latency progress lock_latency cpu_latency rows_examined rows_sent rows_affected tmp_tables tmp_disk_tables full_scan last_statement last_statement_latency current_memory last_wait last_wait_latency source trx_latency trx_state trx_autocommit pid program_name
1906803 1894832 root@localhost sys Query executing 16 SELECT * FROM `x$ps_digest_95th_percentile_by_avg_... PRIMARY 15575006177000 NULL 2000000 0 0 0 0 6 0 YES NULL NULL 2756484 NULL NULL NULL 31769000 COMMITTED YES NULL NULL
1906804 1894833 root@localhost NULL Sleep NULL 16 NULL PRIMARY NULL NULL 3000000 0 206 101 0 0 0 NO SHOW TABLES FROM `sys` 10904386000 17056 NULL NULL NULL 526713000 COMMITTED YES NULL NULL
1906889 1894918 root@localhost sys Query executing 12 SELECT * FROM `host_summary_by_file_io` LIMIT 0, 2... PRIMARY 11441333006000 NULL 2000000 0 0 0 0 2 0 YES NULL NULL 8506276 NULL NULL NULL 32789000 COMMITTED YES NULL NULL
1906890 1894919 root@localhost NULL Sleep NULL 12 NULL PRIMARY NULL NULL 3000000 0 206 101 0 0 0 NO SHOW TABLES FROM `sys` 10856917000 17056 NULL NULL NULL 532126000 COMMITTED YES NULL NULL
1906912 1894941 root@localhost NULL Sleep NULL 11 NULL PRIMARY NULL NULL 3000000 0 206 101 0 0 0 NO SHOW TABLES FROM `sys` 7843646000 17056 NULL NULL NULL 501787000 COMMITTED YES NULL NULL
1906911 1894940 root@localhost sys Query executing 11 SELECT * FROM `x$host_summary` LIMIT 0, 25 PRIMARY 10206328130000 NULL 3000000 0 0 0 0 4 0 YES NULL NULL 4867276 NULL NULL NULL 30774000 COMMITTED YES NULL NULL
760461 749006 root@1-34-41-246.hinet-ip.hinet.net 2025Benvia Sleep NULL 7 NULL PRIMARY NULL NULL 3000000 0 252 0 0 0 0 NO SELECT id, serial, image_url
           FROM vid...
359523000 37820 NULL NULL NULL 224512000 COMMITTED YES NULL NULL
1872234 1860491 root@1-34-41-246.hinet-ip.hinet.net 2025Benvia Sleep NULL 6 NULL PRIMARY NULL NULL 3000000 0 252 0 0 0 0 NO SELECT id, serial, uid, email, vidu, grandma_banan... 390995000 17115 NULL NULL NULL 262439000 COMMITTED YES NULL NULL
760443 748988 root@1-34-41-246.hinet-ip.hinet.net 2025Benvia Sleep NULL 6 NULL PRIMARY NULL NULL 3000000 0 252 0 0 0 0 NO SELECT id, serial, uid, email, vidu, grandma_banan... 414093000 20316 NULL NULL NULL 255502000 COMMITTED YES NULL NULL
760467 749012 root@1-34-41-246.hinet-ip.hinet.net 2025Benvia Sleep NULL 4 NULL PRIMARY NULL NULL 3000000 0 252 0 0 0 0 NO SELECT id, serial, uid, email, grandma_final, para... 356190000 37132 NULL NULL NULL 231972000 COMMITTED YES NULL NULL
1872236 1860493 root@1-34-41-246.hinet-ip.hinet.net 2025Benvia Sleep NULL 3 NULL PRIMARY NULL NULL 2000000 0 252 0 0 0 0 NO SELECT id, serial, image_url
           FROM vid...
312510000 35595 NULL NULL NULL 202466000 COMMITTED YES NULL NULL
1861456 1849757 root@1-34-41-246.hinet-ip.hinet.net 2025Benvia Sleep NULL 3 NULL PRIMARY NULL NULL 3000000 0 252 0 0 0 0 NO SELECT id, serial, uid, email, vidu, parachute_ban... 411677000 18652 NULL NULL NULL 273560000 COMMITTED YES NULL NULL
1872237 1860494 root@1-34-41-246.hinet-ip.hinet.net 2025Benvia Sleep NULL 2 NULL PRIMARY NULL NULL 2000000 0 252 0 0 0 0 NO SELECT id, serial, uid, email, grandma_final, para... 343874000 35595 NULL NULL NULL 218629000 COMMITTED YES NULL NULL
1872235 1860492 root@1-34-41-246.hinet-ip.hinet.net 2025Benvia Sleep NULL 1 NULL PRIMARY NULL NULL 3000000 0 252 0 0 0 0 NO SELECT id, serial, uid, email, vidu, parachute_ban... 419140000 17115 NULL NULL NULL 267011000 COMMITTED YES NULL NULL
1907074 1895103 root@localhost NULL Sleep NULL 1 NULL PRIMARY NULL NULL 3000000 0 206 101 0 0 0 NO SHOW TABLES FROM `sys` 10034955000 17056 NULL NULL NULL 9257498000 COMMITTED YES NULL NULL
1907073 1895102 root@localhost sys Query executing 1 SELECT * FROM `x$host_summary_by_statement_latency... PRIMARY 226952363000 NULL 3000000 0 0 0 0 2 0 YES NULL NULL 2277012 NULL NULL NULL 65333000 COMMITTED YES NULL NULL
1907072 1895101 root@localhost NULL Sleep NULL 1 NULL PRIMARY NULL NULL 3000000 0 206 101 0 0 0 NO SHOW TABLES FROM `sys` 7182230000 17056 NULL NULL NULL 6535311000 COMMITTED YES NULL NULL
1907071 1895100 root@localhost sys Query executing 1 SELECT * FROM `x$session` LIMIT 0, 25 PRIMARY 266222417000 NULL 3000000 0 0 0 0 4 0 YES NULL NULL 9013580 NULL NULL NULL 32604000 COMMITTED YES NULL NULL
1907076 1895105 root@localhost NULL Query checking permissions 0 SHOW TABLES FROM `sys` PRIMARY 22913363000 NULL 3000000 0 0 0 0 0 0 NO NULL NULL NULL NULL NULL NULL 22496727000 ACTIVE YES NULL NULL
1907075 1895104 root@localhost NULL Sleep NULL 0 NULL PRIMARY NULL NULL 0 0 0 0 0 0 0 NO SET lc_messages = 'en_US' 23403000 NULL NULL NULL NULL 7010233000 COMMITTED YES NULL NULL
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view