Kill a stuck Postgres transaction
connect & shell
// what it does
Terminates a single Postgres transaction by ID — the surgical fix for the classic "idle in transaction" session holding locks and blocking everyone, without dropping the whole connection.
// shell
$ pscale branch connections kill-transaction mydb main <transaction-id>// gotcha
Postgres branches only. Verify the transaction_id against a fresh `connections show` first; the command re-checks server state but a stale ID is still wasted motion during an incident.