SEO

#1 (**permalink**) 04-10-2008, 12:50 AM

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

#2 (**permalink**) 04-10-2008, 12:50 AM

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
>

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#3 (**permalink**) 04-10-2008, 12:50 AM

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.
>

I guess I should have read today's messages before posting.

Thanks, Anjan, for answering my question before I could ask it.

Kill -s SIGINT <pid of offending statement>

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Killing a Query