Re: Logical Replication: SELECT pg_catalog.set_config Statement appears to be hanging

Hello Tom,

thanks for the clarification. We are stumbling about this in psql (11.11)

I have now searched the release logs to find out when this will be resolved.

I found the following matching entry:

https://www.postgresql.org/docs/14/release-14.html <https://www.postgresql.org/docs/14/release-14.html>
E.1.3.1.7. System Views
.....
Improve pg_stat_activity reporting of walsender processes (Tom Lane)
Previously only SQL commands were reported.

so we have to wait for psql14, or is there something else to this effect
in an earlier release, that I failed to find?

regards

Hannes

Am 18.05.2021 um 15:15 schrieb Tom Lane:
> =?UTF-8?Q?Hannes_K=c3=bchtreiber?=<h(dot)kuehtreiber(at)synedra(dot)com> writes:
>> Hello Tom, thanks for your answer!
>> We found out because we are monitoring long running queries, and saw it
>> had been running for a month before the restart yesterday.
>> I just queried pg_stat_activity and it seems to be running since then.
> Oh, that's because pg_stat_activity continues to show the last plain-SQL
> query executed by the session.
>
> I think we recently changed things so that replication commands
> would be shown in pg_stat_activity too, but evidently you're running
> a version older than that.
>
> regards, tom lane