You can now view and manage live connections directly from the pscale CLI, for both Postgres and Vitess branches. Run pscale branch connections top <database> <branch> for a live, sorted view of every active session: what each one is running and how long it has been going.
Because Connections runs over a reserved administrative connection, it keeps working even when the database has exhausted its normal connections.
From there you can:
- Watch sessions update in real time and act on them: cancel a running query or terminate a connection without dropping into a SQL shell.
- On Postgres, see which connections are blocking others and drill into a blocker tree to find the root blocker, including idle-in-transaction sessions.
- Pause and step back through recent history, or capture a session to a file for a postmortem.