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

AreaContent
TableOne row per session; the columns are determined by the database
ToolbarRefresh fetches again; Kill terminates the selected session; size: N on the right
FilteringThe 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:

DatabaseMain columns
MySQL / MariaDBID, USER, HOST, DB, App, COMMAND, TIME, STATE, INFO
PostgreSQLid, user, host, port, db, App, command, state, time
OracleSID, SERIAL#, SPID, PROGRAM, EVENT, SQL_TEXT, USERNAME, STATUS
SQL ServerThe 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:

DatabaseActual action
MySQL / MariaDBKILL CONNECTION <ID> (use KILL QUERY to cancel only the current statement)
PostgreSQLpg_terminate_backend(id) (use pg_cancel_backend to cancel only the query)
OracleALTER SYSTEM KILL SESSION '<SID>,<SERIAL#>' IMMEDIATE
SQL ServerKILL <SPID>

The window refreshes automatically after terminating. Kill disconnects the other session outright, so confirm the target row before running it.