Re: pg_stat_statements oddity with track = all

Поиск
Список
Период
Сортировка
От legrand legrand
Тема Re: pg_stat_statements oddity with track = all
Дата
Msg-id 1606916496022-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: pg_stat_statements oddity with track = all  (Julien Rouhaud <rjuju123@gmail.com>)
Ответы Re: pg_stat_statements oddity with track = all  (Sergei Kornilov <sk@zsrv.org>)
Список pgsql-hackers
Hi,

a crazy idea:
- add a parent_statement_id column that would be NULL for top level queries
- build statement_id for nested queries based on the merge of:
   a/ current_statement_id and parent one
or
   b/ current_statement_id and nested level.

this would offer the ability to track counters at any depth level ;o)
Regards
PAscal



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



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

Предыдущее
От: Ian Lawrence Barwick
Дата:
Сообщение: Re: proposal: function pg_setting_value_split() to parse shared_preload_libraries etc.
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Huge memory consumption on partitioned table with FKs