find query beening executed

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: pgsql-admin(at)postgresql(dot)org
Subject: find query beening executed
Date: 2009-10-22 07:52:09
Message-ID: 4AE00F29.6030207@nsoft.lt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-10-22 08:14:57 Re: find query beening executed
Previous Message David Jantzen 2009-10-22 03:52:59 Reversing flow of WAL shipping