Sample Header Ad - 728x90

Understanding Heap Index in Postgresql

1 vote
0 answers
759 views
On Postgresql 12, given: postgres=# \d bip Table "public.bip" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | Indexes: "foo_idx_a" hash (a) I then ran a explain select ...: postgres=# explain select * from bip where a = 42; QUERY PLAN ------------------------------------------------------------------------- Bitmap Heap Scan on bip (cost=4.10..14.80 rows=13 width=4) Recheck Cond: (a = 42) -> Bitmap Index Scan on foo_idx_a (cost=0.00..4.10 rows=13 width=0) Index Cond: (a = 42) (4 rows) What is the meaning of the Recheck Cond: (a = 42) in the EXPLAIN output?
Asked by Kevin Meredith (569 rep)
Feb 28, 2021, 04:03 AM