Re: Why are a lot of ROLLBACK queries in idle state

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Why are a lot of ROLLBACK queries in idle state
Дата
Msg-id o0mu37$bnq$1@blaine.gmane.org
обсуждение исходный текст
Ответ на Re: Why are a lot of ROLLBACK queries in idle state  (rajan <vgmonnet@gmail.com>)
Ответы Re: Why are a lot of ROLLBACK queries in idle state  (rajan <vgmonnet@gmail.com>)
Список pgsql-admin
Дерево обсуждения 
rajan schrieb am 18.11.2016 um 12:56:
> If the _session_ is idle then shouldn't it be removed from pg_stat_activity?

The session is only removed from pg_stat_activity when it's closed, i.e. when the client disconnects.

Being "idle" and disconnecting are two completely different things

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

Предыдущее
От: rajan
Дата:
Сообщение: vacuum full is not reclaiming the space and showing non-removable rows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: vacuum full is not reclaiming the space and showing non-removable rows