[GENERAL] ways of monitoring logical decoding performance

Поиск
Список
Период
Сортировка
От Weiping Qu
Тема [GENERAL] ways of monitoring logical decoding performance
Дата
Msg-id 7406e9ca-be3d-0eb7-69db-59b5d837d2f7@informatik.uni-kl.de
обсуждение исходный текст
Список pgsql-general
Dear all,

I'd like to monitor the resource utilization of logical decoding (e.g. 
in version 9.5).
For example, I'd like to see the wal buffer hit ratio, i.e. how much 
reading for logical decoding is from in-memory pages.
This can be set by blks_hit/(blks_read+blks_hit) from pg_stat_database.
But this values might include numbers incurred by other concurrent sessions.

Is there any clear manner to entirely focus on the performance of 
logical decoding?

Regards,
Weiping



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [GENERAL] Postgres 10.1 fails to start: server did not start intime
Следующее
От: Aron Widforss
Дата:
Сообщение: [GENERAL] Multiple unnests in query