postgres=# SELECT client_addr, state, sent_location, write_location, replay_location 
           FROM pg_stat_replication; 

Ausgabe:

client_addr |   state   | sent_location | write_location | replay_location ------------+-----------+---------------+----------------+--------------
10.10.11.14 | streaming | 4C91/1700DF30 | 4C91/1700DF30  | 4C91/1700DE60
(1 row)

Siehe auch: https://blog.medianetix.de/2021/02/postgresql-pruefen-ob-replikation-laeuft/