Please don't cross-post to multiple mailing lists. And pgsql-hackers is not the correct list for basic usage questions. And long end-of-mail disclaimers are not generally appreciated.

Mageshwaran wrote:
Any body tell me how to kill a long running query in postgresql, is there any statement to kill a query,

See the user manual on administration functions, pg_cancel_backend in particular:

Basically you issue a "SELECT * FROM pg_stat_activity", or plain ps to find out the pid of the backend executing the long running query, and then use pg_cancel_backend (or kill -INT) to cancel it.

and also tell me how to log slow queries to a log file.

Using the log_min_duration_statement configuration variable.

  Heikki Linnakangas

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to