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:
http://www.postgresql.org/docs/8.2/interactive/functions-admin.html
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
EnterpriseDB http://www.enterprisedb.com