Re: View running Processes ? - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: View running Processes ?
Date
Msg-id 20060224103711.GD20718@webserv.wug-glas.de
Whole thread Raw
In response to Re: View running Processes ?  (Arnaud Lesauvage <thewild@freesurf.fr>)
List pgsql-novice
am  24.02.2006, um 11:00:33 +0100 mailte Arnaud Lesauvage folgendes:
> A. Kretschmer a écrit :
> >select * from pg_stat_activity;
> >You should set stats_command_string = on
> >in your postgresql.conf
>
>
> Thanks Andreas ! Exactly what I was looking for !
>
> Since you don't mention it, I understand that there is no way to stop a
> running query from a postgresql wlient application ?

See my other answer, and you can set

statement_timeout = <timeout in ms>

Aborts any statement that takes over the specified number of
milliseconds. A value of zero turns off the timer.


See also:
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-novice by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Re: View running Processes ?
Next
From: Bruno Wolff III
Date:
Subject: Re: check problem