Re: 'show full processlist' in postgres?

On Friday 01 July 2005 18:24, Jim Buttafuoco wrote:

> did you restart postgresql and use the pg_stat_activity view instead
> (just to save some typing).

No. Is a restart necessary or will a 'reload' do also the trick?

I've done the restart:

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

-- 
So long... Fuzz