How Do You Associate a Query With its Invoking Procedure?

Поиск

Список

Период

Сортировка

От	Fd Habash
Тема	How Do You Associate a Query With its Invoking Procedure?
Дата	14 сентября 2018 г. 01:49:41
Msg-id	5b9abf54.1c69fb81.8e0e4.9e2d@mx.google.com обсуждение исходный текст
Ответы	Re: How Do You Associate a Query With its Invoking Procedure? Re: How Do You Associate a Query With its Invoking Procedure? Re: How Do You Associate a Query With its Invoking Procedure?
Список	pgsql-performance

In API function may invoke 10 queries. Ideally, I would like to know what queries are invoked by it and how long each took.

I’m using pg_stat_statement. I can see the API function statement, but how do I deterministically identify all queries invoked by it?

----------------
Thank you

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

От: Andres Freund
Дата: 14 сентября 2018 г., 01:43:47
Сообщение: Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours

От: Tim Cross
Дата: 14 сентября 2018 г., 04:41:18
Сообщение: Re: Performance of INSERT into temporary tables using psqlODBC driver