View Single Post

   
  #3 (permalink)  
Old 04-10-2008, 05:46 AM
Tom Lane
 
Posts: n/a
Default Re: pg_stat_activity

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote