X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 13CF9529A6 for ; Fri, 1 Jul 2005 14:13:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52092-01 for ; Fri, 1 Jul 2005 17:13:42 +0000 (GMT) Received: from sponts0.iquer.net (mx0.iquer.net [195.234.230.66]) by svr1.postgresql.org (Postfix) with SMTP id 254C152971 for ; Fri, 1 Jul 2005 14:13:40 -0300 (ADT) Received: from smtp.iquer.net (sv8.int.iquer.net [10.0.11.80]) by sponts0.iquer.net (SPONTS v2.0.23) with ESMTP id 104D3639DEB-0 for ; Fri, 1 Jul 2005 17:13:38 +0000 Received: from ws1.int.iquer.net (ws1.int.iquer.net [10.0.16.220]) by smtp.iquer.net (Postfix) with ESMTP id E511510AE7F for ; Fri, 1 Jul 2005 19:13:37 +0200 (CEST) From: Erik Wasser To: pgsql-sql@postgresql.org Subject: Re: 'show full processlist' in postgres? Date: Fri, 1 Jul 2005 19:13:36 +0200 User-Agent: KMail/1.7.2 References: <200507011558.46408.erik.wasser@iquer.net> <20050701162340.M94433@contactbda.com> In-Reply-To: <20050701162340.M94433@contactbda.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200507011913.36840.erik.wasser@iquer.net> X-SPONTS-Version: 2.0.23 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/6 X-Sequence-Number: 21984 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