X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 950AE32A641 for ; Fri, 8 Oct 2004 14:54:16 +0100 (BST) 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 27480-01 for ; Fri, 8 Oct 2004 13:54:07 +0000 (GMT) Received: from neomail03.traderonline.com (email.traderonline.com [65.213.231.10]) by svr1.postgresql.org (Postfix) with ESMTP id D14B432A43E for ; Fri, 8 Oct 2004 14:54:09 +0100 (BST) Received: from [192.168.1.68] (64-139-89-109-ubr02b-epensb01-pa.hfc.comcastbusiness.net [64.139.89.109]) by neomail03.traderonline.com (8.12.10/8.12.8) with ESMTP id i98DK4o8011093 for ; Fri, 8 Oct 2004 09:20:04 -0400 Message-ID: <41669C00.2030209@ptd.net> Date: Fri, 08 Oct 2004 09:54:08 -0400 From: Doug Y User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Problems monitoring DB activity Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/126 X-Sequence-Number: 15119 Hello, When I do the following: SELECT * FROM pg_catalog.pg_stat_activity; The current_query and query_start columns are always empty. Obviously this makes it hard to monitor problems with the various admin tools, etc. I'm guessing there's a setting or something that needs updated, I just need a point in the right direction. DB is 7.4.2 Thanks