Re: Sample rate added to pg_stat_statements

Поиск
Список
Период
Сортировка
От Sami Imseih
Тема Re: Sample rate added to pg_stat_statements
Дата
Msg-id CAA5RZ0trJoVqGmELHOc=G2SxHQHKdTb1aAvzf3vHdfVP8UH+Xg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Sample rate added to pg_stat_statements  (Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>)
Ответы Re: Sample rate added to pg_stat_statements
Re: Sample rate added to pg_stat_statements
Список pgsql-hackers
> As you can see, the query has not been normalized. Is it a bug, expected or undefined behavior?

No, this behavior is expected. The ability to normalize a statement is
only available
during post_parse_analyze (pgss_post_parse_analyze), as this is when
we have access to
JumbleState.

In your example, pgss_post_parse_analyze is skipped and during the
subsequent \bind_named,
ExecutorEnd (pgss_ExecutorEnd) does not have access to JumbleState,
leading to the query to be stored without normalization.

It will be nice to make JumbleState available to all hooks, IMO.

--
Sami



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