Le 09/02/2010 17:05, David Kerr a écrit :
> Magnus Hagander wrote:
>> 2010/2/9 David Kerr <d...@mr-paradox.net>:
>>> It seems like pg_stat_activity truncates the current_query to about
>>> 1024 characters.
>>>
>>> The field is a text, so i'm wondering if there is a way to see the
>>> full query?
>>>
>>> (I know i can turn on log_statement=all, or
>>> log_min_duration_statement) but i'd like
>>> something that doesn't require a restart.
>>
>> The data isn't being tracked, so there is no way to show it. The
>> length of the query tracked can be found in the parameter
>> track_activity_query_size. Note that increasing that will obviously
>> increase the overhead of collecting it.
>>
>>
> 
> That's documented in 8.4, does anyone know if it's available in 8.3?
> 

No, it's a new feature of 8.4.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to