Re: track generic and custom plans in pg_stat_statements

Поиск
Список
Период
Сортировка
От Sami Imseih
Тема Re: track generic and custom plans in pg_stat_statements
Дата
Msg-id CAA5RZ0t-5LjHFsYML49Dg=gt97GJbMs1zVGi86YDmvsa4=oGFw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: track generic and custom plans in pg_stat_statements  (Andrei Lepikhov <lepihov@gmail.com>)
Ответы Re: track generic and custom plans in pg_stat_statements
Re: track generic and custom plans in pg_stat_statements
Список pgsql-hackers
> So, analysing
> pg_s_s data, it would be beneficial to determine if a generic plan is
> effective or not.

Yes, this is the point of adding these statistics to pg_s_s.

> In practice, with this knowledge, we can access the CachedPlanSource of
> the corresponding PREPARED statement via an extension and override the
> decision made in 'auto' mode. Unfortunately, we cannot obtain a pointer
> to plan cache entries for plans prepared by the extended protocol, but
> this may be possible in the future.
>
> So, I meant that the source of the plan is one important characteristic,
> and the type (custom or generic) is another, independent characteristic

The concepts of custom and generic plan types are associated with plan caches,
so they cannot have a different source. right?

--
Sami



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