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:-
- Is the query referring pg_catalog fired by postgres library implicitly?
- Is there any way we can suppress this query?
Thanks and regards,
Dheeraj Sonawane
Mastercard
|
mobile +917588196818
CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient,
any disclosure, distribution or other use of this e-mail message or attachments is prohibited. If you have received this e-mail message in error, please delete and notify the sender immediately. Thank you.
