On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null?

From: Koen De Groote <kdg(dot)dev(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null?
Date: 2024-08-23 14:33:08
Message-ID: CAGbX52H8dDW8nVC8Zxg0-HFY58fAXd93XuxC83_DPHARZkpepw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running this query:

SELECT subname, received_lsn, latest_end_lsn,
last_msg_send_time, last_msg_receipt_time
FROM pg_catalog.pg_stat_subscription;

And "last_msg_send_time" will sometimes be null. All I can find in the
documentation is that this value represents: "Send time of last message
received from origin WAL sender; NULL for parallel apply workers"

But I have no context for what parallel apply workers are or why they are
NULL sometimes and other times not.

Can anyone explain?

Regards,
Koen De Groote

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Morris de Oryx 2024-08-23 14:36:21 Re: Is there a way to translate pg_amop.amopstrategy into a description?
Previous Message Arbol One 2024-08-23 11:55:02 Re: Where is my app installed?