Thread: [GENERAL] ways of monitoring logical decoding performance

[GENERAL] ways of monitoring logical decoding performance

From
Weiping Qu
Date:
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