Resetting spilled txn statistics in pg_stat_replication
От | Masahiko Sawada |
---|---|
Тема | Resetting spilled txn statistics in pg_stat_replication |
Дата | |
Msg-id | CA+fd4k5_pPAYRTDrO2PbtTOe0eHQpBvuqmCr8ic39uTNmR49Eg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Resetting spilled txn statistics in pg_stat_replication
Re: Resetting spilled txn statistics in pg_stat_replication |
Список | pgsql-hackers |
Hi all, Tracking of spilled transactions has been introduced to PG13. These new statistics values, spill_txns, spill_count, and spill_bytes, are cumulative total values unlike other statistics values in pg_stat_replication. How can we reset these values? We can reset statistics values in other statistics views using by pg_stat_reset_shared(), pg_stat_reset() and so on. It seems to me that the only option to reset spilled transactions is to restart logical replication but it's surely high cost. It might have been discussed during development but it's worth having a SQL function to reset these statistics? Regards, -- Masahiko Sawada http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: