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 по дате отправления: