Inspect live database connections from the CLI
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.