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 82E84329EE6 for ; Fri, 8 Oct 2004 15:47:02 +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 46578-03 for ; Fri, 8 Oct 2004 14:46:53 +0000 (GMT) Received: from neomail02.traderonline.com (email.traderonline.com [65.213.231.10]) by svr1.postgresql.org (Postfix) with ESMTP id 783CB329F77 for ; Fri, 8 Oct 2004 15:46:56 +0100 (BST) Received: from [192.168.1.68] (64-139-89-109-ubr02b-epensb01-pa.hfc.comcastbusiness.net [64.139.89.109]) by neomail02.traderonline.com (8.12.10/8.12.8) with ESMTP id i98Ekr10029396; Fri, 8 Oct 2004 10:46:54 -0400 Message-ID: <4166A860.4080607@ptd.net> Date: Fri, 08 Oct 2004 10:46:56 -0400 From: Doug Y User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Michael Fuhr Cc: pgsql-admin@postgresql.org Subject: Re: Problems monitoring DB activity References: <41669C00.2030209@ptd.net> <20041008141129.GA60199@winnie.fuhr.org> In-Reply-To: <20041008141129.GA60199@winnie.fuhr.org> 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/128 X-Sequence-Number: 15121 Michael Fuhr wrote: >On Fri, Oct 08, 2004 at 09:54:08AM -0400, Doug Y wrote: > > >>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. >> >> > >Does postgresql.conf have stats_command_string = true? > Thanks, setting that did the trick.... whats the performance hit for having it enabled?