| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
| Cc: | Cédric BUSCHINI <cbuschini(at)carax(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_stat_activity |
| Date: | 2006-02-02 16:19:16 |
| Message-ID: | 16283.1138897156@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> writes:
> Cdric 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cédric BUSCHINI | 2006-02-02 16:27:34 | Re: pg_stat_activity |
| Previous Message | Michael Fuhr | 2006-02-02 16:10:19 | Re: Postmaster errors |