Query performance issue
От | Dheeraj Sonawane |
---|---|
Тема | Query performance issue |
Дата | |
Msg-id | DS0PR14MB7157B75FB7BFC4006204DC93F4A42@DS0PR14MB7157.namprd14.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: Query performance issue
|
Список | 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:-
- 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
Вложения
В списке pgsql-performance по дате отправления: