Re: View running Processes ?

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: View running Processes ?
Date: 2006-02-24 09:41:34
Message-ID: 20060224094134.GB20718@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Arnaud Lesauvage 2006-02-24 10:00:33 Re: View running Processes ?
Previous Message Arnaud Lesauvage 2006-02-24 09:32:26 View running Processes ?