Re: find query beening executed

On Thu, Oct 22, 2009 at 1:52 AM, Julius Tuskenis <julius@nsoft.lt> wrote:
> Hello,
>
> I'd like to know if it is possible to find out the query beeing processed
> for some connection? I know theres a "Select * from pg_stat_activity", but
> if query is very long it gets "cut" and it is the end of it that interests
> me.

I usually log long running queries which gets the whole thing. (I
think...)  Logs can get big if you set the minimum too low and log a
lot.  But the query only gets logged when it's done, so you might not
have the right connection afterwards.  But you'd have the query.