PostgreSQL provides function to terminate specific session on a server.
Find session ID
First we will identify the session we want to end. We do it by listing all sessions on the server with this query:
select * from v_monitor.sessions;
Result shows active sessions on server.
Now we will use session id to kill the session:
Vertica ends session and rolls back all transactions that are associated with it and closes the socket.