Missing pg_replication_origin

[dusatvoj]

Proposal

Use case. Why is this important?
I recently run into a problem. I'm using logical replication and physical replication together. I do monitoring of pg_replication_slots. I can also monitor if I run out of replication slots defined in pg_replication_slots ... but not in pg_replication_origin.

So when I run logical replication I currently can't monitor if I don't run out of logical slots at data warehouse. My data warehouse consists of many databases merged into single data analytics cluster. These databases are replicated logically (if it works) but sometimes I run into could not find free replication state slot for replication origin with ID ... and don't know about it.

Needed query is simple ... select count(*) from pg_replication_origin.