Process List
See the sessions connected to your server, find slow or blocking queries, and cancel or kill them.
The Process List shows every session connected to the server and what it is running. Use it to find long-running queries, idle transactions holding locks, or sessions you need to stop.
Open the Process List
Choose View ▸ Process List (⌥⌘P). It opens in its own window, titled Processes — <connection>, and remembers its size and position per connection.
The Process List uses its own database session. That means it keeps working — and can kill the culprit — even when a query is blocking your main window.
Supported engines
| Engine | Source | Privileges needed |
|---|---|---|
| PostgreSQL 10+ (including Neon and Supabase) | pg_stat_activity, client backends only | — |
| MySQL / MariaDB | information_schema.PROCESSLIST | PROCESS to see other users' sessions |
| SQL Server | sys.dm_exec_sessions | VIEW SERVER STATE |
The Process List isn't available for SQLite, CockroachDB or Redshift.
Controls
| Control | Description |
|---|---|
| Filter sessions | Narrow the list by typing. |
| Hide idle | Hide idle and sleep sessions. Sessions that are idle in a transaction are never hidden. |
| Auto refresh | On by default; refreshes every 2 seconds. |
| Refresh | Reload now (⌘R). |
| Cancel Query | Stop the running statement; the session stays connected. |
| Kill Session | Disconnect the session and roll back its open transaction. |
The footer shows "N of M sessions" and the connection's safe mode.
Columns
| Column | Description |
|---|---|
| PID | The session or process id. |
| User | The database user. |
| Database | The database in use. |
| Client | The client host. |
| Application | The application name, when the client sets one. |
| State | The session state. Active sessions are green; idle in transaction is amber. |
| Time | Elapsed time. |
| Query | The current or last statement. |
Actions
Select a session and use the buttons, or right-click it:
- Cancel Query — stop the statement but keep the session.
- Kill Session — end the session.
- Copy Query — copy its SQL.
On SQL Server, Cancel Query is disabled and Kill Session runs KILL <id>.
Safety
- Killing a session always asks for confirmation, even when safe mode is Silent.
- Killing is blocked on Read only connections.
- You can't kill the Process List's own session.
- Kills are recorded in the connection's history.