Scott Marlowe <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
