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 1589619695044-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: 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
> To track executed plan types, I think execution layer hooks
> are appropriate.
> These hooks, however, take QueryDesc as a param and it does
> not include cached plan information.

It seems that the same QueryDesc entry is reused when executing
a generic plan.
For exemple marking queryDesc->plannedstmt->queryId (outside 
pg_stat_statements) with a pseudo tag during ExecutorStart 
reappears in later executions with generic plans ...

Is this QueryDesc reusable by a custom plan ? If not maybe a solution
could be to add a flag in queryDesc->plannedstmt ?

(sorry, I haven't understood yet how and when this generic plan is 
managed during planning)

Regards
PAscal



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



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

Предыдущее
От: Christopher Baines
Дата:
Сообщение: Re: [PATCH] Fix pg_dump --no-tablespaces for the custom format
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Problem with logical replication