Search Postgresql Archives

Explain returns different number of rows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Explain returns different number of rows
From: Vince McMahon <sippingonesandzeros@xxxxxxxxx>
Date: Thu, 20 Oct 2022 12:52:12 -0400
In-reply-to: <CAKS+vVaCxnCLpEruhkqwPWsh2YrhmL_3juriPP0ODwWDPfBR_g@mail.gmail.com>
References: <CAKS+vVb5CsvV_ae_=TVu6cRZTTWbGv1mhoyaBDPGLFQbQ9J=JQ@mail.gmail.com> <CAKS+vVaCxnCLpEruhkqwPWsh2YrhmL_3juriPP0ODwWDPfBR_g@mail.gmail.com>

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?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Explain returns different number of rows
  - From: Christophe Pettus

Prev by Date: Re: Creating LATIN9 database with PostgreSQL 15 on Windows
Next by Date: Re: Explain returns different number of rows
Previous by thread: Creating LATIN9 database with PostgreSQL 15 on Windows
Next by thread: Re: Explain returns different number of rows
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux