X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 0462E9DCA52
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Feb 2006 12:19:24 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 98840-09
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Feb 2006 12:19:23 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 68A969DC9C9
	for <pgsql-admin@postgresql.org>; Thu,  2 Feb 2006 12:19:22 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k12GJGNj016284;
	Thu, 2 Feb 2006 11:19:16 -0500 (EST)
To: Brad Nicholson <bnichols@ca.afilias.info>
cc: =?ISO-8859-1?Q?C=E9dric_BUSCHINI?= <cbuschini@carax.com>,
	pgsql-admin@postgresql.org
Subject: Re: pg_stat_activity 
In-reply-to: <43E22CD7.4040909@ca.afilias.info> 
References: <43E22BB6.4030701@carax.com> <43E22CD7.4040909@ca.afilias.info>
Comments: In-reply-to Brad Nicholson <bnichols@ca.afilias.info>
	message dated "Thu, 02 Feb 2006 11:01:27 -0500"
Date: Thu, 02 Feb 2006 11:19:16 -0500
Message-ID: <16283.1138897156@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.51 required=5 tests=[AWL=-0.303, INFO_TLD=0.813]
X-Spam-Score: 0.51
X-Spam-Level: 
X-Archive-Number: 200602/19
X-Sequence-Number: 20440

Brad Nicholson <bnichols@ca.afilias.info> writes:
> Cédric BUSCHINI wrote:
>> 1 - "select * from pg_stat_activity ;" gives me serverals lines but 
>> all lines have <command string not enable> in current_query
>> I have set "stats_command_string" to true...
>> 
> Have you restarted the postmaster since making the change?  This setting 
> requires restart (reload will not work)

stats_start_collector requires that, but the other stats settings can
be changed on the fly...

			regards, tom lane