Re: Output affected rows in EXPLAIN

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: Output affected rows in EXPLAIN
Дата
Msg-id ABF246A6-E9C6-4562-9723-DE13CF2FA8F9@postgresql.org
обсуждение исходный текст
Ответ на Output affected rows in EXPLAIN  (Damir Belyalov <dam.bel07@gmail.com>)
Список pgsql-hackers
> On 6 Sep 2023, at 14:49, Damir Belyalov <dam.bel07@gmail.com> wrote

> The patch fixes this problem.

Given that EXPLAIN ANALYZE has worked like for a very long time, which problem
is it you have identified?

I'm also not convinced that the added "EXPLAIN" in the below plan is an
improvement in any way.

postgres=# explain (analyze) select * from t;
                                          QUERY PLAN
-----------------------------------------------------------------------------------------------
 Seq Scan on t  (cost=0.00..35.50 rows=2550 width=4) (actual time=0.064..0.075 rows=5 loops=1)
 Planning Time: 1.639 ms
 Execution Time: 0.215 ms
(3 rows)

EXPLAIN
postgres=#

--
Daniel Gustafsson




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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: Optimize planner memory consumption for huge arrays
Следующее
От: "Hayato Kuroda (Fujitsu)"
Дата:
Сообщение: RE: [PoC] pg_upgrade: allow to upgrade publisher node