Replication (logical)

Publications

select * from pg_publication;

Publication Tables

select * from pg_publication_tables;

Subscriptions

select * from pg_catalog.pg_subscription ;

Subscription Stats

select * from pg_catalog.pg_stat_subscription_stats;

Replication Lag/Performance Summary

select r.pid, r.usename, r.application_name, pg_current_wal_lsn(),
       pg_current_wal_lsn()-r.replay_lsn replay_lag_bytes,
       s.total_txns, s.total_bytes 
from pg_stat_replication r
     left outer join pg_stat_replication_slots s 
          on (r.application_name=s.slot_name);