Transactions repeatedly query all types, causing significant delays.

The delays we're experiencing in certain transactions are due to the 'fetch types' functionality, which runs the following query:

select b.oid, b.typarray 
from pg_catalog.pg_type a 
left join pg_catalog.pg_type b on b.oid = a.typelem 
where a.typcategory = 'A' 
group by b.oid, b.typarray 
order by b.oid;

Each transaction re-executes this query, and when we tried disabling it, we encountered the following error: PostgresError: malformed array literal: "". The delay caused by this query is over 200ms on our side.

Is there any way we can mitigate this delay without triggering errors?

Start with the Postgres.js “fetch types” functionality and the shown pg_catalog query, then trace how disabling that lookup causes the malformed array literal error. Determine a safe way to avoid repeating the query for every transaction, and verify both that the error is avoided and that the reported delay is reduced.