Re: pg_stat_statements query jumbling question

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: pg_stat_statements query jumbling question
Дата
Msg-id CAM3SWZRN_Mhyk0T+UUOec9ac7Vz8PwKDGEo8OTbRmGq-9b9WOA@mail.gmail.com
обсуждение исходный текст
Ответ на pg_stat_statements query jumbling question  (Satoshi Nagayasu <snaga@uptime.jp>)
Ответы Re: pg_stat_statements query jumbling question  (Satoshi Nagayasu <snaga@uptime.jp>)
Список pgsql-hackers
On Mon, Aug 31, 2015 at 8:32 PM, Satoshi Nagayasu <snaga@uptime.jp> wrote:
> Why don't we use relation name (with looking up the catalog)
> on query jumbling? For performance reason?

I think that there is a good case for preferring this behavior. While
it is a little confusing that pg_stat_statements does not change the
representative query string, renaming a table does not make it a
substantively different table.

There is, IIRC, one case where a string is jumbled directly (CTE
name). It's usually not the right thing, IMV.

-- 
Peter Geoghegan



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

Предыдущее
От: Satoshi Nagayasu
Дата:
Сообщение: pg_stat_statements query jumbling question
Следующее
От: Peter Eisentraut
Дата:
Сообщение: perlcritic