Postgres Pro
Downloads
Home   >   mailing lists

Re: Explain returns different number of rows - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Explain returns different number of rows
Date
Msg-id 6B906119-82AD-49FC-A47D-8652FD03D936@thebuild.com
Whole thread Raw
In response to Explain returns different number of rows  (Vince McMahon <sippingonesandzeros@gmail.com>)
Responses Re: Explain returns different number of rows
List pgsql-general
Tree view 

> On Oct 20, 2022, at 09:52, Vince McMahon <sippingonesandzeros@gmail.com> wrote:
> The number of rows are different.

This isn't unexpected.  EXPLAIN does not actually run the query and determine how many rows are returned; it calculates
anestimate based on the current system statistics, which vary constantly depending on activity in the database.

pgsql-general by date:

Previous
From: Vince McMahon
Date:
Subject: Explain returns different number of rows
Next
From: Vince McMahon
Date:
Subject: Does standalone postfrsql have autogrowth/ manual growth on table space?