Re: find query beening executed

Поиск
Список
Период
Сортировка
От Julius Tuskenis
Тема Re: find query beening executed
Дата
Msg-id 4AE019FA.2050500@nsoft.lt
обсуждение исходный текст
Ответ на Re: find query beening executed  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: find query beening executed  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: find query beening executed  (Jaume Sabater <jsabater@gmail.com>)
Список pgsql-admin
Thank you. I'll ask to log long lasting queries, but still - isn't there
a way to see on what postgres works in real time?

2009.10.22 11:14, Scott Marlowe rašė:
> 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.
>
>


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



Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: find query beening executed
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: find query beening executed