Re: Wrong rows count in EXPLAIN

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Пантюшин Александр Иванович <AI(dot)Pantyushin(at)gaz-is(dot)ru>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Тарасов Георгий Витальевич <Tarasov-G(at)gaz-is(dot)ru>
Subject: Re: Wrong rows count in EXPLAIN
Date: 2022-04-27 10:39:00
Message-ID: DDC7FAF0-76CF-4EE9-B145-A42926DBB6FE@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 27 апр. 2022 г., в 15:17, Пантюшин Александр Иванович <AI(dot)Pantyushin(at)gaz-is(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2022-04-27 10:43:43 Re: Wrong rows count in EXPLAIN
Previous Message Amit Kapila 2022-04-27 10:33:11 Re: bogus: logical replication rows/cols combinations