| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Kill a Long Running Query |
| Date: | 2007-04-25 14:48:49 |
| Message-ID: | 20070425144849.GH12260@a-kretschmer.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-hackers |
am Wed, dem 25.04.2007, um 20:03:37 +0530 mailte Mageshwaran folgendes:
> Hi ,
> Any body tell me how to kill a long running query in postgresql, is
> there any statement to kill a query, and also tell me how to log slow
> queries to a log file.
pg_cancel_backend(pid int) to kill. You need to know the pid, you can
obtain the pid from pg_stat_activity.
To log slow querys you can set log_min_duration_statement to a propper
value, in ms. All querys with an execution time more than that logged.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-04-25 14:52:42 | Re: [HACKERS] Kill a Long Running Query |
| Previous Message | Simon Riggs | 2007-04-25 14:44:23 | Re: |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrei Kovalevski | 2007-04-25 14:49:31 | Re: query from a list of ids |
| Previous Message | Richard Huxton | 2007-04-25 14:46:48 | Re: Stored Procedure Speed |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-04-25 14:52:42 | Re: [HACKERS] Kill a Long Running Query |
| Previous Message | Mageshwaran | 2007-04-25 14:33:37 | Kill a Long Running Query |