pg_stat_statements

Поиск
Список
Период
Сортировка
От Dirschel, Steve
Тема pg_stat_statements
Дата
Msg-id DM6PR03MB43324F8A19B1EAE0BCAD7397FA519@DM6PR03MB4332.namprd03.prod.outlook.com
обсуждение исходный текст
Ответы Re: pg_stat_statements
Список pgsql-general

Hello,

 

I’m not sure if this is the correct distribution list for this type of question but I’ll try anyways.  We have an app that uses multiple schemas.  It will do a set schema ‘schema_name’ and execute queries.  The queries executed are the same regardless of the schema the connection set.

 

In pg_stat_statements the exact same query will get a different queryid for each schema that executes the query. 

 

I’m unable to determine which queryid comes from which schema the query was executed under.  Is anyone aware of a way to determine this?

 

Thanks in advance.

 

Steve

This e-mail is for the sole use of the intended recipient and contains information that may be privileged and/or confidential. If you are not an intended recipient, please notify the sender by return e-mail and delete this e-mail and any attachments. Certain required legal entity disclosures can be accessed on our website: https://www.thomsonreuters.com/en/resources/disclosures.html

В списке pgsql-general по дате отправления: