Magnus Hagander wrote:
2010/2/9 David Kerr <dmk@xxxxxxxxxxxxxx>:
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?
Thanks
Dave
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
