Re: pg_stat_statements oddity with track = all

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: pg_stat_statements oddity with track = all
Дата
Msg-id 861161606917332@mail.yandex.ru
обсуждение исходный текст
Ответ на Re: pg_stat_statements oddity with track = all  (legrand legrand <legrand_legrand@hotmail.com>)
Ответы Re: pg_stat_statements oddity with track = all  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-hackers
Hello

> - add a parent_statement_id column that would be NULL for top level queries

Will generate too much entries... Every FK for each different delete/insert, for example.
But very useful for databases with a lot of stored procedures to find where this query is called. May be new mode track
=tree? Use NULL to indicate a top-level query (same as with track=tree) and some constant for any nested queries when
track= all.
 

Also, currently a top statement will account buffers usage for underlying statements?

regards, Sergei



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

Предыдущее
От: yuzuko
Дата:
Сообщение: Re: Autovacuum on partitioned table (autoanalyze)
Следующее
От: Nikolay Samokhvalov
Дата:
Сообщение: Re: pg_stat_statements oddity with track = all