Killing long-running PostgreSQL processes
Commonly used commands for inspecting processes in PostgreSQL by querying the pg_stat_activity view in the pg_catalog schema. Find all active processes. SELECT * FROM pg_stat_activity WHERE state = 'active'; Cancel process by PID pg_cancel_backend()...
May 9, 20211 min read43
