Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
[postgresql] kill sessions
rodrigosantosbr
Dec 28th, 2018
146
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
PostgreSQL
0.15 KB
| None
|
0
0
raw
download
clone
embed
print
report
SELECT
pg_terminate_backend
(
pg_stat_activity.pid
)
FROM
pg_stat_activity
WHERE
pg_stat_activity.datname
=
'DATABASE_NAME'
AND
pid
<>
pg_backend_pid
(
)
;
Advertisement
Add Comment
Please,
Sign In
to add comment
Public Pastes
Untitled
54 min ago | 0.29 KB
December smells like money
CSS | 54 min ago | 0.29 KB
Untitled
1 hour ago | 62.47 KB
Kibana / Custom Visualization via Vega - Stre...
JSON | 3 hours ago | 1.82 KB
Kibana / Custom Visualization via Vega - Pie
JSON | 3 hours ago | 1.44 KB
Untitled
3 hours ago | 12.01 KB
Kibana / Custom Visualization via Vega - Pare...
JSON | 3 hours ago | 1.67 KB
Untitled
3 hours ago | 62.53 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!