Re: Is it useful to record whether plans are generic or custom?

Поиск
Список
Период
Сортировка
От legrand legrand
Тема Re: Is it useful to record whether plans are generic or custom?
Дата
Msg-id 1589390892966-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Is it useful to record whether plans are generic or custom?  (Atsushi Torikoshi <atorik@gmail.com>)
Ответы Re: Is it useful to record whether plans are generic or custom?  (Atsushi Torikoshi <atorik@gmail.com>)
Список pgsql-hackers
Hello,

yes this can be usefull, under the condition of differentiating all the
counters
for a queryid using a generic plan and the one using a custom one.

For me one way to do that is adding a generic_plan column to 
pg_stat_statements key, someting like:
- userid,
- dbid,
- queryid,
- generic_plan

I don't know if generic/custom plan types are available during planning
and/or 
execution hooks ...

Regards
PAscal




--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SLRU statistics
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SLRU statistics