Re: [GENERAL] I can't cancel/terminate query.

2017-07-13 Thread Melvin Davidson
On Thu, Jul 13, 2017 at 2:45 PM, Edmundo Robles wrote: > i executed the commands many times like superuser but that queries > still running :( > > On Thu, Jul 13, 2017 at 11:10 AM, Melvin Davidson > wrote: > >> >> >> On Thu, Jul 13, 2017 at 11:57

Re: [GENERAL] I can't cancel/terminate query.

2017-07-13 Thread Jerry Sievers
Edmundo Robles writes: > 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 >

Re: [GENERAL] I can't cancel/terminate query.

2017-07-13 Thread Melvin Davidson
On Thu, Jul 13, 2017 at 11:57 AM, Edmundo Robles wrote: > 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

[GENERAL] I can't cancel/terminate query.

2017-07-13 Thread Edmundo Robles
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