Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] I can't cancel/terminate query. - Mailing list pgsql-general

From Edmundo Robles
Subject [GENERAL] I can't cancel/terminate query.
Date
Msg-id CAOXzpYC-nQ+_B8jUfe5-MZS4cuSH5hrQZwu_QQjLLq-EyKGc3g@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] I can't cancel/terminate query.  (Melvin Davidson <melvin6925@gmail.com>)
Re: [GENERAL] I can't cancel/terminate query.  (Jerry Sievers <gsievers19@comcast.net>)
List pgsql-general
Tree view
Hi!  i have  many  too long time queries,  the oldest  is  almost 16 days, so i  tried to cancel and terminate with pg_cancel_backend and pg_terminate_backend  but queries is still running.

STIME     ELAPSED ELAPSED %CPU   PID COMMAND
jun27 15-23:05:46 1379146  0.3 29660 postgres: argos_admin bdkairos 127.0.0.1(55605) SELECT                             
jun27 15-23:05:46 1379146  0.3 29659 postgres: argos_admin bdkairos 127.0.0.1(55604) SELECT                             
jun27 15-23:05:46 1379146  0.3 29658 postgres: argos_admin bdkairos 127.0.0.1(55603) SELECT                             
jun27 15-23:05:16 1379116  0.3 29909 postgres: argos_admin bdkairos 127.0.0.1(55767) SELECT                             
jun27 15-23:04:51 1379091  0.3 30097 postgres: argos_admin bdkairos 127.0.0.1(55909) SELECT                             
jun27 15-23:03:49 1379029  0.3 30661 postgres: argos_admin bdkairos 127.0.0.1(56303) SELECT        
...
What should  i do to safely close that  queries, before to use kill command in linux? 

I have Postgres 9.4  running on debian jessie.
 


--

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [GENERAL] Manage slot in logical/pglogical replication
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] Get table OID