CLI inspects live database connections

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.

Read more: Postgres or Vitess.