Re: [despammed] Re: 'show full processlist' in postgres? - Mailing list pgsql-sql

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