On Thu, Oct 22, 2009 at 1:52 AM, Julius Tuskenis <julius@xxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
