From: | digoal(at)126(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #9553: why bitmap index scan startup_cost=0? it's a bug? |
Date: | 2014-03-13 02:32:54 |
Message-ID: | 20140313023254.398.22475@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 9553
Logged by: digoal.zhou
Email address: digoal(at)126(dot)com
PostgreSQL version: 9.3.3
Operating system: CentOS 6.4 x64
Description:
Bitmap index scan need sort the indexenrty by heap_page_id first, then out
put the sorted heappageid to next node, but why bitmap index scan node's
startup_cost=0?
digoal=# explain (analyze,verbose,buffers,costs,timing) select id from t11
where id<10000;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on public.t11 (cost=93.95..354.20 rows=10020 width=4)
(actual time=1.447..3.907 rows=9999 loops=1)
Output: id
Recheck Cond: (t11.id < 10000)
Buffers: shared hit=22
-> Bitmap Index Scan on t11_pkey (cost=0.00..91.44 rows=10020 width=0)
(actual time=1.370..1.370 rows=9999 loops=1)
Index Cond: (t11.id < 10000)
Buffers: shared hit=8
Total runtime: 4.931 ms
(8 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | rdickson | 2014-03-13 02:59:42 | BUG #9554: won't connect |
Previous Message | digoal | 2014-03-13 00:54:29 | BUG #9552: IndexOnlyScan startup_cost>0, why not equal 0?it's a bug? |