pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Guido Barosio <gbarosio@sinectis.com.ar>
Cc: pgsql-admin@postgresql.org
Subject: Re: Strange scenary.
Date: Thu, 8 Jul 2004 09:46:46 -0700 (PDT)
Message-ID: <20040708093450.B95902@megazone.bigpanda.com> (raw)
In-Reply-To: <20040703181856.3c861bb4.gbarosio@sinectis.com.ar>
References: <20040703181856.3c861bb4.gbarosio@sinectis.com.ar>

On Sat, 3 Jul 2004, Guido Barosio wrote:

> Hi,
>
> 	This is the problem. I create a database from cero. I create a empty table, name students. I ask for an EXPLAIN
> on this new table, and the output of the query analyzer tells me that this table is filled with 1000 rows.
>
> 	So...why is that?

That's the default value set for the estimated number of rows; that row
count is the estimated rows based on the statistics not the actual
number of rows returned (see EXPLAIN ANALYZE's second set of numbers
for each step for that information) and you haven't run analyze to give it
more accurate statistics.



view thread (2+ messages)

Message-ID: <20040708093450.B95902@megazone.bigpanda.com>
Permalink:  ../20040708093450.B95902@megazone.bigpanda.com/
Also on:    postgresql.org/message-id/20040708093450.B95902@megazone.bigpanda.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: sszabo@megazone.bigpanda.com, gbarosio@sinectis.com.ar
  Subject: Re: Strange scenary.
  In-Reply-To: <20040708093450.B95902@megazone.bigpanda.com>
  References: <20040703181856.3c861bb4.gbarosio@sinectis.com.ar> <20040708093450.B95902@megazone.bigpanda.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox