Summary Sort workers Stats in EXPLAIN ANALYZE

Поиск
Список
Период
Сортировка
От Jian Guo
Тема Summary Sort workers Stats in EXPLAIN ANALYZE
Дата
Msg-id BL0PR05MB5188210988EA15126C255B6DC4169@BL0PR05MB5188.namprd05.prod.outlook.com
обсуждение исходный текст
Ответы Re: Summary Sort workers Stats in EXPLAIN ANALYZE  (Jian Guo <gjian@vmware.com>)
Список pgsql-hackers

In current EXPLAIN ANALYZE implementation, the Sort Node stats from each workers are not summarized: https://github.com/postgres/postgres/blob/d4ba8b51c76300f06cc23f4d8a41d9f7210c4866/src/backend/commands/explain.c#L2762

When the worker number is large, it will print out huge amount of node details in the plan. I have created this patch to summarize the tuplesort stats by AverageSpaceUsed / PeakSpaceUsed, make it behave just like in `show_incremental_sort_group_info()`: https://github.com/postgres/postgres/blob/d4ba8b51c76300f06cc23f4d8a41d9f7210c4866/src/backend/commands/explain.c#L2890

Вложения

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Skipping logical replication transactions on subscriber side
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: [PATCH] add relation and block-level filtering to pg_waldump