Process List
Tools → Process List… opens a separate window listing the sessions/processes on the current database, where you can select one and terminate it.
Open
- Menu bar Tools → Process List…
- The window title is
Process List, and it connects to the database of the current tab.
Panel layout
| Area | Content |
|---|---|
| Table | One row per session; the columns are determined by the database |
| Toolbar | Refresh fetches again; Kill terminates the selected session; size: N on the right |
| Filtering | The table supports column filters, so you can filter by user, state, and so on |
The columns differ because each database queries its own system views:
| Database | Main columns |
|---|---|
| MySQL / MariaDB | ID, USER, HOST, DB, App, COMMAND, TIME, STATE, INFO |
| PostgreSQL | id, user, host, port, db, App, command, state, time |
| Oracle | SID, SERIAL#, SPID, PROGRAM, EVENT, SQL_TEXT, USERNAME, STATUS |
| SQL Server | The output of sp_who2 (SPID and others) |
SQLite has no process list; opening the window shows No data found.
Kill a session
Once you select a row, Kill in the toolbar becomes available. The operation it runs differs by database:
| Database | Actual action |
|---|---|
| MySQL / MariaDB | KILL CONNECTION <ID> (use KILL QUERY to cancel only the current statement) |
| PostgreSQL | pg_terminate_backend(id) (use pg_cancel_backend to cancel only the query) |
| Oracle | ALTER SYSTEM KILL SESSION '<SID>,<SERIAL#>' IMMEDIATE |
| SQL Server | KILL <SPID> |
The window refreshes automatically after terminating. Kill disconnects the other session outright, so confirm the target row before running it.