The following bug has been logged online:
Bug reference: 5887
Logged by: Nick Baryshnikov
Email address: Warstone@list.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?