Significance of queries listed under server activity items

Поиск
Список
Период
Сортировка
От Adam Manwaring
Тема Significance of queries listed under server activity items
Дата
Msg-id CALgfX7Xx5doaWr30h+W_+K=MR-3=Ot5ARnKuAqY90zKYNUv16A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Significance of queries listed under server activity items  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-support
When viewing the details on a row on the "Server Activity" table an sql query is listed along with a few timestamps. I've been assuming that the query shown is the last active query for that session. What I don't know is whether it is the last one committed or the last one begun. I've had some trouble with sessions stuck in "idle in transaction" status. I need to know if the query is the query that has not been committed or if it is the previous query (committed prior to one that is stuck). 

I can't seem to find anything that says specifically what this query is, so I don't know whether I should be looking at the query shown to figure out what is going wrong or if I need to look elsewhere. 

Thanks for any help,
Adam

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

Предыдущее
От: JaeWon Lee
Дата:
Сообщение: .pgpass not working (CentOS7, pgAgent_96 )
Следующее
От: Dave Page
Дата:
Сообщение: Re: Significance of queries listed under server activity items