Re: Wrong rows count in EXPLAIN - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Wrong rows count in EXPLAIN
Date
Msg-id DDC7FAF0-76CF-4EE9-B145-A42926DBB6FE@yandex-team.ru
Whole thread Raw
In response to Wrong rows count in EXPLAIN  (Пантюшин Александр Иванович <AI.Pantyushin@gaz-is.ru>)
List pgsql-hackers

> 27 апр. 2022 г., в 15:17, Пантюшин Александр Иванович <AI.Pantyushin@gaz-is.ru> написал(а):
>
> Hi,
> >Which Postgres version do you use?
> I checked this on PG 11
> ...

> and on PG 13

Yes, I think before 3d351d91 it was impossible to distinguish between actually empty and never analyzed table.
But now it is working just as you would expect. There's an interesting relevant discussion linked to the commit
message.

Best regards, Andrey Borodin.

[0] https://github.com/postgres/postgres/commit/3d351d916b20534f973eda760cde17d96545d4c4




pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: bogus: logical replication rows/cols combinations
Next
From: David Rowley
Date:
Subject: Re: Wrong rows count in EXPLAIN