ways of monitoring logical decoding performance

From: Weiping Qu <qu(at)informatik(dot)uni-kl(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: ways of monitoring logical decoding performance
Date: 2017-11-13 00:34:11
Message-ID: 7406e9ca-be3d-0eb7-69db-59b5d837d2f7@informatik.uni-kl.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Aron Widforss 2017-11-13 01:22:58 Multiple unnests in query
Previous Message Andres Freund 2017-11-12 21:03:09 Re: Postgres 10.1 fails to start: server did not start in time