Re: find query beening executed - Mailing list pgsql-admin

From Tom Lane
Subject Re: find query beening executed
Date
Msg-id 29752.1256221193@sss.pgh.pa.us
Whole thread Raw
In response to Re: find query beening executed  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Scott Marlowe <scott.marlowe@gmail.com> 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

pgsql-admin by date:

Previous
From: Lennin Caro
Date:
Subject: Re: cursor problem
Next
From: David Jantzen
Date:
Subject: Fwd: Reversing flow of WAL shipping