Re: How to use pg_stat_activity correctly ?

am 10.02.2006, um 15:30:02 +0700 mailte Luki Rustianto folgendes:
> Hi All,
>
> I try to query on pg_stat_activity but the returned result is only like this:
>
> teramedv2=> select * from pg_stat_activity where datname='teramedv2';
> datid | datname | procpid | usesysid | usename | current_query | query_start
> -------+-----------+---------+----------+---------+---------------+-------------
> 17178 | teramedv2 | 32727 | 103 | test | |
> 17178 | teramedv2 | 26848 | 103 | test | |
> 17178 | teramedv2 | 563 | 103 | test | |
> 17178 | teramedv2 | 26799 | 103 | test | |
> (4 rows)
>
> the field current_query and query_start seems to me always null ... I

stats_command_string = on
(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 ===