Craig,
Your response was very helpful, thank you.
I was looking at some of the standard bits in Postgres like
txid_current_snapshot() and txid_snapshot_xmin(). Can the results from
txid_snapshot_xmin be used with pg_get_transaction_committime() to get the
latency?
Thanks again,
Steve Boyle
Steve,
The relevant change was made during the commit of logical decoding to
PostgreSQL 9.4, where the field of interest was renamed from 'xmin' to
'catalog_xmin'. It's around then that pg_stat_logical_decoding was renamed
to pg_replication_slots too.
To get lag in bytes, use:
SELECT slot_name,
I'm trying to follow the BDR monitoring docs:
https://wiki.postgresql.org/wiki/BDR_Monitoring
My postgres version string is (its from the 2nd Quadrant repo):
PostgreSQL 9.4.0 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit
My BDR plugin is version 0.8.0b
