How to determine which are "idle in transaction"

Поиск
Список
Период
Сортировка
От Mike Bridge
Тема How to determine which are "idle in transaction"
Дата
Msg-id 3C446A99.25BB5606@bridgecanada.com
обсуждение исходный текст
Список pgsql-general
When I do a "ps ax" I have 7 processes originating from my application
that are permamently "idle in transaction".   First off, is this
something to be concerned about?  It appears to be a vendor library
that's causing it.  Second, how can I tell what these stuck transactions
are?  Is there a way to list them?
(I'm using postgresql  7.1.3)

Thanks,

-Mike

--
Mike Bridge




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

Предыдущее
От: "Gregory Wood"
Дата:
Сообщение: Re: "IS NOT NULL" != "NOT NULL"
Следующее
От: "Harald Armin Massa"
Дата:
Сообщение: Different views with same name for different users