From Dev.to
Idle in transaction in Postgres: why pg_cancel_backend returns true and changes nothing
I build HeapDeck, an iPhone and iPad app for Postgres on call. You won't need it here: everything below runs in psql. The API slows down, then a migration hangs, and pg_stat_activity shows a session i...