Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Cancel a query

Cancel a running query without terminating the session.

Back to sheetBrowse commands
Sign in to save
Section: Monitoring and Statistics

Cancel a query

sql
sql
SELECT pg_cancel_backend(pid)
FROM pg_stat_activity
WHERE pid = 12345;
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Monitoring and Statistics
Terminate session
Force a backend to disconnect.
OpenIn sheetsqlsame section
Show active sessions
Inspect current sessions and queries.
OpenIn sheetsqlsame section
Inspect locks
Inspect lock acquisition and contention.
OpenIn sheetsqlsame section
Show database size
Measure one database's size.
OpenIn sheetsqlsame section
Show table and indexes size
Measure one relation including indexes and TOAST.
OpenIn sheetsqlsame section
Inspect bgwriter stats
Review checkpoint and buffer write statistics.
OpenIn sheetsqlsame section