Home > mailing lists

Explain returns different number of rows - Mailing list pgsql-performance

From	Vince McMahon
Subject	Explain returns different number of rows
Date	October 20, 2022 14:58:29
Msg-id	CAKS+vVaCxnCLpEruhkqwPWsh2YrhmL_3juriPP0ODwWDPfBR_g@mail.gmail.com Whole thread Raw
List	pgsql-performance

Tree view

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?

pgsql-performance by date:

From: hubert depesz lubaczewski
Date: 16 October 2022, 12:18:28
Subject: Re: Identify root-cause for intermittent spikes

From: Lars Aksel Opsahl
Date: 21 October 2022, 12:19:58
Subject: ogr2ogr slow sql when checking system tables for column info and so on.

Explain returns different number of rows - Mailing list pgsql-performance

Previous

Next