[GENERAL] ways of monitoring logical decoding performance - Mailing list pgsql-general

From Weiping Qu
Subject [GENERAL] ways of monitoring logical decoding performance
Date
Msg-id 7406e9ca-be3d-0eb7-69db-59b5d837d2f7@informatik.uni-kl.de
Whole thread Raw
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: [GENERAL] Postgres 10.1 fails to start: server did not start intime
Next
From: Aron Widforss
Date:
Subject: [GENERAL] Multiple unnests in query