Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Terminate session

Force a backend to disconnect.

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

Terminate session

sql
sql
SELECT pg_terminate_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
Cancel a query
Cancel a running query without terminating the session.
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