Re: Output affected rows in EXPLAIN - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: Output affected rows in EXPLAIN
Date
Msg-id ABF246A6-E9C6-4562-9723-DE13CF2FA8F9@postgresql.org
Whole thread Raw
In response to Output affected rows in EXPLAIN  (Damir Belyalov <dam.bel07@gmail.com>)
List 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 by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Optimize planner memory consumption for huge arrays
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: [PoC] pg_upgrade: allow to upgrade publisher node