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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Settings for the table structure (list of columns).
Table structure
Documentation Whether the table structure actions should be hidden. Restore default value
Documentation Whether column comments should be shown in table structure view Restore default value
Default transformations
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value

x$session

# Name Type Collation Attributes Null Default Comments Extra
1 bigint(20) UNSIGNED No None A unique thread identifier.
2 bigint(20) UNSIGNED Yes NULL The PROCESSLIST.ID value for threads displayed in the INFORMATION_SCHEMA.PROCESSLIST table, or 0 for background threads. Also corresponds with the CONNECTION_ID() return value for the thread.
3 varchar(384) utf8mb3_general_ci Yes NULL
4 varchar(64) utf8mb3_general_ci Yes NULL Thread's default database, or NULL if none exists.
5 varchar(16) utf8mb3_general_ci Yes NULL Type of command executed by the thread. These correspond to the the COM_xxx client/server protocol commands, and the Com_xxx status variables. See Thread Command Values.
6 varchar(64) utf8mb3_general_ci Yes NULL Action, event or state indicating what the thread is doing.
7 bigint(20) Yes NULL Time in seconds the thread has been in its current state.
8 longtext utf8mb3_general_ci Yes NULL Statement being executed by the thread, or NULL if a statement is not being executed. If a statement results in calling other statements, such as for a stored procedure, the innermost statement from the stored procedure is shown here.
9 bigint(20) UNSIGNED Yes NULL
10 decimal(26,2) Yes NULL
11 bigint(20) UNSIGNED Yes NULL Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings.
12 bigint(20) UNSIGNED Yes NULL Number of rows read during the statement's execution.
13 bigint(20) UNSIGNED Yes NULL Number of rows returned.
14 bigint(20) UNSIGNED Yes NULL Number of rows affected the statement affected.
15 bigint(20) UNSIGNED Yes NULL Number of temp tables created by the statement.
16 bigint(20) UNSIGNED Yes NULL Number of on-disk temp tables created by the statement.
17 varchar(3) utf8mb3_general_ci Yes NULL
18 longtext utf8mb3_general_ci Yes NULL
19 bigint(20) UNSIGNED Yes NULL
20 decimal(41,0) Yes NULL
21 varchar(128) utf8mb3_general_ci Yes NULL Event instrument name and a NAME from the setup_instruments table
22 varchar(20) utf8mb3_general_ci Yes NULL
23 varchar(64) utf8mb3_general_ci Yes NULL Name and line number of the source file containing the instrumented code that produced the event.
24 bigint(20) UNSIGNED Yes NULL The unit is picoseconds. Event duration. NULL if event has not timing information.
25 enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') utf8mb3_general_ci Yes NULL The current transaction state. The value is ACTIVE (after START TRANSACTION or BEGIN), COMMITTED (after COMMIT), or ROLLED BACK (after ROLLBACK).
26 enum('YES', 'NO') utf8mb3_general_ci Yes NULL Whether autcommit mode was enabled when the transaction started.
27 varchar(1024) utf8mb3_bin Yes NULL Attribute value.
28 varchar(1024) utf8mb3_bin Yes NULL Attribute value.
With selected: With selected:
Partitions Documentation
Information

Table comments: VIEW

Row statistics
Format
Rows 0
Next autoindex 0
Creation Mar 28, 2026 at 10:52 AM
Last update Mar 28, 2026 at 10:52 AM
Last check Mar 28, 2026 at 10:52 AM