Postgres Pro
Downloads
Home   >   mailing lists

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

From A. Kretschmer
Subject Re: View running Processes ?
Date
Msg-id 20060224094134.GB20718@webserv.wug-glas.de
Whole thread Raw
In response to View running Processes ?  (Arnaud Lesauvage <thewild@freesurf.fr>)
Responses Re: View running Processes ?
List pgsql-novice
Tree view 
am  24.02.2006, um 10:32:26 +0100 mailte Arnaud Lesauvage folgendes:
> Hi List !
>
> Is there an equivalent of mysql's "SHOW PROCESSLIST" command in
> PostgreS ?

select * from pg_stat_activity;
You should set
stats_command_string = on

in your postgresql.conf



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: View running Processes ?
Next
From: Arnaud Lesauvage
Date:
Subject: Re: View running Processes ?