Skip site navigation (1) Skip section navigation (2)

Re: Killing a Query

From: Vikram <vvikram(at)stanford(dot)edu>
To: Brandon Hines <brandon(at)2i(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Killing a Query
Date: 2005-05-13 19:34:57
Message-ID: Pine.GSO.4.44.0505131233470.25942-100000@epic26.Stanford.EDU (view raw or flat)
Thread:
Lists: pgsql-admin
if i remember correctly, kill -TERM <the procpid of the query> should do
it. you can get the pid of the query process by looking at pg_queries
table

			Vikram

ps: be careful you dont kill -9 or some such.....


On Fri, 13 May 2005, Brandon Hines wrote:

>
> Is there a method for killing a query from the server.
>
> I have a number of users that manage to run queries that busy the server
> preventing a number of critical queries from running within an
> acceptable time limit.
>
> I would like to kill off the queries that appear to be busying the
> server without having to take postgres down altogether.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>


In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2005-05-13 19:36:28
Subject: Re: version 8.0.3
Previous:From: Anjan DaveDate: 2005-05-13 19:01:47
Subject: Re: Killing a Query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group