Re: View running Processes ?

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