Explain returns different number of rows

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

> 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?
>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2022-10-20 12:45:45 Re: How to store "blobs" efficiently for small and large sizes, with random access
Previous Message Ron 2022-10-20 11:23:00 Re: How to store "blobs" efficiently for small and large sizes, with random access

Browse pgsql-performance by date

  From Date Subject
Next Message Vince McMahon 2022-10-20 16:52:12 Explain returns different number of rows
Previous Message hubert depesz lubaczewski 2022-10-16 09:18:28 Re: Identify root-cause for intermittent spikes