BUG #5887: EXPLAIN returns more than 1000 rows when table is empty

From: "Nick Baryshnikov" <Warstone(at)list(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty
Date: 2011-02-15 17:22:31
Message-ID: 201102151722.p1FHMVuc035497@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5887
Logged by: Nick Baryshnikov
Email address: Warstone(at)list(dot)ru
PostgreSQL version: 8.4.7
Operating system: Ubuntu 10.10
Description: EXPLAIN returns more than 1000 rows when table is empty
Details:

CREATE TABLE test (
id bigserial NOT NULL PRIMARY KEY
);
VACUUM FULL ANALYZE test;
EXPLAIN ANALYZE SELECT * FROM test;
INSERT INTO test VALUES (DEFAULT);
VACUUM FULL ANALYZE test;
EXPLAIN ANALYZE SELECT * FROM test;

1-st EXPLAIN give me:
"Seq Scan on test (cost=0.00..31.40 rows=2140 width=8) (actual
time=0.003..0.003 rows=0 loops=1)"
"Total runtime: 0.040 ms"

2-nd:
"Seq Scan on test (cost=0.00..1.01 rows=1 width=8) (actual
time=0.004..0.005 rows=1 loops=1)"
"Total runtime: 0.025 ms"

VACUUM FULL ANALYZE didn't works when there is 0 records in the table?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-02-15 19:52:17 Re: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty
Previous Message Tom Lane 2011-02-15 17:18:07 Re: BUG #5885: Strange rows estimation for left join