Explain returns different number of rows

From: Vince McMahon <sippingonesandzeros(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Explain returns different number of rows
Date: 2022-10-20 16:52:12
Message-ID: CAKS+vVZuoYhwk1qkqFo6RCraCFbK2q1Td3OQqy8QxWRNZfZN5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

I did get reply so I am trying again.

I executed the following statements 3 times
> explain(analyze, buffet) select * from table1
>
> The number of rows are different. Is the table corrupted? How to confirm
> and how to fix it?
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2022-10-20 16:56:23 Re: Explain returns different number of rows
Previous Message Sebastien Flaesch 2022-10-20 15:55:48 Re: Creating LATIN9 database with PostgreSQL 15 on Windows

Browse pgsql-performance by date

  From Date Subject
Next Message Christophe Pettus 2022-10-20 16:56:23 Re: Explain returns different number of rows
Previous Message Vince McMahon 2022-10-20 11:58:29 Explain returns different number of rows