Re: Add sub-transaction overflow status in pg_stat_activity

Поиск
Список
Период
Сортировка
От Zhihong Yu
Тема Re: Add sub-transaction overflow status in pg_stat_activity
Дата
Msg-id CALNJ-vTcuBoHMdRcURc8AqpyvAtJhOu0LgpehLHdri2EeL1bUA@mail.gmail.com
обсуждение исходный текст
Ответ на Add sub-transaction overflow status in pg_stat_activity  (Dilip Kumar <dilipbalaut@gmail.com>)
Список pgsql-hackers
Дерево обсуждения


On Mon, Dec 6, 2021 at 8:17 PM Dilip Kumar <dilipbalaut@gmail.com> wrote:
If the subtransaction cache is overflowed in some of the transactions
then it will affect all the concurrent queries as they need to access
the SLRU for checking the visibility of each tuple.  But currently
there is no way to identify whether in any backend subtransaction is
overflowed or what is the current active subtransaction count.
Attached patch adds subtransaction count and subtransaction overflow
status in pg_stat_activity.  I have implemented this because of the
recent complain about the same[1]

[1] https://www.postgresql.org/message-id/CAFiTN-t5BkwdHm1bV8ez64guWZJB_Jjhb7arsQsftxEwpYwObg%40mail.gmail.com


--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

Hi,

bq. there is a no way to 

Extra 'a' before no.

+    * Number of active subtransaction in the current session.

subtransaction -> subtransactions

+    * Whether subxid count overflowed in the current session.

It seems 'count' can be dropped from the sentence.

Cheers

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

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Add sub-transaction overflow status in pg_stat_activity
Следующее
От: Nikolay Samokhvalov
Дата:
Сообщение: Re: Add sub-transaction overflow status in pg_stat_activity