Query performance issue - Mailing list pgsql-performance

Hello all,

While executing the join query on the postgres database we have observed sometimes randomly below query is being fired which is affecting our response time.

Query randomly fired in the background:-
SELECT p.proname,p.oid FROM pg_catalog.pg_proc p, pg_catalog.pg_namespace n WHERE p.pronamespace=n.oid AND n.nspname='pg_catalog' AND ( proname = 'lo_open' or proname = 'lo_close' or proname = 'lo_creat' or proname = 'lo_unlink' or proname = 'lo_lseek' or proname = 'lo_lseek64' or proname = 'lo_tell' or proname = 'lo_tell64' or proname = 'loread' or proname = 'lowrite' or proname = 'lo_truncate' or proname = 'lo_truncate64')

Query intended to be executed:-

SELECT a.* FROM tablename1 a INNER JOIN users u ON u.id = a.user_id INNER JOIN tablename2 c ON u.client_id = c.id WHERE u.external_id = ? AND c.name = ? AND (c.namespace = ? OR (c.namespace IS NULL AND ? IS NULL))

Postgres version 11

Below are my questions:-

1. Is the query referring pg_catalog fired by postgres library implicitly?
2. Is there any way we can suppress this query?

Thanks and regards,

Dheeraj Sonawane

Mastercard

| mobile +917588196818