am  01.07.2005, um 19:13:36 +0200 mailte Erik Wasser folgendes:
> postgres=#  SELECT * from pg_stat_activity ;
>   datid  |  datname  | procpid | usesysid |  usename  | current_query | 
> query_start
> ---------+-----------+---------+----------+-----------+---------------+-------------
>  7349453 | admintool |    5436 |      100 | admintool |               |
>  7349454 | postgres  |    5437 |        1 | postgres  |               |
> (2 rows)
> 
> But 'current_query' is still always empty... B-(

enable stats_command_string in your postgresql.conf


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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to