Loading

query has taken the wrong joins and I am not able to stop it

Mallesh Mallu

Hi, My query has taken the wrong joins
and I am not able to stop it or kill it in postgre

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Accepted answer
try pg_terminate_backend()
+3
Sagar Lad5y ago
Hi Mallesh, You can check this : https://tableplus.com/blog/2018/08/postgresql-how-to-find-and-kill-hanging-query.html
0