BUG #18734: pg_terminate_backend was unresponsive for processes with the status "active"

The following bug has been logged on the website:

Bug reference:      18734
Logged by:          Shawn C
Email address:      shawncarter@onboardeng.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.