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?
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 |