The following bug has been logged on the website:
Bug reference: 18734
Logged by: Shawn C
Email address: shawncarter(at)onboardeng(dot)com
PostgreSQL version: 16.4
Operating system: Amazon Linux AMI
Description:
pg_terminate_backend failed to terminate active queries on a materialized
view until an "idle in transaction" backend tied to the same view was
terminated.