Page 1 of 1

Terminate having Query

Posted: 07 Oct 2020, 09:16
by brid.surapol
หา processes ที่ run อยู่

Code: Select all

SELECT * FROM pg_stat_activity WHERE state = 'active';
kill process วิธีปกติ

Code: Select all

SELECT pg_cancel_backend(<PID>);
kill process วิธีแรง

Code: Select all

SELECT pg_terminate_backend(<PID>);