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. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
