Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > Does it give full queries, even if they're long? That would be really > useful sometimes. There is no mechanism other than pg_stat_activity for seeing what another backend is currently doing. In recent releases you can change track_activity_query_size to set the cutoff point for truncation of pg_stat_activity's copy of the current query. This is a straight tradeoff of shared memory space against capability, and I don't recommend raising the setting to the moon. But certainly you can make it higher than the default 1K. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
