Re: pg_stat_activity - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_stat_activity
Date
Msg-id 16283.1138897156@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_stat_activity  (Brad Nicholson <bnichols@ca.afilias.info>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Postmaster errors
Next
From: Cédric BUSCHINI
Date:
Subject: Re: pg_stat_activity