Understand time taken by individual SQL statements in a procedure

Поиск
Список
Период
Сортировка
От Satalabaha Postgres
Тема Understand time taken by individual SQL statements in a procedure
Дата
Msg-id CAJ_W8nYO2K2Q2CNU=Cy_yVqOdeaY_fSyWyn0Rt_bBG=JMEfbfQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Understand time taken by individual SQL statements in a procedure  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Hi Listers,


We would like to determine how long it takes for each SQL statement to execute within a long-running procedure. I tried to see if pg_stat_statements could offer any insight into the matter. But I was unable to locate any. Is this even possible? How can we also determine the precise SQL execution plan used when a SQL is run from an application? The query runs without issue when we try to execute it directly, but it takes longer to run when an application is used.



Regards,

Satalabha

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: thousands of CachedPlan entry per backend
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Understand time taken by individual SQL statements in a procedure